![]() ![]() ![]() ![]() (See our dropdowns tutorial for details.) If you’re working with a dropdown that’s part of a template, you can’t add or rearrange options. If the dropdown is one you created yourself, you can further edit it by adding more options or dragging-and-dropping the options to reorder them. To change the color of an item in the dropdown, click the circle icon to its left and select a color. You can edit any item by clicking it and typing in new text or numbers. You can edit the options that appear in a dropdown, or change their background colors.Įach option that appears in the dropdown is in a separate text box in the sidebar. The “Data validation rules” sidebar opens to the right of your spreadsheet, showing the rules for this dropdown. To edit a dropdown list: Click the small down arrow at the right edge of the cell that contains the list, then click the pencil icon at the bottom of the menu that appears. Instead, we’ll focus on editing an existing dropdown list, including adding background colors. See our tutorial on using dropdown lists in Google Sheets for full instructions. We won’t go into all the details of creating a dropdown list from scratch here. Howard Wen / IDGĭropdown lists provide a great way for your team to track the status of various tasks that are part of a project. You can enhance these dropdowns with background colors that denote status at a glance. In a project management spreadsheet, it’s useful to have a status dropdown for each task, with options such as On Hold, Not Yet Started, In Progress, and Complete, as in the “Project tracking” template we looked at earlier. Or, if you’re working from a template that already includes dropdown lists, you can add, edit, or remove options in any dropdown. You can create a dropdown that lists specific numbers or words that you’ve entered as preset choices. In this way, you can tweak the template to suit your project perfectly. To add a column or row: Do the same thing and select Insert 1 column left, Insert 1 column right, Insert 1 row above, or Insert 1 row below. To delete any columns or rows you don’t need: Select the column or row, right-click, and select Delete column or Delete row. Select one of the options and it will appear in the cell. Double-click the cell (or click its down arrow) to see other options to choose from. To select a different option from a dropdown list: Dropdown lists have a small down arrow to the right of the cell. To change a date field: Type in a new date or double-click to bring up a mini-calendar where you can select a date. To change any text field: Simply select it and start typing. The Project tracking template gives your team a quick leg up on keeping track of all the tasks to complete a project.Ĭlick anywhere in the spreadsheet to start adjusting it for your own project. Within each project or stage, you can enter specific tasks necessary to complete the project, along with a status, priority, start and end date, assignee, estimated hours, and more for each task. The “Project tracking” template, for example, includes areas where you can track one or more stages of a project. Click a thumbnail to start a new spreadsheet using that template. There are four templates to choose from: Gantt chart, Project timeline, Project tracking, and Event marketing timeline. On the “Template gallery” page, scroll down until you see the “Project management” header. (Click any image in this story to enlarge it.) Save time by starting with a project management template, then adapting it for your project’s needs. You’ll see a page with template thumbnails. On the menu that appears, hold your pointer over the arrow to the right of Google Sheets and select From a template. Click Template gallery to the upper right of the thumbnails, and you’ll be taken to a full page with template thumbnails.įrom Google Drive: On your Drive home page, click the New button at upper left. From Google Sheets: At the top of your Google Sheets home page, you’ll see a “Start a new spreadsheet” header with a row of thumbnails underneath. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |