Excel workbook

Chubster · #1 (**permalink**) 18-08-2008, 22:19

Need some help with Open Office Calc (excel)

I am making a weekly cashflow sheet and I have 55 columns. Column 1 is headings etc, columns 2 - 54 are the weeks and column 55 is the totals

What I am trying to do is have column one fixed so that the headings are always visible as I scroll through the weeks and then have the totals column fixed on the right of my screen as well. So basically just want to be able to scroll the week columns

I can get either / or to work but not both.....any ideas ?

Chub

tax-sorted · #2 (**permalink**) 19-08-2008, 06:02

It should be as easy as click on the cell you want to activate/window/freeze panes and hey presto!

Chubster · #3 (**permalink**) 19-08-2008, 08:02

Quote:

Originally Posted by tax-sorted

It should be as easy as click on the cell you want to activate/window/freeze panes and hey presto!

It is for one column...but when I try to "freeze" the second, it un-freezes the first

Littledot · #4 (**permalink**) 19-08-2008, 08:41

have you got headings across the top, and then headings down the left hand side? are you trying to freeze the top headings so when you scroll down the headings stay? and are you trying to fix the headings on the left so you can scroll left and right?

Chubster · #5 (**permalink**) 19-08-2008, 08:58

Hiya

Trying to freeze column 1 (headings) and column 55 (totals) so that both column 1 and 55 are visible on my screen as I scroll through the weeks (columns 2 -54)

Does that make sense

Littledot · #6 (**permalink**) 19-08-2008, 09:21

Yes it makes sense, I dont think you can do that on excel. I dont think you can freeze non-contiguous sets of rows. You cant split it either as you cant split and freeze at the same time. Could you move your total box to the top so that you could freeze the first row?

spreadsheetsdir · #7 (**permalink**) 19-08-2008, 09:24

As far as I know you can't do multiple freezes. What you could do is either put your totals in column B and freeze columns A & B or put a copy of your headings at the end and Split the window and have the last two columns in the right hand split and scroll through the others with the left.

Littledot · #8 (**permalink**) 19-08-2008, 09:26

It would be a good idea to move your totals box up say to column B so that you could freeze both column A and B?

spreadsheetsdir · #9 (**permalink**) 19-08-2008, 09:35

Another option would be to do Window - New Window to give you a copy of the file. Resize them so that they are both showing aligned on the same screen and then have one window showing with A frozen and the other just showing the last totals column.