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

  • Thread starter Thread starter rajachidambaram \(removethis\)
  • Start date 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
 
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.
 
Copy range A1:D20
Group the remaining sheets (click on the first sheet tab,
shift+click on the last sheet tab)
Choose Eidt>Paste
 
Back
Top