by Nate Moore | Nov 14, 2011 | Basics
You might not hear a quarterback yell Shift + End + Arrow key this weekend, but after watching Excel Video 209 you might try it instead. Holding down the Shift key, the End key, and an arrow key will cause Excel to select all of the cells in the direction of the arrow...
by Nate Moore | Nov 9, 2011 | Basics
You may not be able to spell noncontiguous without a spell checker, but you’ll know what it means after watching Excel Video 208. Noncontiguous simply means “not next to each other” and if you hold down the Control key while selecting cells, it’s easy to select...
by Nate Moore | Nov 7, 2011 | Basics
Few features in Excel will save you as much time as the Format Painter, the topic of Excel Video 207. The Format Painter simply copies the format from one cell to another. The format includes the way the cell is displayed (font, font color, font size, cell color,...
by Nate Moore | Nov 2, 2011 | Basics
If you’d like to know what’s so special about Paste Special, watch Excel Video 206. When you want to change the default way that Excel pastes cells, use Paste Special. For example, when Excel sees that cells contain a formula, Excel pastes those cells as a formula....