Selecting the same cell in all the sheets

It comes with a warning

Let’s say you want the active cell to be A1 in all the sheets in a file before you save the file. There is an easy and quick way to do it. It doesn’t matter how many sheets are involved, but it does come with a warning.

Steps

  1. Right click one of the sheet tabs and choose Select All sheets (this is called grouping the sheets).
  2. Select cell A1
  3. Right click one of the sheets and choose Ungroup sheets
  4. Save the file.

That’s it, done.

WARNING:

The warning is NEVER EVER save a file when the sheets are grouped. NEVER!.

When sheets are grouped whatever you do to one sheet is done to all the grouped (selected) sheets. This can be effective for editing all the sheets at once if all the sheets are identically structured, but it is extremely dangerous when they aren’t.

If you save the file when sheets are grouped they will still be grouped when the file is next opened and someone may not realise the sheets are grouped and make a change that impacts all the sheets. You have been warned.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.