Size of sheet

T

The bard

I have created a small spreadsheet in Excel XP. I have hidden all the
unwanted columns and rows and it prints ok. However, when trying to email,
all the unused columns and rows are still present (though hidden) creating a
very large file too large to send. How do I limit the size of the sheet?
 
P

Peo Sjoblom

Unhide the columns/rows, select the first row (the whole row) that you want
to hide,
press ctrl + shift & down arrow, then do edit>delete, save the workbook.
Repeat for the columns but press Ctrl + Shift & right arrow, finally hide
the column/rows again


--


Regards,


Peo Sjoblom
 
P

Peo Sjoblom

In the namebox type in the range that is hidden, for example if rows 50 to
65536 are hidden type

50:65536

press enter

then do format>rows>unhide, do the same for the columns, then delete the
used range as I explained earlier, save the workbook. Hide the columns/rows
again, save the workbook. That should be it


--


Regards,


Peo Sjoblom
 

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