I have a spreadsheet and I froze the top row, before when I sorted the top row did not move and stayed as the title for the columns , now it is moving with the scroll.
How do I keep the top row not to sort and stay as a title for the column?
Thanks
I have a spreadsheet and I froze the top row, before when I sorted the top row did not move and stayed as the title for the columns , now it is moving with the scroll.
How do I keep the top row not to sort and stay as a title for the column?
Thanks
When you sort, make sure that the "check if range has heading" is checked
Or dont include the heading in the sort range
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks