98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting multiple worksheets
Formatting multiple worksheets
Resolved · Low Priority · Version 2003
Catherine has attended:
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Excel Introduction course
Formatting multiple worksheets
how do I apply the same format to all worksheets I have created?
RE: formatting multiple worksheets
Hi Catherine
Thanks for the post - sorry for the late reply
The easiest way to apply the same format to all other sheets is by using the format painter how to do this is as follows
Hightlight the cell you want to copy the formatting for then double click the format painter button from the toolbar when done that - go through the other sheets clicking on all the cells you want the same format
There is another way but you need to have all the data in the same place throughout the sheets
If you want to know more of this just reply to this post
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
Wed 3 Dec 2008: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Turn Function tooltips on and offExcel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are! |