Member Avatar for Dani

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.

  • 7 Contributors
  • 6 Replies
  • 2K Views
  • 5 Years Discussion Span
  • Latest Post Latest Post by mehrdadettefagh

Recommended Answers

All 6 Replies

Member Avatar for nanosani

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.

Member Avatar for Angry Jetster

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

Member Avatar for valasai

Thanks for Help.

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

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

Member Avatar for fakhri

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

Member Avatar for funzel_gap

thank you so much; It's very helpful

Member Avatar for mehrdadettefagh

I have excel file which contains 4 column ut when I open that file In my computer all of four columns showed in one column for example (a) .how can I separate this column data to their original fourth column .note this file has saved in csv format.please help me .tanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.