formatting macro

  • Thread starter Thread starter Mustafa
  • Start date Start date
M

Mustafa

When excel opens, it has a default font, no background
color and black font color... Than you have to change the
font, color or cell size, etc...

is there a simple macro which I can use to format the
whole sheet (or whole file) at once (within a shortcut
key)...
using with that procedure takes alot time....

also do you offer to use "personal.xls" file for all
useful macros?... or it does not make sense ?

Thank you very much

Mustafa
 
Format a blank sheet the way you wish (# of sheet, colors, background
colors, etc.). Save as a Template. Use that template for future
workbooks.

If you want it to be the default template, save it in the XLStart
directory with the file name Book.xlt.
 
Back
Top