Explanation

Excel allows worksheets and workbook windows to be hidden or displayed when required.

Key Concepts

  • Hide Worksheet
  • Unhide Worksheet
  • Hide Window
  • Unhide Window
  • View Side by Side
  • Synchronous Scrolling

Example

Use View Side by Side to compare two worksheets or workbook windows.

Practice

Open two reports and:

  1. View them side by side.
  2. Compare the data.
  3. Use Synchronous Scrolling.
  4. Hide a worksheet.
  5. Unhide it.
PreviousNext