Recently I experimented with using the online spreadsheet available in Google Apps to manage our price list. I’ve been very surprised by the functionality & ease of use. For many years I saw these online apps as merely viewing tools to open documents when on the road. But after using it for over a week […]
If you have a Google spreadsheet that you want to hide the gridlines, simply go to the View Menu, select Gridlines & toggle the checkmark to off. It’s that easy!
If you have a spreadsheet with a column of full names, you can split that column into separate first name and last name columns. Firstly, add the extra column to the right of the names you want to split. This provides a column for the separated names to be added. Next, highlight the column of […]
When you copy cells in a spreadsheet, it will by default increment the value by one for each entry. For example, if you copy 100, the next entry will be 101, then 102, etc. To copy cells in excel without incrementing the value, add $ in front of the value in the cell.
Whenever you enter a spreadsheet formula such as adding a series of values using: =SUM(A1, B11, C7:C17) you can simply enter “=SUM(” then Control-clicking each reference. By holding down Control (or Command on a Mac) as you click each reference, the spreadsheet will automatically enter commas necessary for the formula argument.
Navigating a large spreadsheet can be slow & tedious. Jump to the first cell by using the keyboard shortcut Control + Home, Command + Home on a Mac. To jump to the last cell use Control + End, Command + End on a Mac.
To insert a new row or column, simply highlight the entire row, then use the keyboard shortcut “Control” + “+”. To delete a row, simply highlight the row, then type “Control” + “-“. Exactly the same procedure applies for adding or deleting columns.
You can use Control + Arrow key (Command + Arrow key on a Mac) to move in any direction to the edge of the data range. The curser will jump to the next data range if there are empty cells, or the end of the spreadsheet if all the cells are filled.
Colour coding worksheet tabs can make it easier to identify specific sheets. Simply right-click on the sheet tab, choose Tab Colour, then select the colour for the tab. From the same menu, you can also hide sheets that you may not need to see on a regular basis, such as those carrying out background calculations […]