Excel 2019 Bible

51

C H A P T E R

3

Performing Basic Worksheet

Operations

IN THIS CHAPTER

Understanding Excel worksheet basics

Controlling your views

Manipulating the rows and columns

T

his 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 to

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 binder and worksheets as pages in the

binder. As with a binder, you can view a particular sheet, add new sheets, remove sheets, rearrange

sheets, and copy sheets.

A workbook can hold any number of sheets, and these sheets can be either worksheets (sheets con-

sisting 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.

The following sections describe the operations that you can perform with windows and worksheets.

Working with Excel windows

Each Excel workbook file that you open is displayed in a window. A window is the operating sys-

tem’s container for that workbook. You can open as many Excel workbooks as necessary at the same

time.

Excel® 2019 Bible, First Edition. Michael Alexander, Dick Kusleika and John Walkenbach.
© 2019 John Wiley & Sons, Inc. Published 2019 by John Wiley & Sons, Inc.