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?
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
Go to Sheet... and select the specific sheets. Use
Shift as needed.
Click sheet tabs with
Ctrl to select specific sheets, and click with
Shift to select a sheet range in LibreOffice 126.96.36.199 (x86); OS: Windows 6.1.