My spreadsheet has multiple rows and columns. Some of the rows are totaled separately at the bottom of the sheet. I'd like to lock those rows so that the totals still follow the right rows at the bottom of the sheet when it is sorted in different ways. Right now, when I sort, the rows change or if I add a row, it changes the totals at the bottom. How do I lock the rows so they are totaled separately from the rest.
Solved by B. U. in 29 mins