I have a rather large Excel spreadsheet. What I would like to do is "fix" the leftmost or topmost columns on the screen as I scroll horizonally or vertically.

So, in other words, if I have 10 rows of various accounts with 200 columns each, I want to be able to see which account I am dealing with as I scroll horizontally into column 150.

If you want to fix column A and Row 1 then select Cell B2 and then go to Windows Menu and select Freeze Panes. It'll freeze the first row and the first column of your worksheet.

try using Filters while working with larger excell sheets. It will cut out alot of the confusion. i hope that helps

Thanks for Help.

I was facing a great difficulty. Now I am relaxed.

thank you for your question. it was my problem, too.