Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Custom Formats in Excel 97

Custom Formats in Excel 97

Custom Formats in Excel 97

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.  He deleted some of the formats he did not appear to be using, and created the new format required.  He then saved this book and emailed it to another user.  The user made some data changes and emailed the file back.  The book now seems to have lots of custom formats again and some of the cells have lost their formatting altogether.

Are custom formats specific to a certain workbook or sheet, or to the machine the user is using?  Could a corruption be causing this problem?

Any help would be greatly appreciated.

Thank you

Nicky Trew

RE: Custom Formats in Excel 97

Here's the usual scenario:

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!

Here's why the error appears:

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.

Here's how to fix:

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?

Here's how to really make sure it's clean:

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 "end" 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....

If it doesn't work, email it to me, I'll fix it!


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close