Tell me Something About Excel That You Think I Won't Know

[Jeffrey Mahoney]

Every once in awhile I learn a new way to do something in Excel that was always there. Ways to navigate in sheets, keyboard shortcuts, or formula tricks.

For instance, just about a month ago I learned that I could press the Ctrl-. (Control-Period) to activate the four corners of the selected range without de-selecting the range. Handy when I paste a large range and want to confirm that I didn't overwrite anything.

One of the handiest features that was added when SPILL formulas became a thing is using # after a cell reference to grab the spill results.

I can still use old menu shortcuts like ALT-E-S to get to the Paste-Special dialog.

How about you?

 

[davesexcel]

Formula in A1 =L1
Select A1 and type ctrl + [ and it will take you to L1
Select L1 and type ctrl + ] and it will take you to A1

A great alternative to hyperlinks works anywhere in the workbook

 

[Jeffrey Mahoney]

Formula in A1 =L1
Select A1 and type ctrl + [ and it will take you to L1
Select L1 and type ctrl + ] and it will take you to A1

Oh, it's like using the Dependents and Precedents except without Arrows. Nice!