Need Excel equivalent of Lotus CTRL-SHIFT-PG UP/DWN

V

vpr80

If I have numerous sheets that are identical and I want to replace th
same cell on all of them....in Lotus I would highlight the same regio
on all the sheets with CTRL-SHIFT-PG UP then either paste or type o
whatever while holding that 3rd selection, but how do you do that wit
Excel?

Thank
 
F

Frank Kabel

Hi
group your sheets first while holding down the CTRL key and selecting
your sheets
then change your cell

Note: Don't forget to ungroup the sheets afterwards
 
Top