And then there are those moments when you forget what you previously changed to make a dish so spectacular.

What you need is a digital recipe box.

Getting one doesnt require a single-purpose app, software, or subscription.

Computer in a kitchen with ingredients

All you need is Google Sheets.

So, how do you keep track of your recipes using this spreadsheet software?

Keep reading to learn how.

Column titles in spreadsheet software

Here’s how:

you’re free to also stick to this to create dropdown menus for theOccasionandRatingcolumns.

Dropdown lists work for anything that has a list of recurring answers.

Alternatively, you’re able to also access it through theDatamenu at the top.

Dropdown set up menu in spreadsheet software

There, you click onData validationand snag the one you want from the list of rules.

To keep things tidy as you do, addText wrappingto the column.

you’re able to find it in the toolbar among the other alignment icons.

Data validation rules list in spreadsheet software

By default, Google Sheets usesOverflow,which brings the text outside the cell.

Once you do, youll notice a symbolthree lines in a triangleappears beside your column title.

Click it, and youll see a menu with options tosort them alphabetically A-Z or Z-A.

Digital recipe list in spreadsheet software