Home / MS-Excel / General Formatting

Refining Excel Worksheet

This tutorial explains how to edit worksheet data and move quickly here and there in a worksheet. You also discover a couple of techniques for entering data quickly, how to select cells, and how to copy and move data in cells. This tutorial describes how to move, delete, and rename worksheets, as well as protect them from being edited or altered.

Following these sections:

  • Editing Worksheet Data
  • Moving Around in a Worksheet
  • Better Look at the Worksheet
  • Freezing and splitting columns and rows
  • Your own customized views
  • Hiding columns and rows
  • Comments for Documenting Your Worksheet
  • Selecting Cells in a Worksheet
  • Deleting, Copying, and Moving Data
  • Handling the Worksheets in a Workbook
  • Tampering with Worksheets
  • Hiding a worksheet and Protecting a worksheet

In this tutorial:

  1. Editing Worksheet Data
  2. Moving Around in a Worksheet
  3. Better Look at the Worksheet
  4. Freezing and splitting columns and rows
  5. Your own customized views
  6. Hiding columns and rows
  7. Comments for Documenting Your Worksheet
  8. Selecting Cells in a Worksheet
  9. Deleting, Copying, and Moving Data
  10. Handling the Worksheets in a Workbook
  11. Tampering with Worksheets
  12. Hiding a worksheet
  13. Protecting a worksheet