Download Sample Sheet
[https://itgtechnologiesltd.sharepoint.com/:x:/s/SalesandMarketing/EV_kM6UBmxlLizrVMPp6BfQBhA_6k1KiTtwirOCO4-xnoQ?e=ZQaFYL](https://itgtechnologiesltd.sharepoint.com/:x:/s/SalesandMarketing/EV_kM6UBmxlLizrVMPp6BfQBhA_6k1KiTtwirOCO4-xnoQ?e=ZQaFYL)
[[FILE]] > [[SAVE AS]] > [[DOWNLOAD AS A COPY]]
Zoom Saved
Correctly Formatted Data
1
Select the correctly formatted table by dragging from the top left-hand cell to the bottom right. In this example B2 all the way across to D6.
Zoom Saved
Using Format Painter
2
Once selected, double click "Format Painter".
Zoom Saved
3
The selected table will now have a dashed outline, and the cursor will have changed to a paint brush icon.
Zoom Saved
When format painter is selected a paint brush displays as the cursor, like below.
Zoom Saved
4
Use your cursor to select the other tables you want to format. When you do this using the format painter, the formatting, font, layout, fill colors etc. are duplicated to your new selection.
Zoom Saved
Finished Formatting
Press on "Format Painter" once you have finished to turn it off.
Tip! This works in other Microsoft office applications as well e.g. Word and PowerPoint however, it only copies the text formatting and not the fill effects.
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe