Excel® 2013 On Demand

Setting Workbook and Worksheet Display Options

You can customize the way Excel appears when you work on a worksheet. If you don’t use scroll bars or sheet tabs, you can hide them to display more data. If you are creating a custom spreadsheet, you can change the color of the gridlines or hide them all together. If you prefer not to see zeroes in cells, you can hide zero values until they change. The Advanced pane in the Excel Options dialog box allows you to change the way you view a worksheet or workbook in Excel to suit your needs. For example, if you prefer the sheet tabs on the right side of the workbook instead of the left, you can set an option to change it.

Change Workbook Display Options

Click the File tab, and then click Options.