Is it possible to copy a cell in one worksheet and then paste the same cell in the entire workbook without opening each sheet and pasteing individually?
If you want to enter the same value in the same cell in each sheet in the workbook, you can group the worksheets
- click the first worksheet tab
- Shift-click the last worksheet tab
all worksheets are now grouped.
Just about anything you do now in the visible worksheet will take place in all other grouped worksheets, such as entering data, changing formatting etc.
Don't forget to ungroup when you're done.
To group selected worksheets, Ctrl-click the sheet tabs.
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.
