[ Pobierz całość w formacie PDF ]
.You can scroll to only the columns in the upper right pane and only the rows in the lower leftpane.You can scroll to the lower right pane in either direction.Inside OutMake frozen panes easier to seeGenerally speaking, all the things you do with panes work better when the windows are fro-zen.Unfortunately, it s harder to tell that the window is split when the panes are frozenbecause the thin frozen pane lines look just like cell borders.To make frozen panes easierto see, you can use a formatting clue that you will always recognize.For example, select allthe heading rows and columns and fill them with a particular color such as ice blue&124Part 2: Building WorksheetsChapter 5 Part 1: Part TitleHow to Work a WorksheetZooming WorksheetsAs mentioned previously, you can use the Zoom box on the Standard toolbar or choose View,Zoom to change the size of your worksheet display.The Zoom dialog box has one enlarge-ment option, three reduction options, and a Fit Selection option that determines the neces-sary reduction or enlargement needed to display the currently selected cells.Use the Custombox to specify any zoom percentage from 10 through 400 percent.Tip Zoom multiple worksheetsThe Zoom command affects all selected sheets; therefore, if you group several sheets,Excel will display all of them at the selected Zoom percentage.For more about groupingsheets, see Editing Multiple Worksheets on page 183.For example, to view the entire worksheet shown in Figure 5-16, you can try different zoompercentages until you get the results you want.Better still, select the entire active area of theworksheet, and select the Fit Selection option in the Zoom dialog box.Now the entire work-sheet is displayed on the screen, as shown in Figure 5-19.Of course, reading the numbers might be a problem at this size, but you can select otherreduction or enlargement sizes for that purpose.While your worksheet is zoomed, youcan still select cells, format them, and enter formulas as you normally would.The Zoomoption that is in effect when you save the worksheet is the displayed setting when youreopen the worksheet.f05ie19Figure 5-19.After using the Fit Selection option with the active area selected, open theZoom dialog box to see the chosen percentage in the Custom box.125Part 2: Building WorksheetsChapter 5 Microsoft Office Excel 2003 Inside OutIf You Have a Wheel MouseThe scroll wheel on a Microsoft IntelliMouse (and other brands of wheel mice ) normallyscrolls the worksheet.You can also use the wheel to zoom.Simply hold down the Ctrl keyand turn the wheel backward (toward your hand) to zoom out, or turn the wheel forward(away from your hand) to zoom in.If you want, you can make zooming the default behaviorof the wheel, making it unnecessary to press the Ctrl key.To do so, choose Tools, Options,click the General tab, and select Zoom On Roll With IntelliMouse.Using Custom ViewsSuppose you want your sheet to have particular display and print settings for one purpose,such as editing, but different display and print settings for another purpose, such as anon-screen presentation.By choosing View, Custom Views, you can assign names to specificview settings, which include column widths, row heights, display options, window size, posi-tion on the screen, pane settings, the cells that are selected at the time the view is created, and,optionally, the print and filter settings.You can then select your saved view settings wheneveryou need them, rather than manually changing the settings each time.Tip Create a normal custom view firstBefore you modify your view settings for a particular purpose, you should save the currentview as a custom view, named Normal.This provides you with an easy way to return to theregular, unmodified view.Otherwise, you would have to retrace all your steps to return allthe view settings to normal.In the Custom Views dialog box, the Views list is empty until you click Add to save a customview.Figure 5-20 shows the Custom Views dialog box with two views added, as well as theAdd View dialog box that we used to add them.f05ie20Figure 5-20.Click Add to name the current view and print settings in the Custom Viewsdialog box.126Part 2: Building WorksheetsChapter 5 Part 1: Part TitleHow to Work a WorksheetTip Use a better Custom Views optionCustom Views is a useful feature that you can make even more useful by performing a bitof user interface (UI) surgery.You can add a Custom Views drop-down list to any toolbar ormenu.If you plan to use this feature often, add the button to a toolbar.If you want to makethe menu command more useful, replace the existing Custom Views with the one thatincludes the drop-down list.To make this change, choose View, Toolbars, Customize, andclick the View category on the Commands tab.Then choose the View menu and drag theCustom Views command off the menu.Finally, drag the Custom Views command from theCustomize dialog box to the View menu.Protecting WorksheetsIn addition to password protection for your files, Excel offers several features that allow youto protect your work workbooks, workbook structures, individual cells, graphic objects,charts, scenarios, windows, and more from access or modification by others.You can alsochoose to allow specific editing actions on protected sheets.By default, Excel locks (protects) all cells and charts, but the protection is disabled untilyou choose Tools, Protection, Protect Sheet to access the Protect Sheet dialog box, shown inFigure 5-21.The protection status you specify applies to the current worksheet only.After protection is enabled, you cannot change a locked item.If you try to change a lockeditem, Excel displays an error message.As you can see in the figure, the Allow All Users Of ThisWorksheet To list contains a list of specific editorial actions to occur even on protected sheets.In addition to the options visible in Figure 5-21, you can also allow users to sort, use Auto-Filter and PivotTable reports, and edit objects or scenarios.f05ie21Figure 5-21.The Protect Sheet dialog box gives you pinpoint control over many commonediting actions.127Part 2: Building WorksheetsChapter 5 Microsoft Office Excel 2003 Inside OutUnlocking Individual CellsIf you choose the Protect Sheet command without specifically unlocking individual cells,every cell in the worksheet is locked by default.Most of the time, however, you will not wantto lock every cell.For example, you might want to protect the formulas and formatting butleave particular cells unlocked so that necessary data can be entered without unlocking theentire sheet.Before you protect a worksheet, select the cells you want to keep unlocked,choose Format, Cells, click the Protection tab, and then clear the Locked check box, as shownin Figure 5-22.For information about using Tools, Protection, Protect and Share Workbook, see Sharing Workbooks ona Network on page 522.f05ie22Figure 5-22.Use the Protection tab in the Format Cells dialog box to unlock specific cellsfor editing
[ Pobierz całość w formacie PDF ]