![]() Often, we wish to keep certain data in view at all times. Here are a few more tips for formatting your to-do list: Freezing Particular Rows and Columns You can simply add a text in the heading and bold it, or you can use conditional formatting to color-code it so you and your team will instantly know what to look for as we showed you above. You have full creative freedom on how you could do this. Let’s say you wish to add a column that allows you to indicate tasks of higher priority. Not only that, you can add and remove columns and rows depending on your needs. The best part about utilizing Google Sheets as a to-do list is that many formatting options allow you to make your own personalized list. More Tips to Format Your To-Do List on Google Sheets Just change B2:B14 to the range that your list lies within. Note: You can add the strikethrough conditional formatting to your custom to-do list with the following settings from the menu under Format > Conditional formatting. Optional: You can add conditional formatting, extra columns, and a progress bar if needed, as we demonstrated with the template. ![]() Add the items to the checklist in column B and stretch the column to fit the tasks.Add checkboxes by navigating to Data > Data validation and selecting Checkbox from the Criteria drop-down menu.Highlight the cells you wish to have checkmarks in column A.Merge calls A1 and A2 and give your to-do list a title, then center the text.Put the following sparkline formula into cell C4 =SPARKLINE(COUNTIF(A5:A,TRUE),).Right-click on the row 3 header and click Add 1 row below.Click on Done to add the rule to the conditional formatting list. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |