Microsoft Excel Format Copier Tool

http://www.excelcampus.com/tools/format-copier/
Free Excel tool to format multiple worksheets in multiple workbooks. Includes page layout, printing, page breaks, cell formatting, conditional formatting, outlines, row and column groups, freeze panes, hidden rows and columns, column widths, row heights.

---

Closed Caption:

welcome to excel campus this quick
tutorial contains an overview
the format copy a tool for Excel in a
brief guide on how to use it a more
detailed step-by-step video
is also available which cover some the
advanced features
this tool is designed to save you time
when formatting
multiple worksheets report in excel
special your formatting
the same reports daily weekly or monthly
it takes in and format it worksheet and
converts it into the format is specified
with just a few clicks for this
demonstration will use the form a copier
tool
which is just an Excel workbook and the
exported income statement file
included in the format copier package
this is
all available for free download at Excel
campus stock
so the first step is to open the former
cop your workbook
and enable the macros this work
bookstores you format it worksheets
which we call templates your copier
templates
perform energy it's into this workbook
for this example the format income
statement has been copied in
already so you're basically going to
make the these and formatter reports
in the sample workbook look exactly like
the template report this toward
the form a copy work go to the format
copier she
launch the format copier the format
copier dialog box appears
select the template she from the
drop-down
and then specify the formatting options
you want to copy
the right site contains a list
workbooks that are currently open on
your computer select from the possible
options
and then select the workbook see one for
me
then click run
progress bar will show how many
worksheets are being
format it and display the progress when
complete the workbook that has just been
for matter will appear
and you can see that all the worksheets
have been for matted with the same
options
as the template
there's a hell page included in the form
a copy a file
which contains detailed instructions if
the stuff more questions
you can also check out the detailed
video tutorial on the online Help page
Excel campus taco I hope this tool helps
you
in please contact me with any questions