Print Area
Posted by Dwight on October 26, 2001 11:15 AM
Is there a way to set the print area such that it will only print a certain number of columns regardless of what may be entered in other columns but will automatically expand downward as additional rows are filled with data?
Posted by Mark W. on October 26, 2001 11:21 AM
Yes. What kind of data do you have in the columns
that you want to print? Are their empty or blank
cells in these columns?
Posted by Mark W. on October 26, 2001 11:25 AM
I should have asked...
Are there interspersed empty or blank cells in
these columns?
Posted by Dwight on October 26, 2001 11:29 AM
10 columns. About half have data, half text. There will be some empty cells, although none of the columns will be completely empty. (not sure if there's a distinction between "empty" and "blank", but the cells I'm referring to as "empty"will have neither formulas nor data in them.
Thanks, Dwight
Posted by Dwight on October 26, 2001 11:31 AM
Yep, interspersed empty cells. NT
Posted by Aladin Akyurek on October 26, 2001 12:09 PM
Does one of the columns that you want print consists of cells housing numbers and/or blanks?
If so, can you provide the name of the sheet, the columns, and the exact cell ref from which you want to start the print out?
Aladin
Posted by Aladin Akyurek on October 26, 2001 2:35 PM
It appears that you want to print an area within A:M (exluding hidden columns in between).
Print_Area is the name that Excel uses in every worksheet. This can be re-defined as a dynamic range (An idea that, I believe, I picked up from Ian/IML). It appears to work also with hidden columns.
The procedure is as follows.
Activate the first cell of the area of interest in the target worksheet.
Activate Insert|Name|Define.
Enter Print_Area (if not already exists) as name in the Names in Workbook box.
Enter in the Refers To box:
=OFFSET(x!$A$1,0,0,MATCH(9.99999999999999E+307,x!$B:$B),13)
where x is the name of the sheet of interest; the MATCH bit gives the row number of the last cell in use in a column of numeric type (here it's B) and 13 gives the last column to include in the area.
Aladin
Posted by Ted Drake on October 26, 2001 3:06 PM
Am I missung something?
Am I missing something here?
If you want to print only data that appears in columns A:M regardless of how many rows, is it not just a matter of setting the print area as A:M
Posted by Aladin Akyurek on October 26, 2001 3:24 PM
Re: Am I missung something?
Ted,
> Am I missing something here?
Apparently not.
> If you want to print only data that appears in columns A:M regardless of how many rows, is it not just a matter of setting the print area as A:M
I just tried setting A:M as print area via File|Print Area|Set Print Area. This appears to work in that it includes later additions to the area, what Dwight wants to have.
Frankly, I didn't know this, whence that convoluted work out.
Thanks for pointing out this.
Aladin
======
: Activate Insert|Name|Define. : Enter Print_Area (if not already exists) as name in the Names in Workbook box. : Enter in the Refers To box:
