Excel - Is this possible.. - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel - Is this possible..

Tanchi Avatar
7y, 8m agoPosted 7 years, 8 months ago
Hi All,

I have a spreadsheet thats basicly a list using cells A, B , C full of data down to the 3,000 mark. Now on the right side in coloum D i have a box that I would like to keep on the side to display other info.

I would like this box to stay with me as I scroll down.
I cant use the frezze panes thing as I have the titles accross A1 B1 C1 that awlays need to stay there.

Is there a way I can frezze this box so it will stay there as I scroll down?

any help would be great.

Thx
Tanchi Avatar
7y, 8m agoPosted 7 years, 8 months ago
Options

All Comments

(11) Jump to unreadPost a comment
Comments/page:
#1
Yes just freeze panes on the view tab ...If you have 2007 just drag the tab on the right bottom corner...Good Luck
#2
gr8h8me
Yes just freeze panes on the view tab ...If you have 2007 just drag the tab on the right bottom corner...Good Luck


sorry i dont follow.

I have Excel 2003
#3
I haven't got 2003 anymore...I believe you highlight the column go onto view and click on Freeze Panes and that will keep the column there...Very hard to explain actually...Or go to help (F1 Button) and type it in and that may explain better :thumbsup:
#4
If it's just 1 cell you could use the "Watch". Right click on the cell and "add watch"
#5
could you not just move everything along and put column D where column A was, then freeze it?
#6
o, yeah i have the very top cell frozen, under each heading there is a list of data like:

_A_ _B_ _C_ _D_
1| Data Data Data Data
2| Data Data Data Data
3| Data Data Data Data
4| Data Data Data
5| Data Data Data

id like the data in the D section to stay with me as i scroll down the spreadsheet, but i dont want to see what in A1, B2 C3 etc..

hard to explain lol
#7
blade176
If it's just 1 cell you could use the "Watch". Right click on the cell and "add watch"


what does watch do?
#8
Tanchi
o, yeah i have the very top cell frozen, under each heading there is a list of data like:

_A_ _B_ _C_ _D_
1| Data Data Data Data
2| Data Data Data Data
3| Data Data Data Data
4| Data Data Data
5| Data Data Data

id like the data in the D section to stay with me as i scroll down the spreadsheet, but i dont want to see what in A1, B2 C3 etc..

hard to explain lol

It is very hard to try to explain Excel I think I will skip questions on it from now lol
#9
Open the page in another window and keep one static whilst you move the other one.

Window:New Window; then

Window:Arrange:Horizontal or Vertical

Bob is the sibling of your parent
#10
Don't think that this can be done. - Somebodys idea seems to be your only solution.
#11
Watch allows you to view the contents of a single/range of cells. It opens a popup window with the cell name and contents. If the contents are a formular linked to changing values with in the sheet this is reflected in the results.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!