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 » Format Painters
Format Painters
Resolved · Low Priority · Version 2003
William has attended:
Excel Intermediate course
Format Painters
Can format painters be used for formulas in thh same way as formatting?
RE: Format Painters
Hi William,
Thank you for your post and welcome to the forum, in reply to your question, No.
However copying formulas is something that Excel does very well, you can use the Fill Handle on a cell (bottom right hand corner) or you can simply copy the cells with formulas in and paste them in a different place, Excel remembers the pattern of the formula and applies it to the new area, known as Relative Addressing.
You can also use the Edit>Copy and then Edit>Paste Special options to ensure All or particular choices are copied, ie just Formats or Values etc.
I hope that has helped, if so please click the resolved link. Regards Pete
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:Editing Formulas in Excel CellsAlthough people like to edit a formula in the Formula bar, you can also edit a formula in the cell. |