Formula for checkbook registry

[71LoveTech]

I’m trying to make a checkbook registry. My columns do not think they go together. Decending and Accending does not change the entire row. How do I format? So date and description etc., accending and decending will end up on the same row

I have format date column under fortmat cell on a right click, bold on the column letter, and changed the font in the font size, and center the entire column and it will not stay if I accidently click on a down arrow or tab. What do I need to do to get that to stay that way.

I’m new at this LIbreOffice Cal, I have used Excel but not in years, so I’m relearning again.

Thanks,
71LoveTech

[LeroyG]

@71LoveTech, I am not sure to understand, but will try.

To sort (ascending and descending) you must select all occupied cells in each row. You can select dragging with the mouse, or moving the cell cursor with the arrow keys while pressing Shift.

To format a column, right-click in the columns header (A for the first column), then choose Format Cells… If the cells are empty, you would not see changes until you type some data. Maybe it’s better not to select all cells in a column but those in which will be data.

How do you want to see the date?

---

Please, press edit below your question to add more information. Add Answer is reserved for solutions.

[igorlius]

@71LoveTech. Adding an actual Question would be really helpful. … but i suspect, that you are playing around with the autofilter … and are having some trouble sorting multple colums/rows … based on this assumption, i’ll will try to give an answer …

[71LoveTech]

I’m entering some receipts on this checkbook registry, let say I entried the date, description such as Walmart is in the and the amount is in a different column. The next role I entered a later or more recent receipt. When I clicked on the Accending and Decending the description Walmart, Amount did not accend and decend with the date.

[igorlius]

To sort multiple columns (by one or more criteria) you can do the following:

1. Select the rows and colums you want to Sort
   
   
2. Open the Sort Menu via “Data” > “Sort …”
   
   
   
3. In the opend Window, choose by criterias to sort the selected rows, (here i chooose Colum A and under option i selected naturalsort)
   
   
   
4. This is the resulat after clicking on the OK button
   
   
   
   
   Hope that helps.
   
   
   
   To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!
   
   
   

[igorlius]

@71LoveTech: I updated the screenshot to be more inline with you Checkbook / Spendbook Example
If this still is not what you meant, it would be really helpful if could show (upload) a small sample (screenshot) of what you have and maybe manually rearrange that sample to show want you want to achieve.

[71LoveTech]

Thank you I will try this.
I just tried sort criteria and learned about that function. This is what I was looking for. Thanks for your help
bc it did help
Now everything I got on the formula to get the balance on each line has not worked. Overnight miracles
may have helped.