I have a large scheduling spreadsheet of dates and names, split up by week, with borders for clarity. I want to be able to autofill the dates by dragging down the cell. Sometimes I also want to fill many cells with the same name in a row. If I drag down to fill the cells, then any borders on the cell are erased, like so:
(I already manually fixed the borders on the dates when i took the screnshot.) Borders are apparently treated like they're part of the content of the cell, which seems completely wild to me. Borders are outside of the cell and I'd expect them to stay where I put them no matter what content I post or move around in the cells themselves
Is there a way to get borders to just stick where they're set and ignore any dragging, copy/pasting, etc. that I'm doing? Failing that, is there at least a fix for the specific trouble I'm seeing here with the drag-down?