Adding a Very Heavy Cell Border

@Tomek
F5, I always forget about that one, thank you for reminding me.
Most often I am not working with large worksheets so what I need is usually within view.
The CTRL key is my biggest friend in Excel.

Some others as well.

1) If you make a Named Range for the cell, it will show up in the box ot the left of the Formula Editor and can be selected, whereupon you are in the cell and ready to roll.

2) Speaking of that box, it is like a mini-GoTo. Just click in it, type a cell reference and press Enter. Boom, you are in the cell, ready to roll.

3) Just pick an empty cell and enter in it the formula "=(Cell Address for the cell you want to edit)"... so, say it is F5, just enter "=F5"... Then double click the cell you entered it in and boom, you are in the cell you want to be in. This one, by the way, has some pretty far-reaching capabilities. It will open files for you if you enter an address in a closed file. (Or, more likely, already have it entered!) And in a cell with a more complicated formula, double clicking selects all the cells addressed in it with the first one addressed being the "starting cell" of the selected (likley) discontiguous range.

I suggest using a Named Range for selecting such ranges for, say, editing on a screen form (i.e.: NOT a "real" form, just material laid out on the screen, probably arranged like, perhaps, an invoice, in which a few, or mor ethan a few, cells need to be navigated to in order to allow the user to edit only the desired cells. But without any heavy lifting by the author (you)). However, one could simply place a cell with a simple formula, perhaps adding all the cells, listing them in the order one desires them navigated, or better, concatenated in either of the old styles that required each cell to be listed, though if a range in the order Excel will takes its address is acceptable, then using CONCAT() could be good too, and perhaps formatted number-wise with:

;;;"Click to select data cells"

(Has to use a formula resulting in text. If numbers could result, the cell will be blank instead.)

To be more "inclusive", enter the text string for all four parameters in a number format. (Interestingly, if you do, and you used addition, not concatenation, when you apply the format, if the cell width is still the default width, Excel will expand its width to fit your text. It does not do that when it is the string shown above. Must be triggered by the return of a number, much like entering a long number in a fresh column. If the addition returns an error because one of the cells had text in it, there is no column widening.)

Speaking of errors returned by that formula you use, one could wrap it in an IFERROR() returning "" so it returns text instead and your helpful label remains.

4) Select a cell, same row, left or right of it and use the appropriate arrow key to Ctrl-Arrow over to it. Same idea, but use the same column, select a cell above or below. Of course, it would only work if that would work if the graphic were not there. Various other navigation key combos (Mr. Wyatt has addressed a few oddballls) ought to work similarly, if they too would work without the graphic in place.

5) VBA. Either a dedicated macro, fearsome thought that, talk about "If you only have a pile driver, everything looks like a nail." But easy enough to do. Though one hopes you only need one, 'cause one would like a shortcut key combo for something like this and having 20 border graphics to get under might stress one's imagination and recollection in building and using them.

6) VBA but not a macro: Use the "Immediate Window"... it is remarkably easy and you don't have a .XLSM file. Not easier than Goto!!! Just listing it for completeness and to "raise everyone's conciousness" concerning all the awesome things one can do via the Immediate Window.

7) Highlight a region just a bit larger than the border graphic but that includes the cell it is laid upon. Make sure that cell is the "lower right corner" (or the "upper left corner"). Then use Ctrl-End (or Ctrl-Home, if "upper left corner") and you're in the cell.

Personally, I'll say I think the box to the left of the Formula Editor seems easiest if your hand is on the mouse as one simply clicks, types the address, and presses Enter. If your hand is off the mouse, "F5-type the address-press Enter" is the easiest. If you don't know or want to know the address one of the Arrow Key approaches seems easiest.

Naturally, that'd be modified by your version of Excel not supporting one or more of the thoughts folks have presented. But F5 (GoTo) and that box I mention are in all versions I can imagine, though I've not personally seen the online version which is said to lack many things (though to lack a simple to access GoTo seems just impossibly unlikely, even if it does lack the box I like). So, they ought to be reliable "go to" choices. (I could resist the sort of punning there.

The above said, and the prior comments said, who wants to bet someone knows or can figure out more ways?

@Alec, @Mike, @ Roy: There is another way to get to a cell under a shape, if you can't click on it - use F5 (goto) and specify the cell's addres ;-)

@Alec, @Roy: Roy's advice works perfectly and is the only way I have found that works if you use a text box to cover a cell.
However; if you use a shape (rectangle, circle) you can set the shape properties to 'No Fill' , this will allow you to click through the shape into the cell. It is like the shape is not there. If you need to format the shape you will need to click on the border to select the shape.
You can also add text to the shape and it will lay on top of anything in the cell.
This is how my Excel works, hope it helps you.

@Mike D. Interesting - what you and Roy suggest is exactly what I have done and submitted same as an answer last week. And it works fine on the PC I am using right now, yet on another machine, I find I cannot click into a cell covered by a shape, fill or not. Maybe a system fault on the other PC??
Anyway, it is pretty clear that big, bright borders can be easily achieved, so Steve should be a happy camper. :)

@Alec, @Roy: Roy's advice works perfectly and is the only way I have found that works if you use a text box to cover a cell.
However; if you use a shape (rectangle, circle) you can set the shape properties to 'No Fill' , this will allow you to click through the shape into the cell. It is like the shape is not there. If you need to format the shape you will need to click on the border to select the shape.
You can also add text to the shape and it will lay on top of anything in the cell.
This is how my Excel works, hope it helps you.

@Alec: It covers the cell, and makes the mouse no good for selecting the cell, but select a cell outside the border (solid color or gradient) and arrow into the cell. You slip right under the shape and can edit the cell as you please.

@Tomek - you learn something new every day! Thanks for that. I’ve always used shapes, but of course that blocks editing the cell.

You can also create colourful borders by formatting the border as gradient line.

I am attaching a screenshot of two examples below (see Figure 1 below) :