Forum Discussion
Found in Excel Spreadsheet Grocery List, how to edit?
Are these Buttons? Widgets? How to edit them?
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,
- Clicking on them does not show any formula but it highlights them for moving or resizing.
- Behind them is the formula =calculations!J9 but J9 is empty
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,
- 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.
- I found the hidden sheet. Thank you. I thought I checked.
