View Single Post
 
Old 09-04-2024, 04:56 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

To set up a quick way of moving 82 cells down from where you are, on any sheet, create a named range as follows:
Select cell A6 on a sheet.
Go into Name Manager:

2024-09-04_124500.jpg

and click New…
then in the next dialogue box you'll see something like this:

2024-09-04_124612.jpg

Add a short name in the Name: field (I used go) and edit the Refers to: field to be exactly like this:
=!A88
like this:

2024-09-04_124710.jpg

click OK, then Close out of Name Manager.

Back on the sheet you can jump 82 cells down by either typing go into the Name box and pressing Enter:

2024-09-04_124807.jpg

or by pressing F5 on the keyboard and entering go, then click OK (or press Enter):

2024-09-04_124903.jpg

This will jump 82 cells down from wherever you are, whichever sheet you're on.
Reply With Quote