Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 389
Default Select same cells in all worksheets

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Select same cells in all worksheets

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"

Steven wrote:

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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Select same cells in all worksheets

Hello,

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

Jacques

"Steven" a écrit dans le message de
...
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locked Several Worksheets, allow format cells/select unlocked cell Ana24 Excel Discussion (Misc queries) 2 September 26th 09 01:15 AM
Up down arrow keys do not select cells if select locked cells unch roandrob Excel Discussion (Misc queries) 3 May 18th 09 12:48 AM
Using a button to select cells on different worksheets Babymech Excel Discussion (Misc queries) 3 January 20th 09 02:04 PM
Creating/Naming New Worksheets Based on Select Cells in Master Worksheet Lilbit Excel Worksheet Functions 2 March 19th 08 05:05 PM
select specific cells and consolidate same over many worksheets MikeR-Oz New Users to Excel 2 March 18th 06 01:27 PM


All times are GMT +1. The time now is 05:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"