Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel row height v. printed page
I have to use Excel to manage project updates with lots of text. Each row is
set to the maximum 409 height, even though you can fit more test in there, it just won't print. The page when printed has blank space at the bottom, which would indicate more text could fit on the page, if it wasn't cut off at the end of each row. My boss doesn't want to simply center the text, but wants to "fill" the page so as to keep more common data together, without having pages with only a few lines of data on it. Is there a way to force an extra 3 or 4 lines (which are in the cell, beyond the 409 row height) to show in print preview and print on the page. The page has room for it, I just can't get Excel to do it without putting the extra in a new row, which then creates a new page. Arghhh! Thanks for any suggestions. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel row height v. printed page
A cell can hold 32767 characters but will show or print only 1024 of these
characters in a cell. If you add a linefeed.....Alt + Enter.........every 100 or so characters you can increase this limit considerably. Gord Dibben MS Excel MVP On Wed, 4 Nov 2009 11:05:02 -0800, Geri Rigger <Geri wrote: I have to use Excel to manage project updates with lots of text. Each row is set to the maximum 409 height, even though you can fit more test in there, it just won't print. The page when printed has blank space at the bottom, which would indicate more text could fit on the page, if it wasn't cut off at the end of each row. My boss doesn't want to simply center the text, but wants to "fill" the page so as to keep more common data together, without having pages with only a few lines of data on it. Is there a way to force an extra 3 or 4 lines (which are in the cell, beyond the 409 row height) to show in print preview and print on the page. The page has room for it, I just can't get Excel to do it without putting the extra in a new row, which then creates a new page. Arghhh! Thanks for any suggestions. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel row height v. printed page
Step :(1) Just fill the page what you want so as to keep more common data
together, without having pages with only a few lines of data on it. Step : (2) select and copy the area which is to be printed. Step: (3) (In another sheet) press shift key and click on edit in the menu. (Then "Paste Picture" will be viewed) and now click on "Paste Picture" Step: (4) Resize the picture to fit in one page and print on Lanka V Suri "Geri Rigger" wrote: I have to use Excel to manage project updates with lots of text. Each row is set to the maximum 409 height, even though you can fit more test in there, it just won't print. The page when printed has blank space at the bottom, which would indicate more text could fit on the page, if it wasn't cut off at the end of each row. My boss doesn't want to simply center the text, but wants to "fill" the page so as to keep more common data together, without having pages with only a few lines of data on it. Is there a way to force an extra 3 or 4 lines (which are in the cell, beyond the 409 row height) to show in print preview and print on the page. The page has room for it, I just can't get Excel to do it without putting the extra in a new row, which then creates a new page. Arghhh! Thanks for any suggestions. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel row height v. printed page
Picture?
On Thu, 5 Nov 2009 03:39:02 -0800, Lanka Suri wrote: Step :(1) Just fill the page what you want so as to keep more common data together, without having pages with only a few lines of data on it. Step : (2) select and copy the area which is to be printed. Step: (3) (In another sheet) press shift key and click on edit in the menu. (Then "Paste Picture" will be viewed) and now click on "Paste Picture" Step: (4) Resize the picture to fit in one page and print on Lanka V Suri "Geri Rigger" wrote: I have to use Excel to manage project updates with lots of text. Each row is set to the maximum 409 height, even though you can fit more test in there, it just won't print. The page when printed has blank space at the bottom, which would indicate more text could fit on the page, if it wasn't cut off at the end of each row. My boss doesn't want to simply center the text, but wants to "fill" the page so as to keep more common data together, without having pages with only a few lines of data on it. Is there a way to force an extra 3 or 4 lines (which are in the cell, beyond the 409 row height) to show in print preview and print on the page. The page has room for it, I just can't get Excel to do it without putting the extra in a new row, which then creates a new page. Arghhh! Thanks for any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Pivot Tables - Page Field Row Height; Disable Select MultItems | Excel Discussion (Misc queries) | |||
Different info per printed page | Excel Discussion (Misc queries) | |||
How can I display totals on the bottom of a printed page in Excel. | Excel Discussion (Misc queries) | |||
I want row 1 to show on the top of every printed page | Excel Discussion (Misc queries) | |||
Excel 2003 printed page does not look like preview | New Users to Excel |