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