how I will gat count rows number and r botom coner

  • Thread starter Thread starter 2003 excel
  • Start date Start date
2

2003 excel

Hvae a excel 2003 and I like to see the count clls or rows how I will gat
number and r botom coner how many I hvae?
 
If you want the count of rows and cells to appear in a cell that is the lower
right corner cell on a worksheet, use this formula in that cell.
="Rows: " & ROW() & " Cells: " & ROW()*COLUMN()

For example, if you put that formula in cell E9, it will display:
Rows: 9 Cells: 45
 

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

number of cell 1
how i dow the following formal in excel 6
Auto sort function for a list 1
Relocating reference numbers for many blocks of data 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel is not counting 3
Can a macro capture this? 13
counting blank cells within two columns 2

Back
Top