Excel Column Removal

E

ExPrezz

I've created a spreadsheet for my checking account but I have
accidentally added too many columns and pages causing the size of the
file to be too big. How can I delete these columns and additional
pages?
 
D

Dave R.

Click on the letter of the column (selects whole column) then go to Edit >
Delete (delete button by itself wont work). Or you can right click once
you've selected the whole column and select delete.

Same deal for a worksheet, right click over a worksheet tab and "delete".
 
E

ExPrezz

I've deleted the columns but now the size of the file is 2,353 KB.
How can I reduce the size
 
D

Dave R.

I suspect it's the rows that are taking up the space. Go to your last row of
data, go to the empty row below it, then click on the row number (again
selecting the entire row). Hold SHIFT and press (and release) END then press
(and release) the down arrow.

Now right click on all those, and select delete. Or go to edit>delete.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top