You can use the ribbon command Insert | group Tables | Sheet | Properties to define settings that will only affect the current worksheet.
If a document consists of several worksheets, you can change these settings separately for each sheet. To do so, switch to the desired worksheet and then choose the above command.
Tip: You will also find the command in the context menu by right-clicking on the worksheet register.
The program displays a dialog box with the following options:
▪Row header
| If this option is enabled, row headers (buttons labeled 1, 2, 3, etc., to the left of the table) are displayed in the worksheet. |
▪Column header
| If this option is enabled, column headers (buttons labeled A, B, C, etc., above the table) are displayed in the worksheet. |
| Tip: You can also use the ribbon command View | Row and column headers to enable/disable the row and column headers together. |
▪Page breaks
| This option determines whether dark gray lines indicating the location of page breaks for the printout are displayed in the worksheet. (For more information, also see Adjusting page breaks manually.) |
| Tip: This option can also be found directly on the ribbon tab View as Show page breaks. |
▪Show zero values
| A cell contains a zero value when it contains either the number 0 (zero) or a calculation that returns zero. |
| If this option is enabled, the number "0" will be displayed in such cells as usual. If you disable it, nothing will be displayed there. |
| Tip: This option can also be found directly on the ribbon tab View as Show zero values. |
▪Gridlines
| This option determines whether gridlines are displayed between cells on-screen. You can also change the color of these lines as desired. |
| Tip: This option can also be found directly on the ribbon tab View as Show sheet grid. |
| Gridlines do not appear in printouts by default. To include gridlines in a printout, choose the ribbon command File | group Print | Page setup, switch to the Options tab and enable the option Grid. |
▪Sheet tab
| The worksheet register at the bottom of the document window displays tabs for each worksheet in the current document. |
| With this option, you can change the color of the tab for the current worksheet. |
▪Background
| If you enable the option Alternating shade, alternating shading is applied to the rows of the worksheet: Odd lines are shaded as specified with the Shading 1 button, while even lines are shaded as specified with the Shading 2 button. |
▪Sheet direction
| For worksheets in Arabic script, you can change the direction of the worksheet to right-to-left here. |
| Doing this will reverse the horizontal direction of the worksheet – thus cell A1 will now be in the top right corner rather than in the top left corner. |