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.

Read: Customize the Quick Access Toolbar in Excel to make it work for you. When the Format Cells window opens, switch to the Alignment tab. Click the Alignment tab. Under the Text alignment ...