libreoffice_annoyances
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
libreoffice_annoyances [2021.11.22 08:34] – Steve Isenberg | libreoffice_annoyances [2021.11.22 08:38] – [Replace dates with incremented year] Steve Isenberg | ||
---|---|---|---|
Line 4: | Line 4: | ||
=====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. | + | Your spreadsheet has a column with dates, say A7 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 | + | - Insert new (temporary) |
- | - Apply this formula in new column | + | - Apply this formula in new column |
- | - Select the cell C7 and drag down to select all rows in column | + | - Select the cell B7 and drag down to select all rows in column |
- Control-D (pastes the formula down the column). You should see the updated dates in column C. | - Control-D (pastes the formula down the column). You should see the updated dates in column C. | ||
- | - Select all of the column | + | - Select all of the column |
- | - Put cursor in first date you want to change, that is, in cell B7 | + | - Put cursor in first date you want to change, that is, in cell A7 |
- Edit > Paste Special > Paste Special. | - Edit > Paste Special > Paste Special. | ||
- | - You can delete column | + | - You can now safely |
====Give a Cell a Name and Use It Elsewhere==== | ====Give a Cell a Name and Use It Elsewhere==== |
libreoffice_annoyances.txt · Last modified: 2022.12.05 13:05 by Steve Isenberg