Select same cells in all worksheets

[Steven]

I have selected cell A1 to B6 on Sheet1. How do I then select the same cells
on alls worksheets in the file.

Thank you,

Steven

 

[Dave Peterson]

You could group the worksheets, then do the selection.

Then ungroup the sheets if you want.

But do remember to ungroup the sheets when you're done. Almost everything you
do to a sheet in a group, you do to all the sheets in that group.

You can group all the sheets by rightclicking on one of the tabs and selecting
"Select All Sheets"--or click on the first worksheet tab and ctrl-click on
subsequent tabs.

You can ungroup by rightclicking on any of the grouped sheet tabs and choosing
"Ungroup Sheets"

 

[Jacques ALARDET]

Hello,

First, you selected all worksheets
Then, you sélected cells A1 to B6

Jacques