View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JLW JLW is offline
external usenet poster
 
Posts: 3
Default How to copy the format of one worksheet to others in same book?

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.