Consider using the computer calculator
Many of us use a desk calculator regularly. For years I’ve had a calculator on my desk, right next to my computer, […]
Category: Spreadsheets
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 […]
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 & […]
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 […]
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 […]
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(” […]
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, […]
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 […]
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 […]
Spreadsheets: Navigating your worksheet
Keyboard shortcuts are a great way to save time in almost any software package. After you have learned the shortcuts, you will […]