Microsoft Office Tutorials and References
In Depth Information
• Clear Contents: Leaves the formatting in the cell but deletes the
• Clear Comments: Leaves data and formatting but deletes any
comments added to the cell
• Clear Hyperlinks: Leaves data and formatting but deletes any
hyperlinks connecting one cell to another cell
After you create a spreadsheet, you can print it out for others to see. When
printing spreadsheets, you need to take special care how your spreadsheet
appears on a page because a large spreadsheet will likely get printed on two
or more sheets of paper.
This can cause problems if an entire spreadsheet prints on a one page but a
single row of numbers appears on a second page, which can make reading
and understanding your spreadsheet data confusing. When printing
spreadsheets, take time to align your data so that it prints correctly on every page.
Using Page Layout view
Excel can display your spreadsheets in two ways: Normal view and Page
Layout view. Normal view is the default appearance, which simply fills your
screen with rows and columns so you can see as much of your spreadsheet
Page Layout view displays your spreadsheet exactly as it will appear if you
print it. Not only can you see where your page breaks occur, but you can also
add any headers to the top of your spreadsheet.
To switch back and forth from Normal view to Page Layout view, follow these
1. Click the View tab.
2. Click the Normal or Page Layout View icon in the Workbook Views
group, as shown in Figure 8-20.
You can also click the Normal or Page Layout View icons in the bottom-right
corner of the Excel window.