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 3: Formatting a Worksheet

ex03.psd

In this lesson, you will learn how to format a worksheet in Excel. You will change the format of numeric entries, apply fonts, change font sizes, align text within cells, and across multiple columns. You’ll learn how to use the Format Painter and Cell Styles to apply styles to multiple ranges. Finally, you’ll learn how to use color-coordinated themes in your worksheets.

What you’ll learn in this lesson:

  • Formatting numeric entries
  • Changing the font and font size
  • Adding borders and shading
  • Applying conditional formatting
  • Changing row and column sizes

Starting up

You will work with files from the Excel03lessons 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.

Understanding cell formats

Before we talk about cell formatting, you must understand how Excel treats data. Excel categorizes data into three different types: numbers, text, and dates or times. Numbers, or values, consist of numeric data that will be used in calculations or formulas. There are also numbers on which you would never perform calculations, such as zip codes, social security numbers, product codes, or phone numbers.

Text also appears to be a straightforward concept. Text includes ...

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