EXCEL - PROBLEMS (HOLDING)

[m3sye]

Trying to work on excel,

Dont have anything open bar excel and word but excel is freezing whenever I press anything.

My PC is 3 months old, I have ran virus check etc and it shows up nothing.

I have started task manager and it is showing 50% CPU usage - 45% excel & also 265,000k memory

Seems very high to me, anyone any suggestions ?

[mrmr96]

How big is the excel file? (i.e. Mb's in explorer)
Is it trying to bring in data from other sources?
Does it have built in macros and other VB?
Can you sucessfully open the document on another computer?
Did you make the document yourself, if not then where did it come from?

[m3sye]

Right think I have figured out the problem, just need a quick fix now.

My problem is I have selected whole rows and columns when bording or colouring them so the files size is alot bigger than it should be.

Is there anyway I can quickly highly all the rows/columns I dont want to delete them

I.e highligh then right click and delete?

[mrmr96]

Click on the column header of the first blank column, then press CTRL+SHIFT+RIGHT ARROW. This will select all the columns to the right, then right click the header and click on Delete.

Similarly get the first blank row, then press CTRL+SHIFT+DOWN ARROW.

Edited by mrmr96 on Wednesday 28th April 18:05