• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

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
0
tahirih
Asked:
tahirih
  • 2
2 Solutions
 
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
 
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 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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now