ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Shortcut for going to a particular line in a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/254014-shortcut-going-particular-line-worksheet.html)

blnorwood

Shortcut for going to a particular line in a worksheet
 
Is there a shortcut to go to a particular line in a worksheet? I want a fast
way to go from line 1 to line 1100.

Dave Peterson

Shortcut for going to a particular line in a worksheet
 
Does go mean change the selection to (say) A1100?

If yes, then hit F5 and type A1100 and hit enter.


If you mean select rows 1 to 1100,
hit F5 and type: 1:1100
and hit enter



blnorwood wrote:

Is there a shortcut to go to a particular line in a worksheet? I want a fast
way to go from line 1 to line 1100.


--

Dave Peterson

Bob I

Shortcut for going to a particular line in a worksheet
 
put A1100 in the Name Box

blnorwood wrote:
Is there a shortcut to go to a particular line in a worksheet? I want a fast
way to go from line 1 to line 1100.




All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com