Font and cell formattingĭraw attention to certain elements of your sheet by setting various font and cell background formats. Details about how to do this on this are included in the Parent Rollup article.įor more information on creating hierarchical relationships, check out the article on using hierarchy. You can use these hierarchical relationships along with formulas, for example, to automatically calculate a weighted percent complete on a parent task based on data in the child tasks. Indent rows to create an organized structure to your sheet, with child rows that fall under a parent row. You can apply different date formats (for example, long form dates) with the steps in Apply a Standardized Date Format in Your Sheet. When you release your click, all columns and rows in the sheet should be highlighted and you can then set formatting for the entire sheet. Highlight all columns in the sheet by clicking the left-most column's header, scrolling to the right, then Shift+clicking the right-most column's header. Select the column header to apply column formatting to existing and newly added cells in the column. Select the row number to apply row formatting to existing and newly added cells in the row. Take this action before you click a formatting icon Follow the guidance below to help with this. You can format groups of data all at once. Select Conditional Formatting and follow the instructions on your screen. You can set rules to change the format of a cell when the data in that cell changes, for example, highlight a row in red when a deadline is past due and a task is not marked as complete. Learn more in Auto-Fill Formatting and Formulas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |