0

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
7
Views
11 Years
Discussion Span
Last Post by mehrdadettefagh
0

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.

0

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

0

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

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.