If you need to fill cells with sequential text such as months of the year, days of the week, or text plus a number such as Quarter 1, Quarter 2,…, use the fill handle to quickly create labels for the cells simply by typing the first item in the series. For example, you would type January in your first cell, then hover the mouse over the bottom right hand corner until it … [Read more...]
Change Text Case to lower, UPPER, or Title Case
Do you want to have a list of information in all CAPITAL LETTERS, all lower case, or All In A Title Format? This would be an extremely tedious task if, say you have 100+ lines that need to be updated. With these macros, you can select the cells you wish to update and change their case in a flash! Note: These macros won't change the output of a cell with a formula in … [Read more...]
Set Excel Zoom Level
OK, so your co-worker or boss has one of those enormous monitors, and you're stuck working on this little tiny laptop screen. Every time they open a file, they change the zoom setting to 50%, because heaven forbid they look at things any other way. Then, they go ahead and save the file at a 50% zoom. The next time you open the file, you're squinting to try to see the little … [Read more...]
Cell References in Formulas
When you enter a cell reference into the formula bar, you can press the F4 button to make the reference either absolute, mixed, or relative. This helps your formula work as expected when you copy the formula to another location. Absolute references look like this: $A$1, where the dollar signs ($) indicate that when copying a formula to another cell, Excel should not change … [Read more...]
Adding Comments
Adding comments to your worksheet allows you to share your thoughts with other users, or to serve as a reminder for yourself. Right click the cell where you want to insert the comment, and begin typing in the box that appears. Click off the cell and you'll see a little red triangle in the upper right hand corner of the cell where you just inserted a comment. This is a visual … [Read more...]