Formating the same cells in multiple worksheet at the same time?
Hi,
I have a doc with 255 worksheets and need to change formatting on all of them. Is there a way to format the same cell range on multiple worksheet in the same doc all at one time? Thanks! |
Formating the same cells in multiple worksheet at the same time?
Assuming the formatting is going to be identical cell for cell on all sheets,
you could right click on a sheet tab name, choose select all, and then just start your formatting. It will cover all sheets selected. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "amio1955" wrote: Hi, I have a doc with 255 worksheets and need to change formatting on all of them. Is there a way to format the same cell range on multiple worksheet in the same doc all at one time? Thanks! |
Formating the same cells in multiple worksheet at the same tim
Thanks John! It work perfectly.
amio1955 "John C" wrote: Assuming the formatting is going to be identical cell for cell on all sheets, you could right click on a sheet tab name, choose select all, and then just start your formatting. It will cover all sheets selected. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "amio1955" wrote: Hi, I have a doc with 255 worksheets and need to change formatting on all of them. Is there a way to format the same cell range on multiple worksheet in the same doc all at one time? Thanks! |
Formating the same cells in multiple worksheet at the same tim
In article , ?B?YW1pbzE5NTU=?= wrote:
Thanks John! It work perfectly. ... *but* ... remember to unselect them all (ie select only one tab) as soon as you are finished. As you have found, you can change heaps of sheets at once ... and that can be a "Bad Thing" once you get to data that should only be on one (say). Should this note be too late, remember the quit without saving option exists. :) amio1955 "John C" wrote: Assuming the formatting is going to be identical cell for cell on all sheets, you could right click on a sheet tab name, choose select all, and then just start your formatting. It will cover all sheets selected. -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "amio1955" wrote: Hi, I have a doc with 255 worksheets and need to change formatting on all of them. Is there a way to format the same cell range on multiple worksheet in the same doc all at one time? Thanks! |
All times are GMT +1. The time now is 08:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com