Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locked Several Worksheets, allow format cells/select unlocked cell | Excel Discussion (Misc queries) | |||
Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
Using a button to select cells on different worksheets | Excel Discussion (Misc queries) | |||
Creating/Naming New Worksheets Based on Select Cells in Master Worksheet | Excel Worksheet Functions | |||
select specific cells and consolidate same over many worksheets | New Users to Excel |