Managing Worksheets
Chapter 1 — Subject Title
Short description explaining what the learner will understand after completing this study map.
Worksheet Management Fundamentals
Learn how to organise worksheets and control rows, columns and the worksheet view so that Excel workbooks remain clear and easy to use.
By the end of this module, you should be able to insert, delete, rename, move, copy, colour, hide and unhide worksheets; manage rows and columns; and use Freeze Panes effectively.
Essential Worksheet Terms
Review the key terms used when organising worksheets and adjusting the worksheet structure.
Worksheet Organisation Tools
Explore the main worksheet-management tasks used to keep a workbook organised and practical.
Move vs Copy Worksheets
Moving and copying may look similar, but they produce different results in a workbook.
Move a Worksheet
Changes the position of an existing worksheet. The original sheet is relocated rather than duplicated.
Copy a Worksheet
Creates a duplicate of an existing worksheet while keeping the original sheet in place.
Organising a Workbook
Use a simple sequence to organise workbook sheets before entering or analysing larger amounts of data.
Managing Rows, Columns & Views
Expand each topic to review practical worksheet-management techniques.
Worksheet Practice Explorer
Use the tabs to review common worksheet-management actions and when to use them.
Key Takeaways
Review the most important worksheet-management skills before completing the knowledge check.
Worksheet tabs help organise the pages in a workbook. Rename and arrange them clearly so users can quickly understand the workbook structure.
Before deleting a worksheet, confirm that its data is no longer required. Use hiding when information should remain in the workbook but does not need to be displayed.
Knowledge Check
Check your understanding of worksheet organisation, rows and columns, and Freeze Panes.