| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get to the last line of a large spreadsheet to add data
I need to update a monthly spreadsheet on a daily basis. How do I get to the
bottom of the data without paging or scrolling down every time? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get to the last line of a large spreadsheet to add data
Hi Lynda,
I use a macro see http://www.mvps.org/dmcritchie/excel/toolbars.htm and http://www.mvps.org/dmcritchie/excel/navigation.htm see the black arrow pointed down on a yellow background for the toolbar icon. --- 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 "LyndaGTT" wrote in message ... I need to update a monthly spreadsheet on a daily basis. How do I get to the bottom of the data without paging or scrolling down every time? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get to the last line of a large spreadsheet to add data
Press Ctrl and DownArrow
Vaya con Dios, Chuck, CABGx3 "LyndaGTT" wrote: I need to update a monthly spreadsheet on a daily basis. How do I get to the bottom of the data without paging or scrolling down every time? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get to the last line of a large spreadsheet to add data
Ctrl and End keys
"LyndaGTT" wrote: I need to update a monthly spreadsheet on a daily basis. How do I get to the bottom of the data without paging or scrolling down every time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying filtered data to another Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
