Bold
Highlight the area or cells you want to bold. Click on the button with the B on it. This button is located on the toolbar at the top middle of the spreadsheet.
Column Width
To make the column wider, click on the letter of the column you want to change and go to the title header called Format then choose Column and then Auto-Fit Selection.
Currency ($)
To set your values to currency, highlight the area or cells you want set to currency and click on the button with the $ on it. This button is located at the toolbar on the top middle of the spreadsheet.
Delete (rows, columns, formulas)
To delete (rows, columns, etc), first make sure you are in the row or column you want deleted. Choose Edit from the toolbar, and then Delete. It will ask whether you want to delete a row or a column.
Fill Down
There are 2 ways to fill down. One way is to go to the lower right corner of the cell (notice there is a little black box). When you put your mouse over it, the crosses changes from a thick white cross to a thin black cross. While the cross is black, click on your far left button and pull down. Release the button for answers to fill in.
Insert (rows or columns)
First locate where you want to insert the row or column. Choose the Insert option at the top of the spreadsheet, then choose either row or column.
Opening a File
At the top of your excel window, choose "File" then "Open"
Saving a File
If this is the first time you are naming the file:
At the top of your excel window, choose "File" then "Save As"
If you have already given your file a name and just want to save the changes:
At the top of your excel window, choose "File" then "Save"
Formulas
Formulas always start with an equal sign = followed by the formula.
* |
Multiplication |
/ |
Division |
+ |
Addition |
- |
Subtraction |
######
If you get this in any cell, it means your column is not wide enough to display the answer. To make the column wider, click on the letter of the column you want to change and go to the title header called Format then choose Column and then Auto-Fit Selection.
Currency
If you accidently set something to currency and would like to undo the mistake, choose "Format"