I create a lot of spreadsheets, I am very use to exel but am having difficulty with this problem since moving to libre calc and cant seem to find a simple answer. basically i want to do is-
- open a new spreadsheet, drag all the columns across to the sizes I want them.
- go down to lets say, cell row # 20, high lite the whole cell row across the page & merge them (basically so I can split the page into 2 halves)
- go to cell row #21, and be able to drag those columns to a desired width without affecting the ones above row 20.
I am sure there must be a simple way, its driving me nuts!
Thanks!