How would i Freeze First Column and First row on spreadsheet ?
How would i Freeze First Column and First row on spreadsheet ?
If you want col A and row 1 to show, click in B2, then click Window/Freeze panes
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have tried that and it only freezes Column A, I want to Freeze Column A and Row 1 at the same time.
Thanks!! Just what I was looking for this morning!!
did you click on B2 1st?
Yes, Works Perfect! Thanks for the help!
Happy to help"freeze" locks the row above, and the column to the left
If you don't mind me asking what about column B and row 1
Sent from my iPhone using Tapatalk
did you see my post # 6?
Got it, Thanks! ☺️
Sent from my iPhone using Tapatalk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks