Excel - static cells 2

[neillovell]

Is it possible to create "static" cells? What I mean by this is a column on the left (column A) that has several categories, and users type in data alongside it. BUT when the user scrolls right Column A stays where it is, but the data in column B (that was typed in) disappears.

CAT1 | 1.0 | 2.5
CAT2 | 4.6 | 6.0


Scroll right...

CAT1 | 2.5 |
CAT2 | 6.0 |

 

[xlbo]

Select Column B by clicking on the header and then go to Window>Freeze Panes
Should do the trick 4 ya Rgds
~Geoff~

 

[neillovell]

Well that does work, now what about having two static columns, one at the start (A) and one at the other side of the screen (say J).

So...


CAT | | | | TOTAL
CAT1 | 4.4 | 2.1 | 0.2 | 6.7
CAT2 | 9.0 | 1.0 | 5.1 | 15.1

then (scroll right)...


CAT | | | | TOTAL
CAT1 | 2.1 | 0.2 | 0.0 | 6.7
CAT2 | 1.0 | 5.1 | 7.7 | 22.8


How can I achieve this? It seems you can only freeze one window at a time!

 

[xlbo]

Sorry but that is entirely correct - only one freeze atta time - what is it that you want to acheive - maybe there is a different way araound the problem... Rgds
~Geoff~

 

[neillovell]

Well I am designing a timesheet program.

Projects goes on the left, which is a column with lots of different projects listed.

Dates go along the top.

Total hours worked goes down the right hand side (a column).

and in the middle users input their hours for the day on which project they've been on.



Dates-> 24/8 | 25/8 | 26/8 | Hours
Project
ProjA 8:30 | | 1:10 | 9:40
ProjB | | 7:15 | 7:15
ProjC 1:40 | | | 1:40

 

[neillovell]

You can see why I want the right hand column (Total) to be frozen - that way users can see their total hours without having to scroll to column ZZ or whatever (remember the dates along the top will be for more than a year).

 

[BIGALINWALES]

Not a technical answer but why not put the total hours on the left next to the Project name and freeze it there? ie

Project Hours | 24/8 25/8
ProjA 9:40 | 8:30 1:10

Put the freeze where the | is? or does the total hours have to be on the right?

 

[SQLScholar]

I dont know if it is pratical but why not have a separate sheet where the totals are??

Then if they want to see there total they can just click on a different sheet!


Regards

Dan

 

[xlbo]

I'd go with BIGAL(EX)INWALES' suggestion - unless there is a vitally important reason that the total hours worked can't go on the left, it'll solve your problem Rgds
~Geoff~

 

[IBPIT]

You can have a column on the right as well that is static by using split windows. If you go to the Window menu option and choose split, you can then move the splits to show as many columns or rows you want to show.

 

[neillovell]

Both excellent suggestions, I don't know why I didn't think about putting the total hours on the left as well. I'm very new to excel, so I'm having to learn on-the-fly AGAIN!!!

Thank you very very much for all your help,

Daniel