Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
print setup -columns to repeat
I know this is hard to describe, but I am trying to print a wide worksheet
onto two pages and am using the Print Setup - Sheet - Columns to repeat feature- (column A). My column A entries has text which vary in size, with entries toward the bottom being descriptions which overlap columns b, c, d, e, however they are all contained in column A (cells in b, c, d, e are blank, as are the cells on page 2 for the columns v, w, x, y, etc for those rows). The first page prints fine, but the second page cuts off the text. Any ideas on how to correct this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
print setup -columns to repeat
Thu, 19 Jul 2007 13:16:00 -0700 from Kim
: I know this is hard to describe, but I am trying to print a wide worksheet onto two pages and am using the Print Setup - Sheet - Columns to repeat feature- (column A). My column A entries has text which vary in size, with entries toward the bottom being descriptions which overlap columns b, c, d, e, however they are all contained in column A (cells in b, c, d, e are blank, as are the cells on page 2 for the columns v, w, x, y, etc for those rows). The first page prints fine, but the second page cuts off the text. Any ideas on how to correct this? Option 1: Widen column A so that it contains all the text. Option b: Make selected rows higher, and set cell formatting in column A for those rows to "wrap text". Option iii: make columns A:E, not just column A, the columns to repeat. Of the three, I think option b is cleanest. Even though it's more work, it will waste the least print space. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
print setup -columns to repeat
Yes, we ended up wrapping text. A:E didn't work right for us and widening the
column didn't work, as the text was too long. We also tried setting up the text at the bottom as a footer, but too long for that too. I think the wrapping is best too. Thanks for your suggestions. "Stan Brown" wrote: Thu, 19 Jul 2007 13:16:00 -0700 from Kim : I know this is hard to describe, but I am trying to print a wide worksheet onto two pages and am using the Print Setup - Sheet - Columns to repeat feature- (column A). My column A entries has text which vary in size, with entries toward the bottom being descriptions which overlap columns b, c, d, e, however they are all contained in column A (cells in b, c, d, e are blank, as are the cells on page 2 for the columns v, w, x, y, etc for those rows). The first page prints fine, but the second page cuts off the text. Any ideas on how to correct this? Option 1: Widen column A so that it contains all the text. Option b: Make selected rows higher, and set cell formatting in column A for those rows to "wrap text". Option iii: make columns A:E, not just column A, the columns to repeat. Of the three, I think option b is cleanest. Even though it's more work, it will waste the least print space. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page Setup - Rows To Repeat At Top | Excel Discussion (Misc queries) | |||
How can I setup in Excel Worksheet Column a number is not repeat? | Excel Discussion (Misc queries) | |||
How can i set one row to repeat print on every other row? | Excel Discussion (Misc queries) | |||
"Rows to repeat at top" option under page setup | Excel Worksheet Functions | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) |