If this option is selected, you can also specify the color for the grid lines in the current document. Specifies whether to display grid lines between the cells when viewed onscreen. Selecting view options for Calc Visual aids section In the Options dialog, choose Calc > View. Specifies that, when you paste cells from the clipboard to a cell range that is not empty, a warning appears. If this option is not selected, a printer-independent layout is used for screen display and printing. Specifies that printer metrics are applied for printing and also for formatting the display on the screen. Specifies whether to highlight column and row headers in the selected columns or rows. Highlight selection in column/row headings If you insert rows or columns in the middle of a reference area, the reference is always expanded. If the range A1:B1 is referenced and a new row is inserted under row 1, the reference is not expanded, since there is only a single cell in the vertical direction. This is only possible if the reference range, where the column or row is inserted, originally spanned at least two cells in the desired direction.Įxample: If the range A1:B1 is referenced in a formula and you insert a new column after column B, the reference is expanded to A1:C1. Specifies whether to expand references when inserting columns or rows adjacent to the reference range. The format will also apply to all new values inserted within this range.Įxpand references when new columns/rows are inserted
To see the affected range, press Ctrl+* (multiplication sign on the number pad). However, cells that already have a special format will not be modified by this function. If, for example, an inserted cell has the bold attribute, this attribute will also apply to empty adjacent cells. Specifies whether to automatically apply the formatting attributes of an inserted cell to empty adjacent cells. Specifies that pressing Enter puts the selected cell into edit mode. If this option is not selected, pressing Enter completes data entry for a cell but does not move the cursor. If this option is selected, you can also choose the direction the cursor moves: up, down, left, or right. Specifies that pressing Enter moves the cursor to another cell. You might want to avoid updating links when opening documents if they often contain many charts or linked graphics that would slow down loading. Regardless of this setting, you can manually update links at any time. Selecting general options for Calc Metrics sectionĬhoose the unit of measurement used in spreadsheets and the default tab stops distance.Ĭhoose whether to update links when opening a document always, only on request, or never.
0 kommentar(er)
