hello. im a newbie and need help formatting. i have an excel sheet designed to show inventory. when i scroll the page up and down, i would like to lock the first two columns so it does not move. always stationary. how can i format these columns.
thanks!
axidburn,
Take a look at Freeze Panes.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I do not know how it is call in English version of excel but it should be like "block windows" (icon on ribbon)
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
yes, freeze pane worked. learned something new today. love this forum. thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks