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.