Microsoft Excel Error

[Gyroscope_182]

I realised that, as time from time, there are too many blank pages that would print on a certain worksheet in Excel. What I used to do was always just find the areas, highlight, delete, make automatic colour for cells and text, and it would normally do the job.

It didn't work, and still pages I don't want to print, but want to get on top of the problem, however, just mucking around a little annoyed, I highlighted heaps of cells (heaps, i mean almost all) and pressed delete (not delete rows etc. but just delete/backspace), and automatic colour etc.

After I did this, the program slowed down the whole computer. After saving numerous times already today, after I did this, it then took about one minute to save, three minutes to close, and whilst doing these options, my computer was pretty much frozen.

I have restarted and Excel took two minutes to open the same file. It's size is an incredible 50.9MB, surely not what it used to be.

How do i get rid of this size, as I think it is from all the cells i highlighted.

Help appreciated.

 

[Bucks5]

Try deleting all the rows and columns that you have filled with auto text and fill.

Next time highlight the part of the spreadsheet that you want to print and select:

File -> Print Area... -> Set print area from the menu.

To clear the print area, go File -> Print Area... -> Clear print area.

 

[svmac]

Unused cells have no format, until you use them (which is what you did by applying default formats to them).

Highlight the area that you don't want to use, then go to Edit -> Clear -> Clear All. This will remove any formatting etc applied to the selected cells and resave your workbook once this completes.

 

[weevil]

This is a known bug that occasionally crops up in Excel.

Unfortunately the only solution is to copy your data to an entirely new workbook.

 

[Gyroscope_182]

Took my time to reply back, but I did do what weevil stated 20 mins after i posted. I realised the formulas were still in place on a new workbook. Next time it happens will try the 'Clear All' theory.

Thanks for the help, always good to use as later reference.