Using the spreadsheet in Google Apps

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 […]

Turn off gridlines in Google Sheets

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!

Spreadsheets: How To Split Text into Different Cells

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 […]

Spreadsheets: How to copy cells without incrementing the value

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.

Spreadsheets: Use Control + Click to enter a formula argument

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.

Spreadsheets: Jump to the First or the Last Cell

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.

Spreadsheets: Adding or Deleting Rows or Columns

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.

Spreadsheets: Move to the edge of the data region

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.

Spreadsheets: Change the colour of worksheet tabs

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 […]