How do I get excel to display the number of columns selected?

M

Matt

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?
 
B

Bassman62

In XL 2003 and 2007 the "nR x nC" appears in the "Name Box" just left of the
Formula Bar.
Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Visual Basic to get current row number 1
How do I add cells by highlighting them? 2
How to fix a number of rows below the selected cells? 0
How to count the number of selected combobox within Excel? 10
Cells display as R5C5. How do I change it to display E5? 2
Ran out of columns in excel worksheet. How do I increase them? 3
How do I display the row number 1
How to set up Excel to print wrapped columns on a page. 1

Top