Ch 3: Worksheets & Workbooks in Excel

About This Chapter

This chapter will teach you how to layout and customize your Excel worksheets and workbooks. Learn to format your workspace and create worksheets that are easy to read and update.

Worksheets & Workbooks in Excel: Chapter Summary

Our experienced Excel instructors will teach you how to format worksheets and workbooks making data easier to read, manipulate and update. Add columns and rows and control the alignment of your cells. Learn how to view multiple parts of large worksheets on one screen. Enhance the layout of your worksheets with headers and footers or add connectivity to your Excel projects with hyperlinks.

Screenshots, graphics and engaging videos can help you understand and implement the strategies in this chapter on worksheets and workbooks. If you have any questions, our Excel experts are standing by to help. Check your progress by taking the short, multiple-choice quiz as you complete each lesson. By the end of the chapter, you will have reviewed:

  • Modifying the worksheet tab and page setup
  • Inserting, deleting and sizing columns and rows
  • Adjusting cell alignment and text wrapping
  • Controlling what you see by hiding elements, freezing panes and splitting windows
  • Workbook themes
  • Customizing your worksheets with headers, footers, watermarks and hyperlinks

(Note: All demonstrations in this chapter will be using Microsoft Excel 2013. Certain features, tools, or displays may be different in other versions.)

Excel is a registered trademark of the Microsoft Corporation, which is not affiliated with Study.com.

10 Lessons in Chapter 3: Worksheets & Workbooks in Excel
Test your knowledge with a 30-question chapter practice test
How to Modify the Worksheet Tab in Excel

1. How to Modify the Worksheet Tab in Excel

Excel workbooks can have several pages or worksheets. Each page is identified using a worksheet tab. This lesson will review how to add and remove worksheets, how to rename worksheets and how to change the color of the tab fill.

Modifying Page Setup Properties in Excel

2. Modifying Page Setup Properties in Excel

When you need to change the orientation, modify the page size, adjust margins or add title rows to printed pages, the Page Setup grouping of commands is the place to get it done. This lesson will guide you through modifying your page setup options.

How to Insert & Delete Columns & Rows in Excel

3. How to Insert & Delete Columns & Rows in Excel

The next time your create a spreadsheet, you will undoubtedly find yourself in need of being able to insert and delete rows and/or columns. This lesson will detail the steps to adding and removing rows and columns in Excel.

Wrapping Text in Excel: How to Wrap Text within Cells

4. Wrapping Text in Excel: How to Wrap Text within Cells

What if you could convert a long line of text entered on a spreadsheet to multiple lines? It would fit better for printing and be easier to read. This lesson will guide you through formatting cells to accommodate wrapped text.

How to Modify Cell Alignment & Indentation in Excel

5. How to Modify Cell Alignment & Indentation in Excel

Cell alignment is a key feature when giving your spreadsheet a more organized and consistent look. This lesson will review the six different alignment short-cut commands and explain how to align numbers and text within a cell.

Workbook Themes: Applying & Changing Themes in Excel

6. Workbook Themes: Applying & Changing Themes in Excel

Themes in MS Excel are a collection of colors, fonts and effects designed to provide consistency throughout your workbook. This lesson will discuss how to apply themes to your MS Excel documents.

Adjusting Column Width & Row Height in Excel

7. Adjusting Column Width & Row Height in Excel

From time to time, you may need to adjust the column width or row height of an Excel spreadsheet. This lesson will demonstrate different ways to make these adjustments.

How to Insert Watermarks in Your Excel Worksheet

8. How to Insert Watermarks in Your Excel Worksheet

Although Excel does not have a feature to automatically add watermarks, similar to Microsoft Word, there is a way to mimic a watermark on a worksheet. This lesson will demonstrate two ways to add a watermark to an Excel spreadsheet.

How to Insert Headers & Footers in Excel

9. How to Insert Headers & Footers in Excel

Excel has a feature that allows you to add header and footer information that displays on your printed Excel document. Headers and footers help make the document a bit more professional and easier to read.

Using Data Validation in Excel

10. Using Data Validation in Excel

Have you ever wanted to restrict what type of data is entered into an Excel spreadsheet as well as how it's entered? Excel's data validation feature can help you do just that. This lesson will explain data validation and demonstrate how to set limitations on data entered on Excel worksheets.

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Other Chapters

Other chapters within the Microsoft Excel Certification: Practice & Study Guide course

Support