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

Chapter 2. Entering and Saving Worksheet Data > Controlling the Worksheet View

Controlling the Worksheet View

Control means having things the way you want them. Controlling Excel means having the power to manipulate what you see on the worksheet. You can switch between open workbook windows to tile or cascade the open windows; you can freeze a row of column headings onscreen for simplified data entry, or even hide a column or row of confidential information (so that it's not visible onscreen). Figure 2.29 shows a project status report with frozen column headings and a hidden column. The following sections describe the techniques for freezing and hiding columns and rows, as well as how to split the window into multiple panes to focus in on multiple sections of the worksheet simultaneously.

Figure 2.29. Make data entry easier and maintain confidentiality by controlling your worksheet view.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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