Differences

This shows you the differences between two versions of the page.

--- libreoffice_annoyances [2019.12.14 06:06] – Steve Isenberg
+++ libreoffice_annoyances [2021.11.22 08:34] – Steve Isenberg
@@ Line 1: / Line 1: @@
-=====LibreOffice Annoyances=====
+<fs xx-large>LibreOffice Annoyances</fs>
 Maybe not //annoyances// but ways of getting things done.
-====Spreadsheet====
+=====Spreadsheet=====
-===Replace dates with incremented year===
+====Replace dates with incremented year====
 Your spreadsheet has a column with dates, say B7 has 1/2/2019 and you want to replace the dates in the rest of the column with the next year, e.g., 2020.
   - Insert new column to right of dates column (new and blank column C)
@@ Line 12: / Line 13: @@
   - Edit > Paste Special > Paste Special.  Make sure All is not checked and Formula is not checked.  Paste.  OK the overwrite.
   - You can delete column C.
+====Give a Cell a Name and Use It Elsewhere====
+It's easier to name a cell so that (a) references make sense and (b) you can move the cell but retain the reference.\\ //for example referencing payment totals when adding/deleting rows/columns around them.//
+How to name a cell
+  * Select the cell
+  * Upper-left corner, see the letter-number (e.g., D23) of the cell. Type the name you want in this spot (e.g., CCjan)
+  * Repeat as needed
+Alternatively you can select the cell, Sheet > Named Ranges and Expressions > Define
+How to use a named cell
+  * Select the cell to reference the name
+  * Type = and start to type the cell name (e.g, C C j a)
+  * When the desired name is the only choice, press enter.
+Note that names can be used within formulas.