Spreadsheet Tips and How-tos
This page will give you some instructions for things
that you may not know how to do with spreadsheets. You can also use
the Help section of the program for more information.
| autosum | Put your mouse in the cell where you want your answer. Then go up to the E shaped icon and click to autosum column. |
| fill | Click on certain cell and go up and click on the paint bucket and pick a color. Click "No Fill" to turn cell back to white. |
| format cells | Choose format from the menu toolbar. Then follow the menus to change the fonts, colors or alignment. |
| formulas | Type in = and then enter the equation. |
| graph | Go up and click on chart icon to pick different graphs. |
| gridlines | To show the cell lines when printing, go to file, page setup - sheet and click on gridlines. |
| hiding cells | Hide rows by going to Format, Column, Hide. |
| make corrections | Go up to the formula bar and click in the space where you want to correct something. |
| save work | Go up to File - Save as - and name the document. Once it is saved, just click on the save icon after any changes. |
| sort | Click on icon A-Z or Z-A to put column in order. Note: When you want to sort two columns next to each other highlight both columns or it will only organize one column. |
