Spreadsheet Note Type
Some tips for using the spreadsheet note type:
Comments
You can use the "edit comment" command to add, edit or delete a comment. To delete a comment, edit it and clear all comment text.
Sorting by multiple columns
To sort by multiple columns, sort each column in reverse order. For example, if you want to order by columns titled "surname, first name, age" then sort the columns one by one in this order: age, first name, surname.
Moving columns
You can move entire columns (right or left) and rows (up or down). You don't need to select the entire row/column. The currently selected cell determines which row/column will be moved. You can also move multiple columns or rows at the same time. To do this, select a range of cells, and then click on the desired move action.
Fill
The "Fill" action copies a formula from one cell to another, and at the same time adjusts the formula to be relative to the destination cell (i.e. the cell that the formula is being copied to). For "Fill" to work properly a rectangular region must be selected. Refer to the images below:
|
|
Fill Down |
Fill Right |
|
|
Fill Up |
Fill Left |
Before using the "Fill" command, a section of the grid is selected that includes 2 regions: 1. cells with a formula (yellow), 2. cells to which the formula will be copied (light blue) - usually blank. The cells with the formula must be in a straight line, and next to each other. Use the appropriate command depending on where the formula cells are situated and on which direction you want to apply the formula. |
