Hi, I hope I can articulate this. I am working on a document that is a
survey and has large contents in certain questions/cells. When I get to the
row that has those huge cells, as I tab over to the specific cell, the whole
cell is displayed.

As I navigate through each cell, I use the right arrow or left arrow to move
within that row. Each time, I go over that cell that has the huge cell, the
whole content comes up on screen.

Is there a way to undo this.

I want the users to just use the arrow to move through the document and the
contents not to pop up.

Again, I hope this is making sense. Thanks for your time.

Is the "huge cell" the result of merging a block of cells into one?

If that's the case, you cannot prevent the display you see.

If not merged cells, are you seeing the contents in the formula bar as you arrow
into that cell?

No way to prevent that either without turning off the Formula bar or decreasing
the window size so the contents of the formula bar don't fall over the sheet.


Gord Dibben MS Excel MVP

On Thu, 8 Mar 2007 12:13:30 -0800, rp2chil
wrote:

Hi, I hope I can articulate this. I am working on a document that is a
survey and has large contents in certain questions/cells. When I get to the
row that has those huge cells, as I tab over to the specific cell, the whole
cell is displayed.

As I navigate through each cell, I use the right arrow or left arrow to move
within that row. Each time, I go over that cell that has the huge cell, the
whole content comes up on screen.

Is there a way to undo this.

I want the users to just use the arrow to move through the document and the
contents not to pop up.

Again, I hope this is making sense. Thanks for your time.

Gord, makes perfect sense, thanks So much for your help. Bye

"Gord Dibben" wrote:

Is the "huge cell" the result of merging a block of cells into one?

If that's the case, you cannot prevent the display you see.

If not merged cells, are you seeing the contents in the formula bar as you arrow
into that cell?

No way to prevent that either without turning off the Formula bar or decreasing
the window size so the contents of the formula bar don't fall over the sheet.


Gord Dibben MS Excel MVP

On Thu, 8 Mar 2007 12:13:30 -0800, rp2chil
wrote:

Hi, I hope I can articulate this. I am working on a document that is a
survey and has large contents in certain questions/cells. When I get to the
row that has those huge cells, as I tab over to the specific cell, the whole
cell is displayed.

As I navigate through each cell, I use the right arrow or left arrow to move
within that row. Each time, I go over that cell that has the huge cell, the
whole content comes up on screen.

Is there a way to undo this.

I want the users to just use the arrow to move through the document and the
contents not to pop up.

Again, I hope this is making sense. Thanks for your time.

If you protect the sheet, you could use the hidden property which will stop
the formula bar from displaying the contents. If the hugh cells do not need
editing, you could leave them locked then tabbing will take you to the next
unlocked cell, skipping the hugh cells altogether.

"rp2chil" wrote:

Hi, I hope I can articulate this. I am working on a document that is a
survey and has large contents in certain questions/cells. When I get to the
row that has those huge cells, as I tab over to the specific cell, the whole
cell is displayed.

As I navigate through each cell, I use the right arrow or left arrow to move
within that row. Each time, I go over that cell that has the huge cell, the
whole content comes up on screen.

Is there a way to undo this.

I want the users to just use the arrow to move through the document and the
contents not to pop up.

Again, I hope this is making sense. Thanks for your time.

Couple of good points here.


Gord

On Thu, 8 Mar 2007 14:04:25 -0800, bigwheel
wrote:

If you protect the sheet, you could use the hidden property which will stop
the formula bar from displaying the contents. If the hugh cells do not need
editing, you could leave them locked then tabbing will take you to the next
unlocked cell, skipping the hugh cells altogether.

"rp2chil" wrote:

Hi, I hope I can articulate this. I am working on a document that is a
survey and has large contents in certain questions/cells. When I get to the
row that has those huge cells, as I tab over to the specific cell, the whole
cell is displayed.

As I navigate through each cell, I use the right arrow or left arrow to move
within that row. Each time, I go over that cell that has the huge cell, the
whole content comes up on screen.

Is there a way to undo this.

I want the users to just use the arrow to move through the document and the
contents not to pop up.

Again, I hope this is making sense. Thanks for your time.