Size of sheet
 

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?

Size of sheet
 

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


--


Regards,


Peo Sjoblom






"The bard" wrote in message
...
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?

Size of sheet
 

How do I unhide? The Unhide option is greyed out.


"Peo Sjoblom" wrote:

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


--


Regards,


Peo Sjoblom






"The bard" wrote in message
...
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?

Size of sheet
 

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 formatrowsunhide, 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




"Peo Sjoblom" wrote in message
...
Unhide the columns/rows, select the first row (the whole row) that you
want to hide,
press ctrl + shift & down arrow, then do editdelete, save the workbook.
Repeat for the columns but press Ctrl + Shift & right arrow, finally hide
the column/rows again


--


Regards,


Peo Sjoblom






"The bard" wrote in message
...
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?