Changing worksheet properties

<< Click to Display Table of Contents >>

Changing worksheet properties

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