Using the ribbon command Insert | group Tables | Sheet | Properties , you can define settings that 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 tab.
The program displays a dialog box with the following options:
▪Row header
| Determines whether row headers are displayed in the worksheet. Row headers are buttons labeled with the row number, displayed to the left of the worksheet. |
▪Column header
| Determines whether column headers are displayed in the worksheet. Column headers are buttons labeled with the column number, displayed above the worksheet. |
| Tip: You can also use the ribbon command View | Row and column headers to enable/disable the row and column headers at once. |
▪Page breaks
| Determines whether dark gray lines indicating the location of page breaks are displayed in the spreadsheet. |
| 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
| Determines whether gridlines are displayed between cells on-screen. Also, you can 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. |
| By default, gridlines do not appear in printouts. To include gridlines in a printout, choose the ribbon command File | group Print | Page setup, switch to the Options tab and enable the Grid option. |
▪Sheet tab
| The worksheet register at the bottom of the document window displays tabs for each worksheet in the document. |
| With this option, you can change the color of the tab for the current worksheet. |
▪Background
| When you enable the option Alternating shade, alternating shading is applied to the lines of the table: Odd lines are shaded as specified with the Shading 1 button, even lines are shaded as specified with the Shading 2 button. |
▪Sheet direction
| For tables 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 – so that the cell A1 is no longer in the top left corner but in the top right corner. |