INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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.

RE: EXCEL templates for page setups

Yes.

RE: EXCEL templates for page setups

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

RE: EXCEL templates for page setups

(OP)
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.

RE: EXCEL templates for page setups

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

RE: EXCEL templates for page setups

(OP)
Thanks, LonnieP.

2015, here we come.

RE: EXCEL templates for page setups

(OP)
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?


RE: EXCEL templates for page setups

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

RE: EXCEL templates for page setups

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close