Custom Formats in Excel 97 1

[ntrew]

A user inherrited an Excel 97 workbook which seems to have reached its maximum number of custom formats. He needed to create a new format, but was told that the maximum number had been reached.&nbsp;&nbsp;He deleted some of the formats he did not appear to be using, and created the new format required.&nbsp;&nbsp;He then saved this book and emailed it to another user.&nbsp;&nbsp;The user made some data changes and emailed the file back.&nbsp;&nbsp;The book now seems to have lots of custom formats again and some of the cells have lost their formatting altogether.<br><br>Are custom formats specific to a certain workbook or sheet, or to the machine the user is using?&nbsp;&nbsp;Could a corruption be causing this problem?<br><br>Any help would be greatly appreciated.<br><br>Thank you<br><br>Nicky Trew

 

[Dreamboat]

Here's the usual scenario:<br><br>Worksheet originated from previous version(s), may have been around for a while. Data gets changed, cut, paste, etc., over the months and years. After while, the formats are just all mixed up!<br><br>Here's why the error appears:<br><br>If you format one cell, that is one format. If you format 10 cells at once, that is one format. If you format an entire column, that is one format. Get my drift? After while, unknowing users have got tons of individual formats all over the place.<br><br>Here's how to fix:<br><br>Hopefully, each column should contains cells of the same format. Select each column and give it the appropriate format. If that's not true, select as many cell(s)/range(s) as possible, and format it. In this manner, if you have 8 columns, you'll only have 8 formats, get it?<br><br>Here's how to really make sure it's clean:<br><br>Select the first completely blank column to the right of the data. Hit Shift-Ctrl and the right arrow key. This should select the first blank column and all the other blank columns to the right all the way to the &quot;end&quot; of the columns (column IV). Hit Edit-Clear-All. Do the same with rows by going to the first completely blank row at the end of your data. Hit Shift-Ctrl and the down arrow key. This should select the first blank row and all the other blank rows to the bottom (end) of the spreadsheet--like row 66,000-something. Hit Edit-Clear-All. Save the worksheet. You probably should have the problem again for a couple years....<br><br>If it doesn't work, email it to me, I'll fix it! <p> <br><a href=mailto: dreamboat@nni.com> dreamboat@nni.com</a><br><a href=

http://www.wedomanuals.com>

</a><br>