Size of sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
Back
Top