Column index number
 

Hello,

I have lost this feature and not really sure what it's called.

If you are in a spreadsheet, and you click on col "B" and drag to col "G",
next to the mouse cursor it should read 6 as in how many columns are
highligted. I can no longer see that number, how could I re-enable it?

Column index number
 

In XL2003: menus ToolsOptionsGeneral tabR1C1 Reference style
In XL2007: Office ButtonExcel Options Formulas'Working with formulas'
R1C1 reference style

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

Hello,

I have lost this feature and not really sure what it's called.

If you are in a spreadsheet, and you click on col "B" and drag to col "G",
next to the mouse cursor it should read 6 as in how many columns are
highligted. I can no longer see that number, how could I re-enable it?

Column index number
 

That is not it, it still dosen't count with the mouse.

"Jacob Skaria" wrote:

In XL2003: menus ToolsOptionsGeneral tabR1C1 Reference style
In XL2007: Office ButtonExcel Options Formulas'Working with formulas'
R1C1 reference style

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

Hello,

I have lost this feature and not really sure what it's called.

If you are in a spreadsheet, and you click on col "B" and drag to col "G",
next to the mouse cursor it should read 6 as in how many columns are
highligted. I can no longer see that number, how could I re-enable it?

Column index number
 

Hi Steve; the tooltip showing 1C,2C,3C is displayed only when you select the
entire column..When you select the entire row it shows as 1R,2R etc;

Try selecting the rows or columns using mouse..

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

That is not it, it still dosen't count with the mouse.

"Jacob Skaria" wrote:

In XL2003: menus ToolsOptionsGeneral tabR1C1 Reference style
In XL2007: Office ButtonExcel Options Formulas'Working with formulas'
R1C1 reference style

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

Hello,

I have lost this feature and not really sure what it's called.

If you are in a spreadsheet, and you click on col "B" and drag to col "G",
next to the mouse cursor it should read 6 as in how many columns are
highligted. I can no longer see that number, how could I re-enable it?

Column index number
 

Thanks, Jacob, but the indicatior that i'm talking about is if you click and
hold the left mouse button and drag the cursor to the right on the column or
row, there is a counting indicator next to the cursor which follow along with
it indicating how many rows or colnmus that you have selected.

"Jacob Skaria" wrote:

Hi Steve; the tooltip showing 1C,2C,3C is displayed only when you select the
entire column..When you select the entire row it shows as 1R,2R etc;

Try selecting the rows or columns using mouse..

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

That is not it, it still dosen't count with the mouse.

"Jacob Skaria" wrote:

In XL2003: menus ToolsOptionsGeneral tabR1C1 Reference style
In XL2007: Office ButtonExcel Options Formulas'Working with formulas'
R1C1 reference style

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

Hello,

I have lost this feature and not really sure what it's called.

If you are in a spreadsheet, and you click on col "B" and drag to col "G",
next to the mouse cursor it should read 6 as in how many columns are
highligted. I can no longer see that number, how could I re-enable it?

Column index number
 

That's what Jacob just said.

Select entire column by selecting the header and drag across.


Gord Dibben MS Excel MVP

On Tue, 1 Sep 2009 10:56:02 -0700, Steve
wrote:

Thanks, Jacob, but the indicatior that i'm talking about is if you click and
hold the left mouse button and drag the cursor to the right on the column or
row, there is a counting indicator next to the cursor which follow along with
it indicating how many rows or colnmus that you have selected.

"Jacob Skaria" wrote:

Hi Steve; the tooltip showing 1C,2C,3C is displayed only when you select the
entire column..When you select the entire row it shows as 1R,2R etc;

Try selecting the rows or columns using mouse..

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

That is not it, it still dosen't count with the mouse.

"Jacob Skaria" wrote:

In XL2003: menus ToolsOptionsGeneral tabR1C1 Reference style
In XL2007: Office ButtonExcel Options Formulas'Working with formulas'
R1C1 reference style

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

Hello,

I have lost this feature and not really sure what it's called.

If you are in a spreadsheet, and you click on col "B" and drag to col "G",
next to the mouse cursor it should read 6 as in how many columns are
highligted. I can no longer see that number, how could I re-enable it?

Column index number
 

Steve; this appears not necessarily near your mouse; but near the column/row
header area. Try Ctrl+Spacebar to select entire column..now try to extend the
selection using Shift+Right arrow..Now the tooltip near the header can be
viewed

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

Thanks, Jacob, but the indicatior that i'm talking about is if you click and
hold the left mouse button and drag the cursor to the right on the column or
row, there is a counting indicator next to the cursor which follow along with
it indicating how many rows or colnmus that you have selected.

"Jacob Skaria" wrote:

Hi Steve; the tooltip showing 1C,2C,3C is displayed only when you select the
entire column..When you select the entire row it shows as 1R,2R etc;

Try selecting the rows or columns using mouse..

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

That is not it, it still dosen't count with the mouse.

"Jacob Skaria" wrote:

In XL2003: menus ToolsOptionsGeneral tabR1C1 Reference style
In XL2007: Office ButtonExcel Options Formulas'Working with formulas'
R1C1 reference style

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

Hello,

I have lost this feature and not really sure what it's called.

If you are in a spreadsheet, and you click on col "B" and drag to col "G",
next to the mouse cursor it should read 6 as in how many columns are
highligted. I can no longer see that number, how could I re-enable it?