Getting column to stay fixed while scrolling?

[bytey]

Hi all,

I wonder if you are able to lend a hand? I am sure it is probably very simple but i cannot for the life of me find/remember it

In a spreadsheet I would like columns A & B to remain static or fixed while I scroll across the other columns. ie. when I am in column J or K I still want to see A & B fixed as a reference.

Does this make sense? I cannot think of any better way to describe it...

Thanks,

Bytey

 

[onlyadrafter]

Hello and welcome to the board,

Put your cursor in C1 and select WINDOW and FREEZE PANES.

Or

to the right of the horizontal scroll bar is a small vertical line, drag this over to between Columns B & C (with the cursor on the screen, it should snap to the gridlines.

 

[bytey]

Onlyadrafter you are a superstar xxXX