View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Formatting Excel Spreadsheets

Helen,
There are a couple of ways to attack this problem.

The easiest is probably to set up an Excel workbook just the way you want it
and save it as a Template (.xlt) file. Distribute it to your employees and
require that they start all new workbooks using File | New ... from Template
and then choose the corporate standard template file.

Another way would be to record a macro while setting up a workbook the way
you want and save it in everyone's personal.xls file and have them run the
macro each time they start a new workbook - this is much clumsier to initiate
than the .xlt method.

Others may make other suggestions as the day goes on.

"Helen" wrote:

Good day,

In my office, an accounting firm, many employees create Excel spreadsheets
and send them off without applying any kind of formatting. It is frustrating
for the person who opens the Excel spreadsheet and tries to print it. Has
anyone created a template or a macro that would be standard, just like in
Word (Normal.dot)? I'm looking for something that would be quickly applied:
the Page Setup options.

Thank you!

Helene