Mate, I’m a long term wedded excel user, now semi-retired and a less frequent user of Excel. These tips (I watched Ctrl E as well) are succinct, insightful and easily memorable. Great job, keep them coming! 👏👏
Hey there, so a couple of options.... you could freeze the panes all the way below what you want to keep in view but I am not sure how far down it goes. You could also transfer the data you want to see to the top as well. Additionally, if you place those numbers off to the right of the data they will stay in view as long as a filter doesn't hide them and you have those rows frozen
Mate, I’m a long term wedded excel user, now semi-retired and a less frequent user of Excel. These tips (I watched Ctrl E as well) are succinct, insightful and easily memorable. Great job, keep them coming! 👏👏
Thanks I understand this more better now
Thank you so much!
Thank you ❤
Thank you again!
Helpful
Thank you!
Yeah but is there a way to keep the totals, at the bottom, always visible? That’s the feature I’d like to use.
Hey there, so a couple of options.... you could freeze the panes all the way below what you want to keep in view but I am not sure how far down it goes. You could also transfer the data you want to see to the top as well. Additionally, if you place those numbers off to the right of the data they will stay in view as long as a filter doesn't hide them and you have those rows frozen