• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Setting Up a Workbook > Making Workbooks Easier to Work With

Making Workbooks Easier to Work With

An important component of making workbooks easy to work with is to give users an idea of where to find the data they’re looking for. Excel provides several ways to set up signposts directing users toward the data they want. The first method, discussed in Chapter 1, “Getting to Know Excel,” is to give each workbook a descriptive name. Once users have opened the proper workbook, you can guide them to a specific worksheet by giving each worksheet a name; the names are displayed on the sheet tabs in the lower left corner of the workbook window. To change a worksheet’s name, you right-click the sheet tab of the worksheet you want and, from the shortcut menu that appears, choose Rename. Choosing Rename opens the worksheet name for editing. You can also change the order of worksheets in a workbook by dragging the sheet tab of a worksheet to the desired position on the navigation bar, bringing the most popular worksheets to the front of the list.


If you need more than three worksheets in most of the workbooks you create, you can change the default number of worksheets in your new workbooks. To change the default number of worksheets, on the Tools menu, click Options. In the Options dialog box, click the General tab, and, in the Sheets In New Workbook box, type the number of worksheets you want in your new workbooks, and click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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