| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column index number | Excel Discussion (Misc queries) | |||
| vlookup column index number argument | Excel Worksheet Functions | |||
| Multiple Column Index Number in VLookup | Excel Worksheet Functions | |||
| How to automatically number an index column | Excel Worksheet Functions | |||
| having one more than one column index number | Excel Worksheet Functions | |||
Hybrid Mode
