Libreoffice Calc

shortcuts

hide column: right click column, hit i

missing Accelerator Keys in context menu (right click)

Right click, hover away, hover over something, press Alt. Wow.

monthly cash flow

• select columns for Date and Money

• Insert > Pivot Table

  • drag Date field into the Row Fields box

  • drag Money field into the Data Fields box

  • OK

• select any date inside your Pivot Table

• hit F12

• select month (probably pre-selected)

• OK

exclude outliers

Add column “ignore” and manually put “TRUE” on rows you want to exclude.

Select your pivot table, hit Insert > Pivot Table again to edit, add “ignore” to Filters.

clip text

For printing, I want text of the last column to clip instead of wrapping. Put a single space in a column after your column.

Page Setup: Landscape

Format > Page Style > Orientation: Landscape