Are you struggling to navigate around large Excel spreadsheets?

 

Today we are going to show you some simple tips to help you navigate your spreadsheet more efficiently.

If you use larger spreadsheets this tip can save you valuable minutes clicking the screen in frustration. Traditionally you might use the arrow keys on the keyboard to navigate from cell to cell, however if you need to move a number of cells then it becomes slow and clunky.

Software Versions : Office 365, Office 2016, Office 2013 and Office 2010

 

How To Speed up Navigation in a Large Excel Spreadsheet.

Step 1) Press and hold the CTRL key on the bottom left of the keyboard.

Step 2) Press the arrow in the direction you would like to travel.

 

Using this method the number of keyboard clicks is greatly reduced and the speed you can travel around the spreadsheet is greatly reduced.

Author: Jonathan Lawton

With almost a decade’s experience of successfully, supporting, designing and delivering innovative web development projects worldwide I now focus on providing leadership to help customers shape business and technology strategy.

Start a Conversation