Sum Function Range
The SUM function can handle more than one range eg Instead of =SUM(A1:A100)+SUM(C1:C100) Use =SUM(A1:A100,C1:C100) will total both ranges.
Zoom Percentage Shortcut
To zoom into the currently selected range use Alt W G Pressed in sequence, not held down. To return to 100% zoom use Alt W J
Page Breaks
To insert a page break at the current cell use Alt P B I Pressed in sequence, not held down. To remove a page break use Alt P B R
Sort current table in order
To sort the current table by the selected column in ascending order, press in sequence Alt H S S Do not hold the keys down, press one after the other. To sort in descending order use Alt H S O
How to Identify Blank Cells in Excel
When developing formulas in Excel you often need to know when a cell is blank. There are different ways to check if a cell is blank, the one you chose will depend on what you are trying to achieve.
Format As Table
To apply the Format As Table option using the default format, select any cell within the table and use Ctrl + T Press Enter to confirm the range. Make sure the option “My table has headers” is ticked.
Select a hyperlink cell
To select a cell with a hyperlink, without following the hyperlink, simply click and hold the mouse button down as you click on the cell.
Excel Links and Deleted and Inserted Rows
When linking to another sheet, a deleted row can often cause a #REF! error. You can use the INDEX function to avoid these errors.
Selecting visible cell only
To select visible cells only first select the range and then press Alt + ; You can then copy and paste only paste the visible cells. Any visible formulas are converted to values.
Windows tip
To open Windows File Explorer hold the Windows key down and press E.
Returning from hyperlink
To return from following a hyperlink in Excel press F5 function key and then press Enter