Sort month names in Excel

Sort month names in Excel

If you sort a list of month names in Excel, will January or April be first? No fooling, April is the first month, alphabetically. So, if you are not careful, sorting a list of month names may not get you what you wanted. You can however follow these steps to ensure...
Quickly fill in the blanks

Quickly fill in the blanks

Have you ever had a need to quickly fill in the blanks of a spreadsheet? For example, suppose you need to fill in all the blank regions, store names, and order numbers with the value from the previous cell as shown in the image above. It is true you can “easily” fill...
The wonders of Ctrl G

The wonders of Ctrl G

When I teach an Introduction to Excel course, I challenge my students to a race, and then I cheat. I first teach them about the arrow keys: the down arrow moves the cursor down one cell, and the up arrow goes up, and the left and right arrows go left and right. We...