Settings, View tab

<< Click to Display Table of Contents >>

Settings, View tab

On the View tab in the dialog box of the ribbon command File | Options options_icon you can make some settings for the appearance of documents on the screen:

Markers

The options in this section allow you to modify the appearance of the little triangles that are displayed in cells that contain a comment and cells that are protected.

Color of comment markers

Here you can change the color of the little triangle that is displayed inside cells that contain a comment.

Color of protection markers

Here you can change the color of the little triangle that is displayed inside cells that are not protected (when sheet protection is enabled).

Size

This option allows you to change the size of these markers.

Snapping

Allows you to configure the available aids for positioning objects (text frames, picture frames, etc.) with your mouse:

Snap to cells

Normally, this option is disabled. That means, you can move objects arbitrarily with the mouse.
When you enable this option and try to change the position of an object with your mouse, the object jumps from one table cell to the next.
Enabling or disabling this function temporarily: When the option Snap to cells is enabled, you can temporarily disable it at any time by pressing and holding down the Alt key while moving an object with the mouse. The same works in the opposite manner: If the option is disabled, it can be temporarily enabled with the Alt key while moving.

Snap to other objects

When this option is enabled, the software automatically creates "magic" guides for the edges of each object in the current worksheet. These guides make it a lot easier to position objects perfectly aligned and evenly distributed.
These "magic" guides are usually invisible. They only become visible when you drag an object near such a guide with the mouse. As soon as the guide appears, the object automatically snaps to it. Something similar happens when you resize an object with your mouse.
Some examples of such guides:
If you drag an object to a position where it is roughly left-aligned with another object, a guide will automatically appear representing the left edge of the other object. If you let your object snap to it, it will be exactly left-aligned with the existing object.
The same applies to the right edge of objects.
If you drag an object to a position where it is roughly centered with another object, a guide will automatically appear representing the center of the object. If you let your object snap to it, it will be aligned exactly centered with the other object.
If you drag an object to a position below two other objects, you will also see a horizontal guide at the position where this third object would have exactly the same relative distance as the other two objects. (The three objects would then be distributed evenly.)
All of this works in both directions (horizontally and vertically) – for example, a magic guide is generated for the top and bottom edges of each object.
Tip: If you hold down the Alt key while moving the object, you can temporarily disable the Snap to other objects option that is generally enabled.

Snap tolerance

Here you can specify the tolerance for the Snap to other objects option described above. The higher the value, the earlier an object that you resize/move will snap to one of the "magical" guides for existing objects.
The default value is a distance of 8 pixels.

Paint grid behind cells

When you enable this option, the gray gridlines displayed between the table cells are no longer painted in front of the cells but behind the cells. As a result, the gridlines will no longer be visible for cell ranges that have a colored background.

Cell marker

Here you can change the color and line width of the cell frame (the dark frame that indicates the currently active cell in a worksheet).

cell_frame_detailed_a

Worksheet tabs

The worksheet register at the bottom of the document window displays tabs for each worksheet in the document.

This option allows you to change the font size used to display the worksheet name on each tab.