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....
by Nate Moore | Oct 31, 2011 | Basics
There are four fast ways to paste data without getting your fingers sticky in Excel Video 205. Just like the past two videos, there is a keyboard shortcut (Control+V), an icon (a piece of paper and a clipboard), and a right-click option. You can also hit enter to...
by Nate Moore | Oct 26, 2011 | Basics
Excel Video 204 covers four fast, easy ways to COPY a cell or a range of cells in Excel. Control+c The Copy icon (look for two sheets of paper) Right-click and choose Copy Hold down the Control key while you drag. Just like last time, you don’t need to use all of...
by Nate Moore | Oct 24, 2011 | Basics
Excel Video 203 shows you 4 quick ways to CUT in Excel. Unfortunately none of the 4 tricks will CUT your taxes, but they may CUT the time you’re spending creating spreadsheets. You can cut using Control+x, by using the cut icon (look for the scissors), by...
by Nate Moore | Oct 19, 2011 | Basics
Excel Video 202 has QAT you need to know about customizing your QAT. It’s easy to customize the Quick Access Toolbar. Today I’ll show the different types of command buttons you can add to the QAT. We’ll use the Paste button as an example to show you how to simply...
