Chapter 1
Building Worksheets
IN THIS CHAPTER
Creating a workbook from a template
Designing a worksheet 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
Linking your worksheet to other Excel workbooks, Office documents, and web pages
Saving worksheets
Before you start building a new worksheet in Excel, it helps to have an overall design in mind. Fortunately, the design aspect of worksheet-building is often the easiest part because you can borrow the design either from another workbook you’ve created or from a special workbook file — called a template — that provides you with the new worksheet’s structure along with some predefined text and data.
After ...
Get Excel 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.
