How do you go to the last row containing data in an excel sheet?
 

Ctrl+Down Arrow will take you to the last populated cell in a column,
provided all cells in that column are populated.
************
Anne Troy
www.OfficeArticles.com

"Carol" wrote in message
...

Oh my god thank you!!! :)

"Anne Troy" wrote:

Ctrl+Down Arrow will take you to the last populated cell in a column,
provided all cells in that column are populated.
************
Anne Troy
www.OfficeArticles.com

"Carol" wrote in message
...

Sure. Also try Shift+Ctrl+Down (or Right) to select "from here down". Here's
mo
http://www.officearticles.com/excel/...rtcut_keys.htm
************
Anne Troy
www.OfficeArticles.com

"Carol" wrote in message
...
Oh my god thank you!!! :)

"Anne Troy" wrote:

Ctrl+Down Arrow will take you to the last populated cell in a column,
provided all cells in that column are populated.
************
Anne Troy
www.OfficeArticles.com

"Carol" wrote in message
...

Hi Carol,
Please put you complete question into the body of your posting.
A technique to get you to the bottom of the column, or to the next row
can be seen in You will want to paste the buttons to your toolbar for this
I think. http://www.mvps.org/dmcritchie/excel/toolbars.htm#macro

Sub GotoBottomOfCurrentColumn()
'Tom Ogilvy 2000-06-26
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select
End Sub


The code for the next available cell at the bottom that you might
use in another macro would be something like the following though
you want to avoid selecting anything, but this is the how it works.

Cells(Rows.Count, ActiveCell.Column).End(xlUp).offset(1,0).Select
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Carol" wrote in message ...