1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Can I freeze a row at the bottom of my sheet?

I want a row at the bottom of my sheet to be frozen so I can display total cost savings at the bottom and have it always be visible. As far as I can tell, the freeze panes option only freezes cells above and to the left of the current selection, allowing you to scroll down or to the right with that row/column staying in place. Is there some way to freeze cells at the bottom of the sheet that stay visible when scrolling up?

submitted by /u/shabobaman
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#row zero
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#freeze row
#Excel
#data sheet
#bottom of the sheet
#freeze panes
#cost savings
#visible cells
#scrolling
#total
#current selection
#cells above
#cells to the left
#data visibility
#fixed display