LibreOffice 7.6 Help
Choose Insert - Headers and Footers.
Choose Insert - Headers and Footers - Header and Footer tabs.
Choose Sheet - Fill Cells - Down.
Choose Sheet - Fill Cells - Right.
Choose Sheet - Fill Cells - Up.
Choose Sheet - Fill Cells - Left.
Choose Sheet - Fill Cells - Sheets.
Choose Sheet - Fill Cells - Series.
Choose Sheet - Clear Cells.
Backspace
Choose
to activate sheet protection with current cell protection settings.