Changing worksheet properties

<< Click to Display Table of Contents >>

Changing worksheet properties

Using the ribbon command Insert | group Tables | Sheet dropdown_arrow | Properties sheet_prop_icon, 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 row_column_headers_icon 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.
For more information, see also Working with Arabic text.