Thread: selecting multiple sheets

Is there any way that I can use a shortcut .e.g define a name for a number of
sheets.
I edit multiple sheets on a regular basis. It takes very long to select all
the sheets every time that i need to make multiple edits. I cant move the
sheets next to each other (in order to use shift) as it is part of a
reporting batch.
I thought of something similar to a range name for multiple cells in a
worksheets
Any suggestions.

Record a macro - while you are selecting your sheets, and maybe assign it a
shortcut key...

"Shaun" wrote:

> Is there any way that I can use a shortcut .e.g define a name for a number of
> sheets.
> I edit multiple sheets on a regular basis. It takes very long to select all
> the sheets every time that i need to make multiple edits. I cant move the
> sheets next to each other (in order to use shift) as it is part of a
> reporting batch.
> I thought of something similar to a range name for multiple cells in a
> worksheets
> Any suggestions.