Chapter 4. Working with Worksheets

Working with Worksheets

Worksheets are where all the action takes place in Excel. You use worksheets to enter and edit data, perform calculations, and more. This chapter shows you how to navigate around your worksheets and perform various tasks with the sheets.

Understanding Worksheet Structure

Data you type into Excel is entered into worksheets, also called sheets. Whether you use a single worksheet or a large collection of sheets, every worksheet is structured in the same way. Before you begin entering text and numbers into your worksheets, it helps to understand how Excel worksheets come together.

Columns and Rows

Worksheets are formatted ...

Get Teach Yourself VISUALLY™: Excel® 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.