Format size of finished sheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pippin - 23 Jul 2006 20:15 GMT

An error with IE when I tried to post (hopefully this will not be a double
post)

I have created a sheet in Excel 2007 (beta) I would like to save the sheet
without the extra cells/rows etc I deleted pages 2&3 but can't remove the
extra sheet information when I only need to print and keep a compact sheet of
the data.
I have tried to copy etc but I am always presented with the full sheet - is
it possible to remove the excess on sheet 1 and only save and print the
comapct sheet?

Reply to this Message

Peo Sjoblom - 23 Jul 2006 20:55 GMT

I am not sure I understand what you mean, the workbook will always have
approx 1mb of rows and 16k of columns,
You can clear used ranges so it doesn't print extra pages using this method

http://www.contextures.com/xlfaqApp.html#Unused

works for all excel versions

The only other way to mimic as if there is only this particular size would
be to hide all rows and columns that are not used

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com

> An error with IE when I tried to post (hopefully this will not be a double
> post)
[quoted text clipped - 8 lines]
> it possible to remove the excess on sheet 1 and only save and print the
> comapct sheet?

Reply to this Message

pippin - 24 Jul 2006 13:37 GMT

Thank you for your reply. Apologies for my late response and the lack of
clarity when I was trying to explain.
I have bookmarked the link as this will be very useful to me as this would
help with removing extra gridlines from printing.

I am almost sure I read a way to actually remove the surplus only saving
ranges 1-xx but to date I can't find the article. I will keep looking but
appreciate the extra help you have given me. Thank you.

> I am not sure I understand what you mean, the workbook will always have
> approx 1mb of rows and 16k of columns,
[quoted text clipped - 19 lines]
> > it possible to remove the excess on sheet 1 and only save and print the
> > comapct sheet?

Reply to this Message

SteveW - 24 Jul 2006 13:43 GMT

> Thank you for your reply. Apologies for my late response and the lack of
> clarity when I was trying to explain.
[quoted text clipped - 47 lines]
>> the
>> > comapct sheet?

The real problem I suspect is that used, but now empty rows and columns
are still remembered when Excel refers to the sheet

use this macro

Sub Set_Sheet_Size()
ActiveSheet.UsedRange
End Sub

Click on the bottom-right cell of the new-sheet size (no cells to right or
below can contain data)
The run the macro.

Signature

Steve (3)

Reply to this Message

pippin - 24 Jul 2006 13:54 GMT

Thnk you I have noted this and will run the macro when I am boot the other
computer soon.

> > Thank you for your reply. Apologies for my late response and the lack of
> > clarity when I was trying to explain.
[quoted text clipped - 60 lines]
> below can contain data)
> The run the macro.

Reply to this Message

Gord Dibben - 24 Jul 2006 20:37 GMT

I would suggest you save your time and effort.

Quit looking..............you won't find a method of deleting unused rows and
columns from an Excel worksheet.

Gord Dibben MS Excel MVP

>I am almost sure I read a way to actually remove the surplus only saving
>ranges 1-xx but to date I can't find the article. I will keep looking but
>appreciate the extra help you have given me. Thank you.

Reply to this Message

pippin - 25 Jul 2006 14:31 GMT

Thanks I tried everything suggested last night but nothing worked for me.
At least I can remove the sheets not used but will be content now with
keeping my unfilled cells.

I had to find the macro bit in 2007 as it wasn't on the ribbon by default. I
will have to learn a lot more about macros now thanks, that bit was fun.

> I would suggest you save your time and effort.
>
[quoted text clipped - 6 lines]
> >ranges 1-xx but to date I can't find the article. I will keep looking but
> >appreciate the extra help you have given me. Thank you.

Reply to this Message