Forum Discussion

RPait

Copper Contributor

Jul 22, 2022

Solved

Found in Excel Spreadsheet Grocery List, how to edit?

Are these Buttons? Widgets? How to edit them?

excel

Formulas and Functions

Riny_van_Eekelen
Jul 22, 2022
RPait Which template is that? I find one called "Grocery List" and the colours are alike, but I don't see the matrix of buttons.
Though, most templates like this have hidden sheets where you can edit options, provided you know what you are doing. So look for hidden sheets and see if these hold any clues to the options you see.

As a general comment, templates you find on line are good to use as they are. But they are often very difficult to adjust to your own specific needs,

Riny_van_Eekelen

Platinum Contributor

Jul 22, 2022

RPait Which template is that? I find one called "Grocery List" and the colours are alike, but I don't see the matrix of buttons.

Though, most templates like this have hidden sheets where you can edit options, provided you know what you are doing. So look for hidden sheets and see if these hold any clues to the options you see.

As a general comment, templates you find on line are good to use as they are. But they are often very difficult to adjust to your own specific needs,

RPait

Copper Contributor

Jul 22, 2022

Yes, I modified it to add the buttons as I want the spread sheet to select prices and group by store, category and show the price totals by category with the sum totals at the bottom. The column to the far right in my image is the original.