Tuesday, December 27, 2011
Excel Quick Tricks!
I have always appreciated brief “Aha!” tricks that can reveal a Quick Easy Way to accomplish a task in Excel. Here are four little known or used tricks, plus the results of a survey:
1. Select Noncontiguous Cells
Selecting noncontiguous cells in a worksheet is simple by holding down the CTRL key and click on the cells you want.
2. Format Individual Characters
Click the F2 key and use your cursor to highlight the character to want to format. Right-click and the Format drop down menu is at your command!
3. Align Text Your Way!
Once again, Right-Click and use access the Alignment tab on Format Cells. It’s a Snap Aligning your text in any orientation you want.
4. Save Your Chart as a Picture
Do you want to Use Your Chart in Another App or location? Copy / Paste as a Picture, and feel confident it will stay true to the original (and take up less space…).
Extra: Survey Results
I set up a survey of More than 3,000 business folks recently. Over 82% of the responders voted that being efficient in Excel can help you in your job “A Great Deal” or “To a Large Extent”.
That survey philosophy can make you glad you are an Excel Enthusiast!