Introduction

Creating a Microsoft Excel workbook is as easy as entering data in the cells of an Excel worksheet. Each cell has a cell address which is made up of its column and row intersection. Cells on a worksheet contain either labels or values, a formula or remain blank. Cell entries can be modified using the keyboard or mouse. You can select cells in ranges that are contiguous (selected cells are adjacent to each other) or noncontiguous (selected cells are in different parts of the worksheet). Selected cells are used in formulas, to copy and paste data, to AutoFill, to apply date and time and other formatting functions.

In addition, Excel offers a Find and Replace feature that allows you to look for labels and values and make changes as ...

Get Excel® 2013 On Demand 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.