How to copy the format of one worksheet to others in same book
Thanks!
"Gord Dibben" wrote:
Select first sheet tab.
Right-click on tab and "Select all sheets"
Make your changes to active sheet and will be done to all.
Ungroup when happy.
Gord Dibben MS Excel MVP
On Thu, 27 Jul 2006 10:04:02 -0700, JLW wrote:
I have a workbook containing 8 worksheets. After setting up all the sheets, a
new change was added to one that needs to be duplicated in all. This is a
look/feel change only, doesn't affect any formulas or usability of the chart.
Rather than go into each individual sheet and add columns, duplicate cell
width, etc., is there a quick way to copy the format to all sheets at once? I
tried format painter, but it didn't work.
|