• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Excel in Practice

Excel's tools for selecting and naming ranges can be used to significantly reduce your setup time. Figure 3.11 shows a set of identical worksheets, created by grouping the sheets and selecting sections of their content. Simple formats were applied once, and that one action formatted all the sheets. This type of uniformity decreases the learning curve for users who have to work with the worksheets and makes it easier for you to build worksheets quickly and consistently.

Figure 3.11. These sheets were grouped, and selections in all three sheets were simultaneously formatted to achieve a consistent look throughout the workbook.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint