column range

[naeemdotcom]

Hello,
Is there any way to find out the range of cells up to which a column is filled with values?
Regards

[ashishmehra2010]

Hi,

Yes, you can use Go To Special>Last Cell

Regards,
AM

[Nisha Dhawan]

Hi,

You can use the shortcut key Ctrl+Down arrow key.

[naeemdotcom]

is there any formula for this also?

[FDibbins]

Post 2 will only work if there was nothing that was deleted that was below or to the right of the actual last cell of data
If you had data in J10 and deleted that, and your last actual filled cell is now E5, Go To Special will still take you to J10
End-Home will do have the same problem

CTRL Down will take you to the next filled cell - and the next filled cell etc

[FDibbins]

is there any formula for this also?

if you mean - is there any formula to take you the last cell, no, formulas only affect the cell they are in. If your data is consecutive, with no breaks and nothing under it that was deleted, you may be able to build a hyperlink that will take you there when clicked

[ashishmehra2010]

is there any formula for this also?

Hi Naeem,

Do you need Last Row without vba?

Kindly clarify.

Regards,
AM

[naeemdotcom]

i mean is "is there any formula to find out the count of filled cells in a column, given that there are no blank cells there?

[FDibbins]

try this...
=counta(A:A)

[ashishmehra2010]

Hi Naeem,

You can use COUNTA function.

Regards,
AM