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

Chapter 1. Getting Around Excel > Controlling Your Worksheet View

Controlling Your Worksheet View

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 nor when printed). Figure 1.24 shows a table with frozen column headings and hidden columns. 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 1.24. Make data entry easier by freezing column headings while you scroll your list.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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