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?
Hi Lynda,
I use a macro see
www.mvps.org/dmcritchie/excel/toolbars.htm
and
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
quot;LyndaGTTquot; gt; wrote in message ...
gt; I need to update a monthly spreadsheet on a daily basis. How do I get to the
gt; bottom of the data without paging or scrolling down every time?
Press Ctrl and DownArrow
Vaya con Dios,
Chuck, CABGx3
quot;LyndaGTTquot; wrote:
gt; I need to update a monthly spreadsheet on a daily basis. How do I get to the
gt; bottom of the data without paging or scrolling down every time?
Ctrl and End keys
quot;LyndaGTTquot; wrote:
gt; I need to update a monthly spreadsheet on a daily basis. How do I get to the
gt; bottom of the data without paging or scrolling down every time?
- Sep 23 Tue 2008 20:46
How do I get to the last line of a large spreadsheet to add data
close
全站熱搜
留言列表
發表留言