how to insert a drop down list in google sheets

I use 130 to 165 as character limits there, and do not use the 300 mark, because most websites use responsive design and this limit would apply to desktop visibility too. You can further play with the title limits based on what you are comfortable with.Īpply the same logic to Meta Descriptions. We are doing this because the sweet, green spot for character limit Titles is between 50 to 65 characters (we are not getting into the characters and pixels conversation here). Finally, set the Maxpoint to Number at 65, and the color to red again.Set the Midpoint to Number at 55, and the color to green.Set the Minpoint to Number at 45, and the color to red.I usually select the one that looks like traffic lights because it doesn’t need any further explanations.

Select the cells you want the coding to apply to (in my case column E - Titles, or column G - Meta Description).

A spreadsheet looking a little bit like a heatmap does the job.įor example, I set color-coding with conditional formatting. when I want to give an idea of the overall health of a website. I use it heavily in Content and Page Load Speed Audits, e.g. color codingĬolor coding helps on many levels.

Go to Data / Data Validation and select List of items.

Select the cells you will apply the list to.

You want to help out the content project manager monitor the status of the writing process but people have too many words for “in progress”.

drop down listĭrop-down list items are very handy in sheets that are shared with many people, when you want to give them some freedom to choose, but also stop them going crazy with the options. It is totally unfair, so here are the features I use the most in SEO projects. Google Spreadsheets are one of those tools that all marketers use but don’t mention around the water cooler.

How to insert a drop down list in google sheets