Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lines cut off
When I print my spreadsheet, the cells with one line prints OK. But,
if the cells have more than one line, the first line is OK but the subsequent line(s) are cut-off. How do resolve this problem |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lines cut off
GARY formulated on Friday :
When I print my spreadsheet, the cells with one line prints OK. But, if the cells have more than one line, the first line is OK but the subsequent line(s) are cut-off. How do resolve this problem This is probably a RowHeight issue where the Print_Area is 'fit' between the margins. Anything that won't fit hides below the cell border. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lines cut off
On Feb 25, 5:07*pm, GS wrote:
GARY formulated on Friday : When I print my spreadsheet, the cells with one line prints OK. *But, if the cells have more than one line, the first line is OK but the subsequent line(s) are cut-off. How do resolve this problem This is probably a RowHeight issue where the Print_Area is 'fit' between the margins. Anything that won't fit hides below the cell border. -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc The lines that are cutoff are INSIDE the cells, not at the margins of the spreadsheet. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lines cut off
GARY pretended :
On Feb 25, 5:07*pm, GS wrote: GARY formulated on Friday : When I print my spreadsheet, the cells with one line prints OK. *But, if the cells have more than one line, the first line is OK but the subsequent line(s) are cut-off. How do resolve this problem This is probably a RowHeight issue where the Print_Area is 'fit' between the margins. Anything that won't fit hides below the cell border. -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc The lines that are cutoff are INSIDE the cells, not at the margins of the spreadsheet. Doesn't matter where the cells are. What DOES matter is the Print_Area is being forced to 'fit' between the margins. Thus, the available space for existing RowHeight may become insufficient to display all cell contents. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lines cut off
On Feb 25, 5:53*pm, GARY wrote:
On Feb 25, 5:07*pm, GS wrote: GARY formulated on Friday : When I print my spreadsheet, the cells with one line prints OK. *But, if the cells have more than one line, the first line is OK but the subsequent line(s) are cut-off. How do resolve this problem This is probably a RowHeight issue where the Print_Area is 'fit' between the margins. Anything that won't fit hides below the cell border. -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc The lines that are cutoff are INSIDE the cells, not at the margins of the spreadsheet.- Hide quoted text - - Show quoted text - Hi Garry, I guess I don't understand what you mean by "Print_Area". Is that the same as the "Print Area" on the "Page Layout" tab in the "Page Setup" group? I've clicked on "Clear Print Area" but that didn't resolve the problem. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lines cut off
It happens that GARY formulated :
On Feb 25, 5:53*pm, GARY wrote: On Feb 25, 5:07*pm, GS wrote: GARY formulated on Friday : When I print my spreadsheet, the cells with one line prints OK. *But, if the cells have more than one line, the first line is OK but the subsequent line(s) are cut-off. How do resolve this problem This is probably a RowHeight issue where the Print_Area is 'fit' between the margins. Anything that won't fit hides below the cell border. -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc The lines that are cutoff are INSIDE the cells, not at the margins of the spreadsheet.- Hide quoted text - - Show quoted text - Hi Garry, I guess I don't understand what you mean by "Print_Area". Is that the same as the "Print Area" on the "Page Layout" tab in the "Page Setup" group? I've clicked on "Clear Print Area" but that didn't resolve the problem. The Print_Area is determined by Excel when you print or view PrintPreview. It's based on the UsedRange of the wks, and how it's 'fitted' between the margins. If it doesn't fit between margins then the rightmost cells will print on another page. The problem ISN'T the defined Print_Area. It's a result of the printed RowHeight not being sufficient to display all the contents of multi-line cells. Try changing to a smaller font OR set wider margins to see the effects as compared to what you see with the printout now. Pay particular attention to 1 specific cell that has its contents cut off, then play with the font size OR margins to see what changes occur in that 1 cell. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lines cut off
On Feb 25, 6:47*pm, GS wrote:
It happens that GARY formulated : On Feb 25, 5:53 pm, GARY wrote: On Feb 25, 5:07 pm, GS wrote: GARY formulated on Friday : When I print my spreadsheet, the cells with one line prints OK. But, if the cells have more than one line, the first line is OK but the subsequent line(s) are cut-off. How do resolve this problem This is probably a RowHeight issue where the Print_Area is 'fit' between the margins. Anything that won't fit hides below the cell border. -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc The lines that are cutoff are INSIDE the cells, not at the margins of the spreadsheet.- Hide quoted text - - Show quoted text - Hi Garry, I guess I don't understand what you mean by "Print_Area". Is that the same as the "Print Area" on the "Page Layout" tab in the "Page Setup" group? I've clicked on "Clear Print Area" but that didn't resolve the problem. The Print_Area is determined by Excel when you print or view PrintPreview. It's based on the UsedRange of the wks, and how it's 'fitted' between the margins. If it doesn't fit between margins then the rightmost cells will print on another page. The problem ISN'T the defined Print_Area. It's a result of the printed RowHeight not being sufficient to display all the contents of multi-line cells. Try changing to a smaller font OR set wider margins to see the effects as compared to what you see with the printout now. Pay particular attention to 1 specific cell that has its contents cut off, then play with the font size OR margins to see what changes occur in that 1 cell. -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text - - Show quoted text - To avoid the line(s) in the cells from being "cut off", I had to MANUALLY set the row heights as follows: cells with one line - 15 pixels cells with two lines - 36 pixels cells with three lines - 66 pixels cells with four lines - 74 pixels It's a very tedious process to adjust the row height for each row. Doesn't Excel have a feature that adjusts the row heights AUTOMATICALLY? If AutoFit Row Height doesn't do this, what good is AutoFit Row Height? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lines cut off
GARY pretended :
To avoid the line(s) in the cells from being "cut off", I had to MANUALLY set the row heights as follows: cells with one line - 15 pixels cells with two lines - 36 pixels cells with three lines - 66 pixels cells with four lines - 74 pixels It looks like you're using a fairly large font size. With Arial 9 my RowHeight settings a 1 line: 15 2 lines: 30 3 lines: 45 4 lines: 60 It's a very tedious process to adjust the row height for each row. Doesn't Excel have a feature that adjusts the row heights AUTOMATICALLY? If AutoFit Row Height doesn't do this, what good is AutoFit Row Height? Yep, it's annoying! What's more annoying is trying to find where the UsedRange displays what PrintPreview displays, preference being the latter shows what you see in the wks. What can help (sometimes) is to store a macro in PERSONAL.XLS that autofits the selection, and run it when needed. Example: Sub Autofit_SelectedCells() Dim c As Range For Each c In Selection Rows(c.Row).AutoFit Next End Sub -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lines cut off
My previous reply assumes WrapText is already turned on. Otherwise,
revise as follows: Sub Autofit_SelectedCells() Dim c As Range For Each c In Selection c.WrapText = True: Rows(c.Row).AutoFit Next End Sub -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel 2007 chart with multiple lines, mouse doesn't track lines | Charts and Charting in Excel | |||
how to extract 20 000 lines out of 200 000 lines automatically? | Excel Discussion (Misc queries) | |||
inserted lines move how to place lines in proper cell? | Excel Worksheet Functions | |||
Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel |