How to copy selected cell in a work sheet to all worksheet

  • Thread starter rajachidambaram \(removethis\)
  • Start date
R

rajachidambaram \(removethis\)

in a worksheet i want to copy the selected cell ie A1 :
d20 to all the worksheet

any shortcut keys is there
 
V

Vasant Nanavati

1. With the source worksheet active, select all the other sheets (that you
want to copy to) by using <Ctrl> <Click> on the tabs.

2. Select the range A1:D20 on the active worksheet.

3. Hit F2.

4. Hit <Ctrl> <Enter>.

5. MOST IMPORTANT: Ungroup the worksheets by clicking an unselected
worksheet or, if all are selected, an inactive sheet.
 
D

Debra Dalgleish

Copy range A1:D20
Group the remaining sheets (click on the first sheet tab,
shift+click on the last sheet tab)
Choose Eidt>Paste
 

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

VBA Coding Help for Beginner 0
VBA for Dependents shortcut menu 0
how to copy and paste value from one sheet to another 4
Need Help with a VBA subroutine 0
Pasting a cell into bookmarked table from excel vba 1
Embed the same Excel multiple times 0
refresh? 2
Copy entire row from another sheet onto first sheet if a unique text matches 1

Top