O'Reilly logo

Excel 2013 All-in-One For Dummies by Greg Harvey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required