User Profile
Charlie_Nairn
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: How to freeze Rows & columns at the same time
Hans Vogelaar's EXCELLENT advice of Jan 18 2021 03:44 AM continues to work perfectly for me but I'm on Excel for Mac 16.69.1 He said:- @Charlie_Nairn Apparently, Freeze Panes is already active. So first select Unfreeze Panes from the Freeze Panes dropdown. Then select cell B4, and select Freeze Panes from the Freeze Panes dropdown.264KViews0likes0CommentsRe: How to freeze Rows & columns at the same time
Thanks Hans HansVogelaar Your faultless advice worked perfectly. Excel help is surprisingly unclear and suggests freezing column A first - which of course freezes that column and then you can't freeze rows. But you've explained how to freeze Excel Rows & Columns at the same time 101% clearly & accurately. So ... THANK YOU again. cn286KViews0likes13CommentsHow to freeze Rows & columns at the same time
I have Excel 365 for Mac. I need to freeze my Column A and Rows 1-3 at the same time. Excel Help says I can do this via View > Freeze Panes but in View I see no such option, only Unfreeze Panes, Freeze Top Row and Freeze First Column. (It used to be easy in Excel fro Mac 2016!) THANKS EVERYBODY - and Happy New Year despite everything. CNSolved299KViews0likes22Comments
Recent Blog Articles
No content to show