Excel 2016 All-in-One For Dummies

Chapter 1

Building Worksheets

In This Chapter

Creating a spreadsheet from a template

Designing a spreadsheet from scratch

Understanding the different types of cell entries

Knowing the different ways of entering data in the worksheet

Using Data Validation to restrict the data entries in cells

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