Learnt how to do what I was asking about, no longer needed

Hello, thanks to anybody that helped me with this, i’ve now learnt how to do what I was asking about and no longer need help, Thanks.

I don’t see anything that looks like a menu in your screenshot, but it looks like a set of summary cells below the big list. Each of those cells probably has a formula that summarizes the list in one way or another. Try activating one of those cells and read the formula. The green highlighting is probably done with a Conditional Format based on the contents of column B.

Your original question suggests that you want to recreate the summaries at the bottom of the sample spreadsheet. I don't understand why you would want to do that so I am not likely to be able to suggest anything to you. That block of summary cells can be highlighted and then copied (with [Ctrl]-[C]) but then where would you want to paste it? And if you paste it somewhere else, would it retain the proper cell references related to the huge list of data above?

Maybe it would help if I describe what I can, but keep in mind that I cannot read the row highlighted in green (because of the horrible lack of contrast), except for column B where it says TRUE.

The cells in column B have apparently been formatted to display only a type BOOLEAN (as you described) and that means it will only show TRUE or FALSE. The author of this spreadsheet set that up, probably to allow you (as the end user) to change only the cells in column B, as a way to track your progress in marking the row Status as TRUE.

In the summary table it shows that you have marked only 1 row out of 432 rows. Notice the bottom row in the summary table that shows "All" and "1/432" and finally "0.23%" and you may notice that 0.23% is the decimal equivalent of 1/432. I'll bet if you scroll to the top of the spreadsheet you will find that there are 9 rows of something (probably a title and some instructions) that are not included in the huge list of data. I got that by subtracting 432 from 441 which is the row number at the bottom of the huge list. So your huge list of data has 432 rows in it and the summary table below tells you how many items have been marked TRUE.

One row above the bottom, in the summary table, it shows "Blood and Wine" with "1/82" and "0.23%" again. This tells me that there is a category labeled "Blood and Wine" that includes 82 rows, and that green row is one of them. The "0.23%" is unfortunately just a repeat of the total (1/432). I think it should probably show "1.22%" as the percent representing 1/82, so this is an error in the formula for that cell.

Don't [Right]-[Click] in the cells. That brings up a menu of things that you can do to the cell. If you want to investigate what's in the cell, simply [Left]-[Click] on the cell and then read what it says in that cell by looking at the row directly above columns A and B. That doesn't show in your screenshot but if you had clicked on the "1/432" in the summary table the contents would likely show some type of formula. You should see an expression beginning with "=" the equal sign.

But, as a new user of spreadsheets, you should stick with something basic rather than fiddling with this complicated example.

Try creating your own list, like the following:

![SpreadsheetExample|400x227](upload://szQeh7EEqQlZPLA7sxsALI8C1IO.jpeg)

That is a table of data made up of two columns with three rows, then a summary labeled "total" with a formula that adds up the numbers in column B.

Maybe you would enjoy going through an online tutorial on spreadsheets, like https://www.w3schools.com/googlesheets/index.php. It's not LibreOffice but most of what you find there will apply.