Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how I will gat count rows number and r botom coner

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default how I will gat count rows number and r botom coner

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



"2003 excel" wrote:

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNT NUMBER OF ROWS Keep It Simple Stupid Excel Worksheet Functions 2 February 9th 07 06:54 PM
Count how many Rows ago a particular number was hit rhhince Excel Worksheet Functions 1 January 13th 07 09:06 PM
Count number of rows, where non relevant rows are hidden Pieter Excel Discussion (Misc queries) 2 November 8th 06 12:24 PM
Count rows and insert number to count them. Mex Excel Discussion (Misc queries) 6 August 23rd 06 02:29 AM
the right botom does not work in excel 2003 Drussilla Excel Discussion (Misc queries) 1 July 4th 06 07:10 PM


All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"