Office 2013 Bible: The Comprehensive Tutorial Resource

Chapter 14

Essential Worksheet and Cell Range Operations

IN THIS CHAPTER

Understanding Excel worksheet essentials

Controlling your views

Manipulating rows and columns

Understanding Excel cells and ranges

Selecting cells and ranges

Copying or moving ranges

Using names to work with ranges

Adding comments to cells

This chapter covers some basic information regarding workbooks, worksheets, and windows. You’ll discover tips and techniques to help you take control of your worksheets and help you work more efficiently. Most of the work you do in Excel involves cells and ranges. Understanding how best to manipulate cells and ranges will save you time and effort, as you’ll also learn in this chapter.

Learning the Fundamentals of Excel Worksheets

In Excel, each file is called a workbook, and each workbook can contain one or more worksheets. You may find it helpful to think of an Excel workbook as a notebook and worksheets as pages in the notebook. As with a notebook, you can view a particular sheet, add new sheets, remove sheets, rearrange sheets, and copy sheets. The following sections describe the operations that you can perform with worksheets.

Working with Excel windows

Each Excel workbook file that you open is displayed in a window. A workbook can hold any number of sheets, and these sheets can be either worksheets (sheets consisting of rows and columns) or chart sheets (sheets that hold a single chart). A worksheet is what people usually think of when they think of a spreadsheet. You ...