July 25, 2008, Newsletter Issue #266: Save time when formatting in Excel

Tip of the Week

To save continually recreating the same formats each time you create a spreadhseet, use Excel´s built in Style function.

Apply the formatting you require to a cell or group of cells, then select those cells. Click in the Style Box on the toolbar next to the font selector (which will generally say normal), type a name for your style and press enter. The style can now be applied just by selecting the cells where you want to apply it and selecting your style name from the drop down list.

Note: Style names can´t contain spaces or hyphens - use underscores or capital letters instead.

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Patricia Walters-Fischer