|
If you're tired of reformatting Excel cells over and over with the same format, then take heart because you don't have to any longer! If you want to format each cell containing a sum total with a single line top border and a double-line bottom border you can do that! If you want the total results to be in currency format you can do that too! To create a style that will automatically format these cells for you, follow these steps: - Click on one of the total cells in your worksheet.
- Go to Format | Style.
- In the Style name box, type Total cell.
- Click Modify.
- Under the Number tab, select Currency.
- Under the Border Tab, select Single Line under Line styles and click the Top Border button on the menu to the left.
- Select the Double Line under Line styles, then click the Bottom Border button. on the left.
- Click OK twice.
When you want to format a total cell, select the cell and go to Format | Style, choose Total Cell from the drop-down list and click OK. This feature won't save you much time if you have to do it for every workbook. Luckily, you can copy the style to any other workbook by following these steps: - Open the workbook that contains the already defined style.
- Open the workbook to where you would like to copy the style.
- In the workbook where you want to copy the style, go to Format | Style. Click Merge.
- Select the other open workbook from the list and click OK.
If you want to have your named styles available to all worksheets, you can merge them to an Excel template file.
Visit Carol's web site to learn more tips like this one!
-- Related newsletter articles:
2006/04/07 Missing WordPad?, Part 2 (open)
2005/02/16 View digital photos in home DVD player? (format)
2004/04/23 MRU path in windows dialogue? (open)
2006/06/07 Adobe Expected to Sue Microsoft (format)
2006/03/07 Accentuate Headlines in MS Word! (border)
2006/04/28 What to do if your Hard Drive Fails (format)
2004/08/25 Receive newsletter in full? (format)
2006/06/03 Microsoft's Windows Media Photo (WMPhoto) to replace ... (format)
-- Recent articles (from all channels): 2008/05/12 Today in History: for Monday, May 12, 2008
2008/05/12 [ShellX 20080512]: 'Remote Manager', and 'Cyber Bandwidth ...
2008/05/12 Video Gaming Trade Group Struggling
2008/05/12 T-Mobile Finally Joins 3G Phone Race
2008/05/12 Apple Slammed by Environment Watchdog
2008/05/09 [ShellX 20080509]: 'Advanced Run', and 'Diver Windows Manager'
2008/05/09 Texas Refuses Facebook Friend Request
2008/05/09 Photo-Enforcement Technology Replaces Officers On Patrol
2008/05/09 Cuban Government Says 'Ok Computer'
2008/05/09 Excel Can E-Mail Your Weekly Reports For You!
2008/05/08 [ShellX 20080508]: 'Shell Enhancer', and 'Lansweeper'
2008/05/08 Xobni: MS Outlook Social Networking Technology for your Inbox
2008/05/08 Music Companies Jump on GTA IV Bandwagon
2008/05/08 Fascinating: Memristor to replace Binary
2008/05/08 Adobe Hopes To Make Flash Master Of The (Mobile) Universe
2008/05/08 Spiffy Envelopes and Labels in MS Word
2008/05/07 [ShellX 20080507]: 'Winbin2iso', and 'Loop Typer'
2008/05/07 Yahoo Adds Security Warnings To Search Results
2008/05/07 Apple to Lose Money on iTunes Movie Releases
2008/05/07 Amazon.com takes New York Tax to Court
2008/05/07 Need Glasses for the Slide Sorter View in MS PowerPoint?
2008/05/07 After Winning The DVD Format War, Blu-Ray Sales Tank
2008/05/06 [ShellX 20080506]: 'Visual Basic 6.0 Portable', and 'Double-...
2008/05/06 Yahoo Outsources to Jajah
2008/05/06 New HP Circuit Could Change Technology Forever
2008/05/06 Movie Downloads To Match DVD Release Dates
2008/05/06 Microsoft Ends Yahoo Bid
2008/05/05 [ShellX 20080505]: 'Ie7 Pro', and 'Desktop Ok'
2008/05/05 The WB Network Hops Online
2008/05/05 Microsoft Slashes Price of Xbox 360 Overseas
2008/05/05 Google CEO Wants YouTube to Take More of Your Money
|
