Chapter 1: Building Worksheets

In This Chapter

arrow.png Creating a spreadsheet from a template

arrow.png Designing a spreadsheet from scratch

arrow.png Understanding the different types of cell entries

arrow.png Knowing the different ways of entering data in the worksheet

arrow.png Using Data Validation to restrict the data entries in cells

arrow.png Saving worksheets

Before you can begin building a new spreadsheet in Excel, you must have the design in mind. As it turns out, the design aspect of the creative process is often the easiest part because you can borrow the design from other workbooks that you’ve already created or from special workbook files, called templates, which provide you with the new spreadsheet’s form along with some of the standard, or boilerplate, data entries.

After you’ve settled upon the design of your new spreadsheet, you’re ready to begin entering its data. In doing the data entry in a new worksheet, you have several ...

Get Excel 2013 All-in-One For Dummies 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.