View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bassman62 Bassman62 is offline
external usenet poster
 
Posts: 117
Default 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?