Excel Tips


Excel Shortcuts - Non-Contiguous Cells »

August 7, 2017

Today's article covers how to select non-contiguous cells in Excel. Sure - you can hold down Ctrl while selecting multiple ranges. But there are other ways.


Copy Subtotals »

August 4, 2017

Copy subtotals.


Excel Shortcuts - Next Worksheet »

August 4, 2017

How to jump to the next (or previous) worksheet in Excel. This is the next in our series of keyboard shortcut tricks for Excel.


Format Subtotal Rows »

August 3, 2017

Excel bolds one column on the Subtotal Rows


Excel Shortcuts - AutoSum »

August 3, 2017

Excel faster way to AutoSum. This is an Excel keyboard shortcut for summing data.


Fill Text on Subtotals »

August 2, 2017

If you need additional text on a subtotal row


Excel Shortcuts - Active Cell »

August 2, 2017

Excel - bring the active cell back in to view. It is easy to find that you can no longer see the active cell. This trick will bring the active cell back in to view.


Sort Excel Subtotals »

August 1, 2017

Thanks to Derek Fraley from Springfield MO for this tip


Excel Shortcuts - Time & Date »

August 1, 2017

How to enter the current time or date into a cell. This method is a shortcut key and is often superior to using NOW() or TODAY().