ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS template (https://www.excelbanter.com/excel-discussion-misc-queries/136884-ms-template.html)

teddkilroy

MS template
 
Trying to get help with a template I downloaded from MS. Typical column/row
spreadsheet I am using that came with only 28 rows and A-I labled columns. It
adds rows left to right (column I) and up to down each column (row 28 ).

I copied and pasted on row 31 the exact same columns and rows since I had
more data entry to show, I did this instead of adding more rows from 29-?.

Problem is when I print I only get row 1-29 and column A-I. It does not
print rows 31-87 nor columns A-I. it does not even show it in print preview.
is there any way to fix this?



Jim Rech

MS template
 
Try redefining the name Print_Area (using Ctrl-F3) to the range you want.

--
Jim
"teddkilroy" wrote in message
...
| Trying to get help with a template I downloaded from MS. Typical
column/row
| spreadsheet I am using that came with only 28 rows and A-I labled columns.
It
| adds rows left to right (column I) and up to down each column (row 28 ).
|
| I copied and pasted on row 31 the exact same columns and rows since I had
| more data entry to show, I did this instead of adding more rows from 29-?.
|
| Problem is when I print I only get row 1-29 and column A-I. It does not
| print rows 31-87 nor columns A-I. it does not even show it in print
preview.
| is there any way to fix this?
|
|



teddkilroy

MS template
 
dam that was good, thanks.

"Jim Rech" wrote:

Try redefining the name Print_Area (using Ctrl-F3) to the range you want.

--
Jim
"teddkilroy" wrote in message
...
| Trying to get help with a template I downloaded from MS. Typical
column/row
| spreadsheet I am using that came with only 28 rows and A-I labled columns.
It
| adds rows left to right (column I) and up to down each column (row 28 ).
|
| I copied and pasted on row 31 the exact same columns and rows since I had
| more data entry to show, I did this instead of adding more rows from 29-?.
|
| Problem is when I print I only get row 1-29 and column A-I. It does not
| print rows 31-87 nor columns A-I. it does not even show it in print
preview.
| is there any way to fix this?
|
|





All times are GMT +1. The time now is 07:19 AM.

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