Excel Tips


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().


Sort Left to Right »

July 31, 2017

Excel can sort left to right


Excel Shortcuts - Ctrl+Enter »

July 31, 2017

Today's article in Excel Shortcuts talks about using Ctrl+Enter after you finish typing a formula. Not Ctrl+Shift+Enter (array formulas), but just a straight Ctrl+Enter.


Custom Sort »

July 28, 2017

Using Cut and Insert Cut Cells is a slow way to rearrange rows


Excel Shortcuts - Current Region »

July 28, 2017

The next article in our list of Excel shortcuts involves the Current Region. Learn how to select all of the data set around the current cell.


Comparative Scatter Chart »

July 27, 2017

X-Y Scatter Charts with 2 series are difficult to create


Excel shortcuts - Ctrl+5 for Strikethrough »

July 27, 2017

I love to keep my To-Do lists in Excel. If you have a to-do list, you need a way to cross those things off the list. Strikethrough is the answer.


Paste New Chart Data »

July 26, 2017

Podcast 1978 introduced Custom List for the Fill Handle