EXCEL templates for page setups
EXCEL templates for page setups
(OP)
Is it possible to create 'templates' for standard page setups within EXCEL?
Say like a calculation sheet in a background with company logo, title block, perimeter border, and maybe 5mm square grids in a letter (or A4) page size such that you print your EXCEL workbooks to this setup page template.
Say like a calculation sheet in a background with company logo, title block, perimeter border, and maybe 5mm square grids in a letter (or A4) page size such that you print your EXCEL workbooks to this setup page template.





RE: EXCEL templates for page setups
RE: EXCEL templates for page setups
Care to share how?
Using Excel 2010.
RE: EXCEL templates for page setups
Save As a template.
http://www.excel-easy.com/basics/templates.html
RE: EXCEL templates for page setups
I guess I could do a "watermark" background in a JPG fie so that each page prints on the 'template'/watermark.
RE: EXCEL templates for page setups
LonnieP
RE: EXCEL templates for page setups
2015, here we come.
RE: EXCEL templates for page setups
Any better ways to achieve a similar look?
RE: EXCEL templates for page setups
RE: EXCEL templates for page setups
I put the below text in cell B1 so I can remember what the column and row heights need to be set to, as well as how many are intended to fit on the respective sheets of paper.
Cell Dim's - Column = 1.86, Row =18, Number of Rows = 81, number of Columns = 158, Maximum Font Size = 12 pt
Cell Dim's - Column = 1.86, Row =18, Number of Rows = 81, number of Columns = 73, Maximum Font Size = 12 pt
We put a typical title block, including a revision field in the title block. Our title block is oriented at the bottom of the page.
You could set up a macro that forces the rows and columns to set to the specified size. We do this because every now and then someone accidentally modifies those values and it distorts the sheet. when you duplicate the sheet tag, and the column and row values are the same on each sheet, it looks funny when printed to PDF.
I want to setup a forum for the title block that allows me to look the sheet, and force users to fill in the title block. Unfortunately I'm not that swift with forums so I'm going to have to read up on it.
We merge cells to allow the text to be displayed properly when we're using the template.
Regards,
DM
"Real world Knowledge isn't dropped from a parachute in the sky but rather acquired in tiny increments from a variety of sources including panic and curiosity."
RE: EXCEL templates for page setups
Regards,
DM
"Real world Knowledge isn't dropped from a parachute in the sky but rather acquired in tiny increments from a variety of sources including panic and curiosity."