|
Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word 
Host your Web site with PureHost! 
|
 
Wednesday, February 14, 2018 – Permalink – Spreadsheet BloatFormatting bloatAvoid applying formatting to more than just the active area of your worksheet. Extraneous formatting will confuse Excel about the last cell in the spreadsheet. Depending on your OS and specific configuration, you could see symptoms ranging from Excel not responding to various error messages concerning page faults, low virtual memory, and access violations. You may see a warning message; "Too many different formats." To resolve this issue, make sure you select only the particular range of cells you want formatted when you apply specific formatting or select Format>AutoFormat. You can use Ctrl+End to see where Excel thinks the last cell is. For more information, check out: How to reset the last cell in Excel Also see: Spreadsheet Diet Microsoft: Formatting Cleaner Add-in See all Topics excel Labels: Customize, General, Reference, Shortcuts, Tips, Tutorials <Doug Klippert@ 3:59 AM
Comments:
Post a Comment
|
