Forum Discussion
Found in Excel Spreadsheet Grocery List, how to edit?
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 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,
- I found the hidden sheet. Thank you. I thought I checked.
- 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.
