Another way to ensure you're reading and editing large spreadsheets accurately is using Excel's Freeze Panes tool, which keeps certain rows and columns on screen when you scroll down and across. Using ...

Click the Customize Quick Access button on the Quick Access Toolbar. An Excel Options dialog box will open. Click the Choose Command From list box button and select All Commands from the menu.

To do this, right-click "Focus Cell" in the View tab on the ribbon, and click "Add To Quick Access Toolbar." The Focus Cell icon will then appear at the top of your Excel window. If it doesn't ...