Excel Tips

July 31, 2017

Excel can sort left to right

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

Excel Shortcuts - Ctrl Period to Jump to Next Corner »

July 26, 2017

Today's Excel Shortcut is another navigation trick. Once you have a large range selected, you can jump to the next corner of the selection using Ctrl+Period.

Troubleshooting VLOOKUP »

July 25, 2017

Excel VLOOKUP is powerful, but it won't work when you have specific situations. Today, a look at how to troubleshoot VLOOKUP.