Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Format size of finished sheet?
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Format size of finished sheet?
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 -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com ippin" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Format size of finished sheet?
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. "Peo Sjoblom" wrote: 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 -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com ippin" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Format size of finished sheet?
On Mon, 24 Jul 2006 13:37:02 +0100, pippin
wrote: 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. "Peo Sjoblom" wrote: 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 -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com ippin" wrote in message ... 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? 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. -- Steve (3) |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Format size of finished sheet?
Thnk you I have noted this and will run the macro when I am boot the other
computer soon. "SteveW" wrote: On Mon, 24 Jul 2006 13:37:02 +0100, pippin wrote: 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. "Peo Sjoblom" wrote: 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 -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com ippin" wrote in message ... 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? 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. -- Steve (3) |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Format size of finished sheet?
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 On Mon, 24 Jul 2006 05:37:02 -0700, pippin wrote: 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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Format size of finished sheet?
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. "Gord Dibben" wrote: 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 On Mon, 24 Jul 2006 05:37:02 -0700, pippin wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Template: Format font size | Excel Discussion (Misc queries) | |||
Customising sheet size | Excel Discussion (Misc queries) | |||
How to Format Excel Sheet ToShowRowNumbers but not the column alph | Excel Discussion (Misc queries) | |||
Can a macro format a hidden sheet? | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |