To Retrieve A File In Excel:
Press Alt + F.
Press O for Open.
Press Tab 3 times.
Type A for your diskette, press Enter.
Select the file by using the arrow keys, press Enter.
To Save A File In Excel:
Press Alt + F.
Press A to Save As.
Type A for your diskette, press Enter.
Type in a desired name under file name, press Enter.
NOTE: All files will be saved with the extension .xls
To Remove Gridlines From Printout:
Press Alt + F.
Press U for Page Setup.
Use the (® )right arrow key to highlight Sheet.
Use the Tab key to highlight Gridlines.
Press the Spacebar, press Enter.
To Delete Row(s): (one at a time)
Click right mouse button.
Click on Delete, Select Entire Row.
Press Enter, or click on OK.
To Insert Row(s):
Click right mouse button.
Click Insert, Select Entire Row.
Press Enter, or click on OK.
Copying Cells:
Highlight cell you want copied.
Click right mouse button on cell, select Copy.
Go to a cell, click right mouse button, select Paste.
* To get rid of moving box around cells after copying & pasting, press ESC key
.
To Print Landscape:
Press Alt + F.
Press P for Print.
Press Tab key to highlight Page Setup, press Enter.
Use Tab key to highlight Portrait selection.
Use right arrow key to select Landscape, press Enter.
To Remove Header and Footer:
Press Alt + F.
Press P for Print.
Use Tab key to highlight Page Setup.
Use right arrow key to select Header/Footer.
Press Tab key to highlight Header.
a) Press (¯ ) down arrow key for menu.
b) Use ( ) arrow key to highlight NONE.
Hit Tab key to Highlight Footer.
Follow steps (a) and (b).
Hit Tab key, press Enter.
To Perform Calculations In Excel:
Addition:
Go to an empty cell.
Type: =(1st cell position + 2nd cell position),
press Enter.
for example: =(A20 + b15)
Addition of a column of Numbers:
Go to an empty cell.
Type: =SUM(1st cell position : 2nd cell position),
press Enter.
for example: SUM(B2:B5)
*This will give the sum of all numbers in cells B2 to B5.*
Subtraction:
Go to an empty cell.
Type: =(1st cell position - 2nd cell position), then
press Enter.
for example: =(D4 - B12)
Multiplication:
Go to an empty cell.
Type: =(1st cell position * 2nd cell position),
press Enter.
for example: =(E2 * F7)
Division:
Go to an empty cell.
Type: =(1st cell position / 2nd cell position),
press Enter.
for example: =(D2 / B2)