Excel - last filled cell - row/column

Hi,

How can I determine what is the last filled cell - greatest row and column, without scrolling. Not all cells in the worksheet are filled.

Thanks
tahirihAsked:
Who is Participating?
 
RunriggerCommented:
1) Press F5
2) click the "special" button, bottom left
3) Select "Current region", about halfway down on the left hand side
4) Press "Alt-Tab" together

This will take you to the last row/last column
0
 
zorvek (Kevin Jones)ConsultantCommented:
To find the last alphanumeric value in a column that may contain empty or blank cells or cells with only spaces (array formula):

   =INDEX(A:A,MAX((TRIM(A2:A100)<>"")*ROW(A2:A100)))

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
To display the row number containing the last value on a worksheet:

   =MAX((TRIM(A2:A65536)<>"")*ROW(A2:A65536))

Kevin
0
 
tahirihAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.