Wednesday, February 12, 2014
Three Quick Tricks!
This week we are going to take a look at a medley of tricks that do not necessarily fall into any neat category. All they do is Save You Time and Make Your Excel Life a Little Easier.
1. Lock Your Formatting
Using the Format Painter is a terrific way to save time adding a professional look to your worksheets. When you format and select a cell, you can click Format Painter and paste the formatting into any single cell.
The Trick that many Excel users do not know is that if you Double-Click the Format Painter, it will Lock the formatting so you can apply it to as many cells as you like! Piece of Cake!
2. Move the Quick Access Toolbar
Okay, you've customized the Quick Access Toolbar, but you don’t like having it way up in the upper-left corner (after all, why stretch all the distance with your mouse!).
You can opt to have it displayed at the bottom of the ribbon by simply clicking on Show Quick Access Toolbar below the Ribbon in the dropdown menu of the Quick Access Toolbar. Easy as Pie!
3. Prevent Error Checking
The Error Checking function in Excel is highly useful for pointing out Inconsistent Formulas in a particular range. There are times, of course, when you may need to omit a range’s formula in a few cells. Excel will then Flag what it perceives as an Error!
To avoid this annoyance, go to Excel Options and choose the Formulas group. Simply clear any of the error-checking rules that are bugging you. Piece of Cake!
Three Quick Tricks. It’s all Cake and Pie!