Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Format Painter
|
|
|
The UK's most regular 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.advanced.course - Format Painter
Resolved · Low Priority · Version Standard
Reply Tue 20 Nov 2007, 16:00Delegate Jennifer said...
Jennifer has attended:
Excel Intermediate course
Format Painter
How to use format painter for different worksheets?
For upcoming training course dates see: Pricing & availability
RE: Format Painter
Hi Jennifer
Thank you for your question.
Are you asking is it possible to use the format painter on to copy a format in one sheet in a workbook and copy it to a cell in another worksheet?
If so then all you need to do is copy the cell format using the painer, click on the tab of the new worksheet (You can still do this even with the painter activated) and then select the cell you wish the formats copied to.
I hope this is helpful. If that wasn't what you meant then could you please get back to me
Regards
Stephen
|