Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
If you want to quickly select a column of your spreadsheet, there are two ways you can do it. Perhaps the easiest way (if you already have your hand on the mouse) is to click on the column letter at the top of the column. For instance, if you want to select column C, you would click on the C column header.
The other method works great if you are working in a particular column and your hands are on the keyboard. All you need to do is press Ctrl+Space Bar and the entire column is automatically selected.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1922) applies to Microsoft Excel versions: 97 2000 2002 2003
Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.