F5: The Go To Command!!

F5: The Go To Command!!

 

One of my favourite keyboard shortcuts in Excel is F5 – The Go to Command.
A very powerful command and a great time-saver especially when working with large datasets spread across multiple worksheets…

Not only does it help in Navigation to specific cell(s) / range(s), Defined Names, Tables within a workbook / open workbook(s) but also help in Selection.

aaaaa

F5 – The Go to Command
But what is really fascinating is the Go To Special option…

bbbbbb

Go To Special
There are so many different ways in which a navigation / selection can be done using the Go To Special option…
Have you explored the Power & experienced the Magic of the ‘Go To‘ & ‘Go To Special‘ commands yet??

Posted in Techtips and tagged , .

Leave a Reply

Your email address will not be published. Required fields are marked *