From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- .../source/text/scalc/guide/cell_enter.xhp | 60 ++++++++++++++++++++++ 1 file changed, 60 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/cell_enter.xhp (limited to 'helpcontent2/source/text/scalc/guide/cell_enter.xhp') diff --git a/helpcontent2/source/text/scalc/guide/cell_enter.xhp b/helpcontent2/source/text/scalc/guide/cell_enter.xhp new file mode 100644 index 000000000..c7f81cab7 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/cell_enter.xhp @@ -0,0 +1,60 @@ + + + + + + + + + Entering Values + /text/scalc/guide/cell_enter.xhp + + + +values; inserting in multiple cells + inserting;values + cell ranges;selecting for data entries + areas, see also cell ranges + +Entering Values + + Calc can simplify entering data and values into multiple cells. You can change some settings to conform to your preferences. + To Enter Values Into a Range of Cells Manually + There are two features that assist you when you enter a block of data manually. + Area Detection for New Rows + In the row below a heading row, you can advance from one cell to the next with the Tab key. After you enter the value into the last cell in the current row, press Enter. Calc positions the cursor below the first cell of the current block. + +area detection + + In row 3, press Tab to advance from cell B3 to C3, D3, and E3. Then press Enter to advance to B4. + Area Selection + Use drag-and-drop to select the area where you want to input values. But start dragging from the last cell of the area and release the mouse button when you have selected the first cell. Now you can start to input values. Always press the Tab key to advance to the next cell. You will not leave the selected area. + +area selection + + Select the area from E7 to B3. Now B3 is waiting for your input. Press Tab to advance to the next cell within the selected area. + To Enter Values to a Range of Cells Automatically + See Automatically Filling in Data Based on Adjacent Cells. +
+ + + +
+ + -- cgit v1.2.3