EXCEL templates for page setups

[Ingenuity]

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.

 

[MintJulep]

Yes.

 

[Ingenuity]

Okay, thanks.
Care to share how?
Using Excel 2010.

 

[MintJulep]

Set things up as you desire.

Save As a template.

http://www.excel-easy.com/basics/templates.html

 

[Ingenuity]

Thanks, but I meant like a background page sheet, like a calculation page with borders, company logo, then a custom spreadsheet "on top" as the workbook.

I guess I could do a "watermark" background in a JPG fie so that each page prints on the 'template'/watermark.

 

[LonnieP]

Yes, it's possible, and much, much more. Maybe after the first of the year the two of us can get some of the Visual Basic guys to help us set up a "killer" standard form. I've been running something I'm sure you'd like in Lotus for over 20 years. Now that I've retired I've been fiddling with porting it over to Excel. I'll post something next week that we can use as a starting point.

LonnieP

 

[Ingenuity]

Thanks, LonnieP.

2015, here we come.

 

[Ingenuity]

This is what I am trying to achieve (visually) but to do this I had to JPG the background (from WORD), then insert the JPG image as a 'header' in EXCEL. It works, but not real elegant. I may delete the 5mm grids as it is a bit distracting from the content.

Any better ways to achieve a similar look?

 

[JG2828]

Can you post the excel file? It would be easier to modify and post it back.

 

[DM2]

We're doing this for the same reason you are. I have a single spreadsheet with 2 tabs. One is labeled "11x17" and the other labeled 8.5x11
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."

 

[DM2]

Ok...I thought I had attached the file, but maybe not...

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."