Size of sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The bard - 14 Sep 2007 16:42 GMT

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?

Reply to this Message

Peo Sjoblom - 14 Sep 2007 16:49 GMT

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

Signature

Regards,

Peo Sjoblom

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

Reply to this Message

The bard - 15 Sep 2007 08:52 GMT

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

> Unhide the columns/rows, select the first row (the whole row) that you want
> to hide,
[quoted text clipped - 7 lines]
> > a
> > very large file too large to send. How do I limit the size of the sheet?

Reply to this Message

Peo Sjoblom - 17 Sep 2007 13:55 GMT

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

Signature

Regards,

Peo Sjoblom

> Unhide the columns/rows, select the first row (the whole row) that you
> want to hide,
[quoted text clipped - 8 lines]
>> creating a
>> very large file too large to send. How do I limit the size of the sheet?

Reply to this Message

Rate this thread: