Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to automatically set print area in Excel template?
I have created a BOM template. It is used by another program to create an
Excel spreadsheet BOM. The first column is an "Item" number column. There is a formula in that column to automatically number every row that has an item in it: =IF(B4="","",ROW()-2). I formatted 1000 rows so any BOM can fit. My problem is that if you don't " set the Print Area before you print, you get the 1000 lines printed. I would like to use my Item number technique to also set the print area automatically when the BOM is created using the template. Does anyone know how this might be accomplished? Thansk for the help. -- Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
Can Excel automatically select print area on non-blank cells? | Excel Discussion (Misc queries) | |||
Plot Area Automatically Expands in Print and Print Preview | Charts and Charting in Excel | |||
split print area in excel - One Page Print | Excel Worksheet Functions | |||
Create a print macro that would automatically select print area? | Excel Worksheet Functions |