Enter your email address below to receive email updates and my eBook.
It's all FREE!
I will never share your email or spam you.
Unsubscribe at any time.
You probably find yourself formatting the same spreadsheets in the same way daily, weekly, or monthly. This can be a very time consuming and redundant task. And even if it only takes you five to ten minutes to apply page layouts or format header rows; those minutes add up and you may lose some consistency if you forget something.
The Format Copier tool automates the process of applying page layout and formatting options to multiple sheets in multiple workbooks. And you can store your formatted sheets, which we will call templates, to use when you have to format the same unformatted reports in the future.
The Format Copier is a workbook that contains:
With the press of a few buttons you will be able to apply your template formatting to multiple worksheets and workbooks.
You’ve probably already figured this out, but the Format Copier will save you lots of time. Especially if you’re formatting the same reports over and over again. The tool is very easy to use and even stores your formatting preferences so you don’t have to remember which formatting options you use for each template.
This tool will help if you spend time doing any of the following in Excel:
Ok, that’s an Office Space reference… And with this tool you won’t ever have to worry about messing up your reports and angering your boss. You might have a general ledger reporting software that exports reports in an plain looking format, or doesn’t format them at all. The Format Copier will transform these reports to your specification, making them easy to read and print. And you will produce reports that are formatted consistently, without having to dig up reports from previous months to compare.
Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
Plus weekly updates to help you learn Excel.
Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.
This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...