by Nate Moore | Mar 28, 2012 | Basics
Freeze Panes is a great way to take the pain out of navigating around a large spreadsheet in Excel Video 244. Freeze Panes is a way to lock in rows and/or columns so that when you scroll down or to the right you still see the row and column headings you need to make...
by Nate Moore | Mar 26, 2012 | Basics
AutoCorrect is a great trick that will save you from frustration and save you time, all in Excel Video 243. AutoCorrect is a feature built into Excel to correct things like typos and misspellings. AutoCorrect is a great thing until you get burned by typing CNA and...
by Nate Moore | Mar 21, 2012 | Basics
Excel Video 242 has another data entry shortcut to make your life easier. Excel calls the feature AutoComplete. AutoComplete looks at text you’ve already entered and uses that to anticipate what you intend to enter as you start typing. For example, if Blue Cross is in...
by Nate Moore | Mar 19, 2012 | Basics
Excel Video 241 will help you make entering data easier by controlling what happens after you hit Enter in Excel. Instead of hitting an arrow key to move to the next cell, you can get Excel to move to the next cell for you as you enter data. If you have a long list of...
by Nate Moore | Mar 14, 2012 | Basics
There seem to be several ways to do everything in Excel. Excel Video 240 has another way to work with Comments that may be helpful for you. If you go to the Review tab, the middle section includes a variety of ways to work with Comments. Most of the functionality on...
