Lock row in Excel
 

How do I lock my Total row in place at the bottom of a sheet in Excel?

Lock row in Excel
 

You would have to either freeze the panes or split the window to do it, just as you do when you want to keep the column or row
headers "frozen". It would seem awkward to freeze panes at a total row, especially if the totals weren't always going to be on the
same row. This would also keep you from being able to lock the headers in place, since you can't freeze multiple panes. That would
be an interesting feature to have, but having talked with Excel engineers, I don't think anybody could convince them that the likely
amount of customer use would justify the time needed to make it work.

--
RMC,CPA


"Beachbum" wrote in message ...
How do I lock my Total row in place at the bottom of a sheet in Excel?

Lock row in Excel
 

Thank you very much, sir.
Hope you have a good weekend.
Jim


"R. Choate" wrote:

You would have to either freeze the panes or split the window to do it, just as you do when you want to keep the column or row
headers "frozen". It would seem awkward to freeze panes at a total row, especially if the totals weren't always going to be on the
same row. This would also keep you from being able to lock the headers in place, since you can't freeze multiple panes. That would
be an interesting feature to have, but having talked with Excel engineers, I don't think anybody could convince them that the likely
amount of customer use would justify the time needed to make it work.

--
RMC,CPA


"Beachbum" wrote in message ...
How do I lock my Total row in place at the bottom of a sheet in Excel?

Lock row in Excel
 

You might try putting your total row at the top, either above or below
the headers and freeze them in place with the headers.