| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get excel to display the number of columns selected?
Excel normally displays the number of cells/columns selected as you slick and
drag across the sheet, selecting multiple rows or columns. This number usually appears in a little yellow box next to the cursor as "#R' or '#C'. For some reason, my version of excel has stopped displaying this number, which is very annoying when performing VLookups, etc. How do you get excel to display this number? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get excel to display the number of columns selected?
In XL 2003 and 2007 the "nR x nC" appears in the "Name Box" just left of the
Formula Bar. Hope this helps. "Matt" wrote in message ... Excel normally displays the number of cells/columns selected as you slick and drag across the sheet, selecting multiple rows or columns. This number usually appears in a little yellow box next to the cursor as "#R' or '#C'. For some reason, my version of excel has stopped displaying this number, which is very annoying when performing VLookups, etc. How do you get excel to display this number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
| How to print selected columns that are not adjacent in Excel | Excel Discussion (Misc queries) | |||
| How to print selected columns that are not adjacent in Excel | Excel Worksheet Functions | |||
| How I can copy / paste a selected cells to other columns in Excel | Excel Discussion (Misc queries) | |||
| HOW DO I DISPLAY ZERO VALUES IN SELECTED CELLS IN EXCEL. | Excel Discussion (Misc queries) | |||
Linear Mode
