Making Cells always visible in MS Excel 2007

Virtual pc / 2007 sp1
July 10, 2009 at 10:07:34
Specs: Windows XP SP3, AMD 2.1 Ghz/2GB RAM
Hi Guys.

I am not good at excel but there is something I want to achieve in excel, I don't know if it is possible but here is what I want.

I want a cluster of cells to be displayed all the time even when we scroll down the spread sheet, sort of the always on top function in sticky notes.

I tried the Watch window but I didn't like that concept.

Actually those cells contains a some formula that gives the end result of all the values I enter in other cells. So in order not to scroll up and down to view the end result I want it to be displayed always on the screen while entering the values.

I know it sounds confusing, but it will be great if it works.

Thanks for your help in advance.

Regards,
Naman Jandial

Naman Jandial


See More: Making Cells always visible in MS Excel 2007

Report •


#1
July 10, 2009 at 11:31:35
On the Menu Bar,
View
Freeze Panes

See if that is what you need.

MIKE

http://www.skeptic.com/


Report •

#2
July 10, 2009 at 15:18:49
Thanks for your reply,
But no freezing panes is not the answer to my question.

I do not want a whole row or a column to be displayed but only some cells, sort of floating cells, but I don't know how to do it.

Naman Jandial


Report •

#3
July 10, 2009 at 15:21:24
Have you seen this done before in Excel ?

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
July 13, 2009 at 07:49:22
Yes,
but once and that too quite a while ago.
so I was still searching for the same file, if I could find the formula used, but I think the file is lost.

I still remember the interface though, its similar to that you see on some web pages that a small part runs down as you scroll, like asking you to fill a feedback or email.

But I think I'll have to live without it.

Anyways thanks for help and trying on it, but if you do find something on it, please do post.

Regards,

Naman Jandial

Naman Jandial


Report •

#5
July 13, 2009 at 08:19:19
It may be possible to create something similar using VBA. and there is a large selection of "sticky note" programs available on the web, but I know of none that are Excel specific.

MIKE

http://www.skeptic.com/


Report •


Ask Question