Office 2013 Elaine Marmel Teach Yourself VISUALLY™ Office 2013 LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONS OR WARRANTIES WITH RESPECT Published by TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK John Wiley & Sons, Inc. AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT 10475 Crosspoint Boulevard LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO Indianapolis, IN 46256 WARRANTY MAY BE CREATED OR EXTENDED BY SALES OR PROMOTIONAL www.wiley.com MATERIALS. THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY Published simultaneously in Canada NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN Copyright © 2013 by John Wiley & Sons, Inc., Indianapolis, Indiana RENDERING LEGAL, ACCOUNTING, OR OTHER PROFESSIONAL SERVICES. IF No part of this publication may be reproduced, stored in a retrieval PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A COMPETENT system or transmitted in any form or by any means, electronic, mechani- PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER cal, photocopying, recording, scanning or otherwise, except as permit- NOR THE AUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. ted under Sections 107 or 108 of the 1976 United States Copyright THE FACT THAT AN ORGANIZATION OR WEBSITE IS REFERRED TO IN Act, without either the prior written permission of the Publisher, or THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER authorization through payment of the appropriate per-copy fee to the INFORMATION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE MAY 978-750-8400, fax 978-646-8600. Requests to the Publisher for permis- PROVIDE OR RECOMMENDATIONS IT MAY MAKE. FURTHER, READERS sion should be addressed to the Permissions Department, John Wiley SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK & Sons, Inc., 111 River Street, Hoboken, NJ 07030, 201-748-6011, fax MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS 201-748-6008, or online at www.wiley.com/go/permissions. WRITTEN AND WHEN IT IS READ. Wiley publishes in a variety of print and electronic formats and by print- FOR PURPOSES OF ILLUSTRATING THE CONCEPTS AND TECHNIQUES on-demand. Some material included with standard print versions of this DESCRIBED IN THIS BOOK, THE AUTHOR HAS CREATED VARIOUS NAMES, book may not be included in e-books or in print-on-demand. If this book COMPANY NAMES, MAILING, E-MAIL AND INTERNET ADDRESSES, PHONE refers to media such as a CD or DVD that is not included in the version you AND FAX NUMBERS AND SIMILAR INFORMATION, ALL OF WHICH ARE purchased, you may download this material at http://booksupport.wiley. FICTITIOUS. ANY RESEMBLANCE OF THESE FICTITIOUS NAMES, ADDRESSES, com. For more information about Wiley products, visit www.wiley.com. PHONE AND FAX NUMBERS AND SIMILAR INFORMATION TO ANY ACTUAL PERSON, COMPANY AND/OR ORGANIZATION IS UNINTENTIONAL AND Library of Congress Control Number: 2012956423 PURELY COINCIDENTAL. ISBN: 978-1-118-51768-0 Manufactured in the United States of America Contact Us 10 9 8 7 6 5 4 3 2 1 For general information on our other products and services please con- tact our Customer Care Department within the U.S. at 877-762-2974, Trademark Acknowledgments outside the U.S. at 317-572-3993 or fax 317-572-4002. Wiley, the Wiley logo, Visual, the Visual logo, Teach Yourself VISUALLY, For technical support please visit www.wiley.com/techsupport. Read Less - Learn More and related trade dress are trademarks or reg- istered trademarks of John Wiley & Sons, Inc. and/or its affiliates. Microsoft is a registered trademark of Microsoft Corporation. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book. Sales | Contact Wiley at (877) 762-2974 or fax (317) 572-4002. Credits Executive Editor Project Coordinator Jody Lefevere Sheree Montgomery Sr. Project Editor Graphics and Production Specialists Sarah Hellert Noah Hart Joyce Haughey Technical Editor Jennifer Henry Vince Averello Andrea Hornberger Jennifer Mayberry Copy Editor Marylouise Wiack Quality Control Technician Lauren Mandelbaum Editorial Director Robyn Siesky Proofreader Broccoli Information Mgt. Business Manager Amy Knies Indexer Potomac Indexing, LLC Sr. Marketing Manager Sandy Smith Vice President and Executive Group Publisher Richard Swadley Vice President and Executive Publisher Barry Pruett About the Author Elaine Marmel is President of Marmel Enterprises, LLC, an organization that specializes in technical writing and software training. Elaine has an MBA from Cornell University and worked on projects to build financial management systems for New York City and Washington, D.C. This prior experience provided the foundation for Marmel Enterprises, LLC to help small businesses manage the project of implementing a computerized accounting system. Elaine spends most of her time writing; she has authored and co-authored more than 65 books about Microsoft Excel, Microsoft Word, Microsoft Project, QuickBooks, Peachtree, Quicken for Windows, Quicken for DOS, Microsoft Word for the Mac, Microsoft Windows, 1-2-3 for Windows, and Lotus Notes. From 1994 to 2006, she also was the contributing editor to monthly publications Inside Peachtree, Inside Timeslips, and Inside QuickBooks. Elaine left her native Chicago for the warmer climes of Arizona (by way of Cincinnati, OH; Jerusalem, Israel; Ithaca, NY; Washington, D.C., and Tampa, FL) where she basks in the sun with her PC, her cross stitch projects, and her dog, Jack. Author’s Acknowledgments Because a book is not just the work of the author, I’d like to acknowledge and thank all the folks who made this book possible. Thanks to Jody Lefevere for the opportunity to write this book. Thank you, Vince Averello, for doing a great job to make sure that I “told no lies.” Thank you, Marylouise Wiack, for making sure I was understandable. And, thank you, Sarah Hellert; your top-notch management of all the players and manuscript elements involved in this book made my life easy and writing the book a pleasure. Dedication To Buddy (1995-2012), my constant companion for 17 ½ years. You brought me nothing but joy and I will sorely miss you. How to Use This Book Who This Book Is For 3 Icons and Buttons This book is for the reader who has never used this Icons and buttons show you exactly what you need to particular technology or software application. It is click to perform a step. also for readers who want to expand their knowledge. 4 Tips The Conventions in This Book Tips offer additional information, including warnings and shortcuts. 1 Steps 5 Bold This book uses a step-by-step format to guide you Bold type shows command names or options that you easily through each task. Numbered steps are actions must click or text or numbers you must type. you must do; bulleted steps clarify a point, step, or optional feature; and indented steps give you the 6 Italics result. Italic type introduces and defines a new term. 2 Notes Notes give additional information — special conditions that may occur during an operation, a situation that you want to avoid, or a cross-reference to a related area of the book. OFFICE FEATURES CH2APTER Arrange Windows Working with Files You can simultaneously view multiple files. For example, you might view two versions of a Word C You can click the Maximize 5 document side by side to compare their contents or view two Excel workbooks to compare data. If button ( ) to restore a the files you want to compare are particularly long, you can enable the Synchronous Scrolling option window to its full size. to scroll both files at the same time. D Ybouutt ocann ( clic)k t oth cel oCsleo3 sae f ile. In addition to viewing multiple files simultaneously, you can split the window of one long file into scrollable panes to view different portions of it. For example, you might split a document to compare how portions of it are formatted. Arrange Windows View Multiple Files 1 Open two or more files. 1 2 Click the View tab. 3 Click the View Side by Side button. Split a Window 1 To split the window displaying a single file into scrollable panes, click the View tab. 2 Click the Split button. E Horizontal and vertical bars appear. 3 Drag the bar up, down, right, or left to resize the panes, and click to set the bar in place when the panes are the A Both files appear on-screen desired size. side by side. To return the page to a full document, B To scroll both files at the click the Split button again. same time, click the Window Sbyunttcohnr oannodu tsh Sencr ocllilcikn gt he TIPS button. What does the Switch Windows Can I display two Excel files one on top of the other? button do? Yes. Click the View tab and then click the Arrange All ISfw yiotcuh h Wavien dtwowo so br umttooren ftiole vsi eowpe an ,l icslti cokf tahlle byouutt ocann. Tsheele Actr rhaonwge y Wouin wdoanwts tdoi adliosgp lbaoyx m oupletinpsl,e afnilde s: 4 open files in the current Office program. You horizontally, vertically, tiled (where each window appears can then choose a file in the list to view it. in a square pane), or cascaded (where windows appear one behind another). Table of Contents Part I Office Features Chapter 1 Office Basics Start and Exit Office Applications ...............................4 Navigate the Program Windows ..................................6 Work with Backstage View .........................................7 Work with the Ribbon ...............................................8 Customize the Quick Access Toolbar .......................... 10 Using an Office Program on a Tablet PC ..................... 12 Chapter 2 Working with Files Create a New File ................................................... 14 Save a File ............................................................ 16 Open a File ........................................................... 18 Print a File ............................................................ 20 Check Your File for Hidden or Personal Data................ 22 E-Mail a File .......................................................... 24 Select Data ........................................................... 26 Cut, Copy, and Paste Data ........................................ 28 Arrange Windows ................................................... 30 Chapter 3 Office Graphics Tools Insert a Picture ..................................................... 32 Insert an Online Picture .......................................... 34 Resize and Move Graphic Objects .............................. 36 Understanding Graphic Object Modification Techniques ....38 Chapter 4 Working with Office Files Online Office and the Cloud ............................................... 40 Sign In to Office Online .......................................... 42 Share a Document from Office .................................. 44 Download Apps from the Office Store ........................ 46 Sign In to SkyDrive ................................................ 50 Using a Web App in SkyDrive ................................... 52 Using an Office Program from SkyDrive ...................... 54 Upload a Document to SkyDrive ................................ 56 Share a Document Using SkyDrive ............................. 58 Part II Word Chapter 5 Adding Text Change Word’s Views ............................................... 62 Type and Edit Text .................................................. 64 Insert Quick Parts .................................................. 66 Insert Symbols ...................................................... 68 Create a Blog Post .................................................. 70 Table of Contents Chapter 6 Formatting Text Change the Font, Size, and Color .............................. 72 Align Text ............................................................. 76 Set Line Spacing .................................................... 77 Indent Text ........................................................... 78 Set Tabs ............................................................... 80 Set Margins ........................................................... 82 Create Lists ........................................................... 84 Copy Formatting .................................................... 86 Clear Formatting .................................................... 87 Format with Styles ................................................. 88 Apply a Template ................................................... 90 Chapter 7 Adding Extra Touches Insert an Online Video ............................................ 92 Assign a Theme ..................................................... 94 Add Borders .......................................................... 96 Create Columns ...................................................... 98 Insert a Table .......................................................100 Apply Table Styles .................................................102 Insert an Excel Spreadsheet ....................................103 Add Headers and Footers ........................................104 Insert Footnotes and Endnotes ................................106 Insert Page Numbers and Page Breaks ......................108 Mark Index Entries ................................................110 Generate an Index .................................................112 Generate a Table of Contents ..................................114 Create a Bibliography ............................................116