I have a simple booking spreadsheet/calendar and each year I copy the last sheet to create a new sheet. The days of the week are in column A, and the weeks are separated by a line under each Sunday row. To move the dates to the right day of the week, each date needs to be moved down one line (leap years aside). This should be a simple cut and paste (or drag), except that the cell boundaries move as well. Can I shift the data down one line without moving the boundaries?
Ubuntu 24.04 LO 25.8.4.2
Write 364 in a cell, copy this cell, select your dates (in column A), and paste special with [x] Add (section Operations).