Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you go to the last row containing data in an excel sheet?
|
#2
|
|||
|
|||
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 ... |
#3
|
|||
|
|||
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 ... |
#4
|
|||
|
|||
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 ... |
#5
|
|||
|
|||
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 ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |