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.
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
