Ask Your Question

How do I select the same cell in multiple sheets?

asked 2016-05-24 06:20:47 +0100

Pruchchai gravatar image

My spreadsheet has about 100 sheets with the same format/structure. I want to edit the values in cell B5(for an example) in all sheets(not the same values). Can I select cell B5 all at once?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-05-24 07:14:06 +0100

Ratslinger gravatar image

updated 2016-05-24 07:22:18 +0100

Right click on a sheet tab ( ie: Sheet1). Click on Select all Sheets. Make changes where wanted. When finished, again right click on tab and Deselect all Sheets. The values entered will be the same for all selected sheets.

EDIT: To select specific sheets use menu Sheet Go to Sheet... and select the specific sheets. Use Alt and Shift as needed.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-24 06:20:47 +0100

Seen: 1,625 times

Last updated: May 24 '16