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 noncontiguous cells. If you want to select contiguous cells, the Shift key is your friend. Watch Excel Video 208 to see how to use the Shift key to easily select rows, columns, or a square of cells. Once you have the data selected, you can cut, copy, paste, or format paint to your heart’s content.
These are great shortcuts as the amount of data you’re trying to select increases. Stay tuned. Next time I’ll show you a shortcut for really large groups of data.