Missing information in excell

[Stretch]

When selecting multiple columns or rows, IE click on column A, hold and drag
multiple columns, the little box that counts the number of columns, IE 1C,
2C, 3C..., is not there. So when I do a V-Lookup function, and scroll across
the columns I need to use, it doesn't count them for me.

Has anyone else seen or have had this problem?

TIA

Stretch

 

[Bernard Liengme]

It sound like you are talking about the Name Box which is part of the
Formula Bar
Use View and click on Formula Bar
Please come back if I misread your problem
best wishes

 

[Bob Umlas]

It's right next to the cursor, not in the name box.

 

[Bernard Liengme]

So how do we get OP's little box back, Bob

 

[Spiky]

When selecting multiple columns or rows, IE click on column A, hold and drag
multiple columns, the little box that counts the number of columns, IE 1C,
2C, 3C..., is not there.  So when I do a V-Lookup function, and scroll across
the columns I need to use, it doesn't count them for me.  

Has anyone else seen or have had this problem?

TIA

Stretch

Go into Customize, to the Options tab. Turn on Tooltips.

 

[Gord Dibben]

Tools>Customize>Options

Checkmark "show screentips on toolbars"


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Check out my reply Bernie.


Gord

 

[Stretch]

Tools>Customize>Options

Checkmark "show screentips on toolbars"


Gord Dibben MS Excel MVP

Perfect!! That was it. A friend of mine and I were tearing our hair out
trying to find the right option to check to get it back.

Thanx!!!

stretch