Skip to Main Content
Office 2013 Digital Classroom
book

Office 2013 Digital Classroom

by Walter Holland, AGI Creative Team
August 2013
Beginner content levelBeginner
672 pages
14h 31m
English
Wiley
Content preview from Office 2013 Digital Classroom

Excel Lesson 7: Working with Excel 2013 Templates

ex07.psd

In this lesson, you will learn how to work with and save worksheet templates. In addition, you will learn how to create your own templates, protect cells and worksheets, and assign password protection to workbook files.

What you’ll learn in this lesson:

  • Opening a worksheet template
  • Saving a worksheet as a template
  • Protecting workbooks and worksheets
  • Assigning password protection to files
  • Hiding formulas and other cells from view

Starting up

You will work with files from the Excel07lessons folder. Make sure that you have loaded the OfficeLessons folder onto your hard drive from www.digitalclassroombooks.com/Office2013. If you need further instructions, see “Loading lesson files” in the Starting up section of this book.

Excel templates

A template is a worksheet that contains formatting, data, and other standard worksheet elements saved as a boilerplate. Excel offers a set of professionally-designed worksheet templates that you can use over and over again. Among the default templates offered by Excel are calendars, budgets, sales reports, and financial statements.

You can also search through the thousands of templates available from Office.com. When you use the Search tool, Excel displays a long list of categories from which to choose.

The Backstage view displays a number of predesigned templates when you choose the ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Word 2007 Step by Step

Microsoft® Office Word 2007 Step by Step

Joyce Cox and Joan Lambert
Microsoft® Office 2013 QuickSteps, 3rd Edition

Microsoft® Office 2013 QuickSteps, 3rd Edition

Carole Matthews, Marty Matthews, Bobbi Sandberg

Publisher Resources

ISBN: 9781118571613Purchase bookOther