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

  • Thread starter Thread starter vpr80
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Excel equivalent of Lotus CTRL-SHIFT-PG UP/DWN 1
Need Excel equivalent of Lotus CTRL-SHIFT-PG UP/DWN 1
Convert from lotus to excel 4
Need Excel equivalent of Lotus CTRL-SHIFT-PG UP/DWN 1
Is there an equivalent of Lotus 123's "Paste visible" command? 6
Excel Shift Key Lock 4
Lotus/Excel questions 1
Formulas don't work after copy/paste from Lotus 1-2-3 97 (Excel 20 1

Back
Top