excel page setup

  • Thread starter Thread starter Teddy
  • Start date Start date
T

Teddy

Hello,
I have a spreadsheet and I am using cells a:k50, but when
I go to see the end of my spreadsheet it tells me I have
used cells a:ak 295. I have 35 sheets like this and is is
making the file bigger than it has to be. I have tried
deleting, clear, page preview setup but nothing seems to
clear and make my page a1: k53. Any suggestions. Thank You
 
Select the row following the end of your data. Ctrl+Shift+Down Arrow to
select all rows beyond your data and Edit>Delete.
Select the column following the end of your data. Ctrl+Shift+Right Arrow
(US) to select all columns beyond your data and Edit>Delete.

File>Save>File>Close.

Reopen open the file.
 
Just to add a note of explanation to this. When you delete, it is important
to use Delete on an Edit menu (the main one or a right-click one) as Jim
specified. This deletes the cells themselves. If you were to use the Delete
key on the keyboard, this would only clear the cell contents, leaving any
formatting in place. The presence of either cell contents or cell formatting
will make a cell (and all those to the left and above it) contribute to the
file size.
 
It did not work. I do not know what else to do
-----Original Message-----
Select the row following the end of your data. Ctrl+Shift+Down Arrow to
select all rows beyond your data and Edit>Delete.
Select the column following the end of your data. Ctrl+Shift+Right Arrow
(US) to select all columns beyond your data and Edit>Delete.

File>Save>File>Close.

Reopen open the file.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
You


.
Click to expand...
 
Have you saved the file, closed and reopened it? If so, press Ctrl+End and
see where the cursor is. If it is at the end of your actual data, it
"worked". If not, you need to be sure you followed the instructions exactly.
 
I am an idiot. I did save it but I did not close file.
Thank you so much. Have a happy holiday. THANK YOU.
 
Back
Top