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