How to select same ranges in multiple worksheets?

  • Thread starter Thread starter eckaner
  • Start date Start date
E

eckaner

I have a workbook that consists of all the months. I want to select
only certain ranges in each worksheet to change the cell format and
text alignments. However, I have to do this on all twelve months,
which gets to be a pain.

Is there a way to select a certain range/ranges on one sheet and
duplicate that selection on the rest of the worksheets throughout the
workbook?

Thanks
 
Eckaner,

Select the sheets together (click the first ; hold control while clicking
the other sheets)
Then make your range selection and formatting etc.
The changes will bereflected on all selected sheets.

Don't forget to "break" the group selection of your sheets!!!

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top