Linking formatting

Hello Claire,

Format Painter is located on the Home ribbon in the Clipboard group on the left-hand side.

Select a cell or cells with formatting on one workbook then click the Format Painter button, select the other workbook and click the cell that needs formatting. Format Painter will copy across all formatting.

I would suggest you create 2 sample workbooks and create some data in both and then format some cells in one workbook and the test out Format Painter.

If you double-click on Format Painter, then you can use it on different cell locations on another sheet or workbook or even on the same sheet.

Give it a try! Have fun!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer