ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel 2007 (https://www.excelbanter.com/excel-worksheet-functions/242889-excel-2007-a.html)

Sindie

Excel 2007
 
Is there a way to make the row lenth differen on different pages? Example.
I want row A1 to be 6 inches long and I need row A26 2 inches long. There is
a page break at A15.

Fred Smith[_4_]

Excel 2007
 
Simply adjust the row height.

Right-click on the row number, choose Row Height... You must specify a
number in points, and there are 72 points in and inch. So 2 inches is 144
points. The maximum you can specify is 409 points, which hopefully is close
enough to your 6 inches.

Regards,
Fred.

"Sindie" wrote in message
...
Is there a way to make the row lenth differen on different pages?
Example.
I want row A1 to be 6 inches long and I need row A26 2 inches long. There
is
a page break at A15.



Sindie

Excel 2007
 
Thanks Fred, but that dosn't really work either, becasue C1 is only the
length of AUG 10 and I have to type words into row C24. you know in word you
can select from this point forward and change your whole page. That is what
I need in Excel. Thank you and if you know of a way for this, please let me
know, again thank you for your response.

"Fred Smith" wrote:

Simply adjust the row height.

Right-click on the row number, choose Row Height... You must specify a
number in points, and there are 72 points in and inch. So 2 inches is 144
points. The maximum you can specify is 409 points, which hopefully is close
enough to your 6 inches.

Regards,
Fred.

"Sindie" wrote in message
...
Is there a way to make the row lenth differen on different pages?
Example.
I want row A1 to be 6 inches long and I need row A26 2 inches long. There
is
a page break at A15.




Fred Smith[_4_]

Excel 2007
 
I don't see the problem from your description. There's no reason you can't
have a different height for row 24 than row 1. If that doesn't solve your
problem, you'll need to describe it better to get more help.

One thing to keep in mind is that Excel is a spreadsheet program. If you
want a word processor, use Word.

Regards,
Fred.

"Sindie" wrote in message
...
Thanks Fred, but that dosn't really work either, becasue C1 is only the
length of AUG 10 and I have to type words into row C24. you know in word
you
can select from this point forward and change your whole page. That is
what
I need in Excel. Thank you and if you know of a way for this, please let
me
know, again thank you for your response.

"Fred Smith" wrote:

Simply adjust the row height.

Right-click on the row number, choose Row Height... You must specify a
number in points, and there are 72 points in and inch. So 2 inches is 144
points. The maximum you can specify is 409 points, which hopefully is
close
enough to your 6 inches.

Regards,
Fred.

"Sindie" wrote in message
...
Is there a way to make the row lenth differen on different pages?
Example.
I want row A1 to be 6 inches long and I need row A26 2 inches long.
There
is
a page break at A15.





Gord Dibben

Excel 2007
 
By row length do you mean column width?

Cannot be done without merging cells across which can cause problems.


Gord Dibben MS Excel MVP

On Wed, 16 Sep 2009 14:20:01 -0700, Sindie
wrote:

Is there a way to make the row lenth differen on different pages? Example.
I want row A1 to be 6 inches long and I need row A26 2 inches long. There is
a page break at A15.




All times are GMT +1. The time now is 12:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com