Chapter 3: Essential Worksheet Operations
In This Chapter
Understanding Excel worksheet essentials
Controlling your views
Manipulating the rows and columns
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.
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 can open as many Excel workbooks as necessary at the same time.
In previous versions of Excel, you could open multiple workbooks and have them displayed in a single Excel window. With Excel 2013, you no longer have that option. An Excel 2013 window holds only one workbook. If you create or open a second workbook, it appears ...