Microsoft Office Tutorials and References
In Depth Information
Chapter 14: Essential Worksheet and Cell Range Operations
Essential Worksheet and Cell
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’fill discover tips and techniques to help you take control of your worksheets and help
you work more efﬁ ciently. 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’fill also
learn in this chapter.
Learning the Fundamentals of Excel Worksheets
In Excel, each ﬁ le is called a workbook, and each workbook can contain one or more worksheets. You
may ﬁ nd 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.