SPREADSHEET MAINTENANCE (for hiking chair only):
|Preserve alphabetical order: right click on the name below your alphabetical spot.|
|On the 'insert' menu, choose insert row above.|
When the blank row appears, type last name, comma, first name.
|Please do not alter "LAST HIKER", "SAMPLE HIKER"|
|After a new hiker is added, click the cell above. In the lower right, put the '+' cursor over the little square in hte lower right, grab the box and drag the 'formula' to the new cell(s) for their total column.|
To add a "comment" box to a cell:
|Click on the cell, then choose "insert" from the menu, then "comment".|
To fix an incorrect alphabetization (move a hiker!):
Order is very important! First, create a blank row as specified above. Second, right click on the number of the row you want to move (this selects the entire row).
Third, select "cut"; Fourth, right click on the number of the newly created blank row, choose paste.
Back up this spreadsheet occasionally to your computer!
in the menu: FILE > DOWNLOAD AS > EXCEL
TO ADD COLUMNS TO THE RIGHT:
Highlight the last 26 columns (e.g., CA thru CZ) by clicking in the row with CA, CB, CC, etc.
(You can click on all 26 individually, or click on CA, then shift-click on CZ, to do them all at once)
Then right-click somewhere in the CA-CZ row. And select "insert 26 right".
26 new columns will then appear to the right.