Office 2021 All-in-One For Dummies

by Weverka, Peter

• ISBN13: 9781119831419
• ISBN10: 1119831415
• Edition: 1st
• Format: Paperback
• Copyright: 2022-02-23
• Publisher: For Dummies

Summary

Say hello to Office productivity with this one-stop reference

With Office 2021 All-in-One For Dummies, you can get up and running with Microsoft's legendary software suite. This update covers all the tweaks you can find in the latest version of Word, Excel, PowerPoint, Outlook, and Teams. You'll also learn how to make these apps work harder for you, because we dig deep into the tips and features that casual Office users might not know about. This edition also offers expanded coverage of Teams and other collaborative tools, so you can nail working from home, or just get a few of those meetings out of the way without having to leave your desk.

How can you quickly give documents the same format in Word? What was that one useful Excel function, again? And how does setting up a meeting on Teams work? Office 2021 All-in-One For Dummies serves up quick and simple answers to these questions, along with hundreds of other answers you're expected to know when you work in Office.

• Learn how Microsoft Office works and get the most out of Word, Excel, PowerPoint, Outlook, and Teams
• Make amazing charts and graphs that you can plug into your documents, spreadsheets, and presentations
• Get better at working collaboratively with file sharing options and other neat features
• Do more, faster with expert tips and guidance on the full suite of Office software for 2021

Whether you're new to Office or just need a refresher for the newest updates, the nine mini-books inside are your keys to getting stuff done.

Author Biography

Peter Weverka is a long-time For Dummies technology author who’s written some of the series’ top-selling titles, including Office 365 All-in-One For Dummies.

Table of Contents

Introduction 1

What Makes This Book Different 2

Foolish Assumptions 3

Conventions Used in This Book 3

Icons Used in This Book 4

Beyond the Book 4

Book 1: Common Microsoft Office Tasks 5

Chapter 1: Office Nuts and Bolts 7

Introducing Office 2021 7

Office 2021 applications 7

Other goodies 8

Finding out what software and Office version you have 9

Finding Your Way Around the Office Interface 10

The File tab and Backstage 10

The Quick Access toolbar 12

The Ribbon and its tabs 12

Context-sensitive tabs 13

The anatomy of a tab 13

Mini-toolbars and shortcut menus 15

Office 2021 for keyboard lovers 16

Saving Your Files 17

Saving a file 17

Saving a file for the first time 18

Saving AutoRecovery information 18

Navigating the Save As and Open Windows 18

Opening and Closing Files 20

Opening a file 20

Closing a file 21

Reading and Recording File Properties 21

Locking a File with a Password 22

Password-protecting a file 22

Removing a password from a file 23

Trusting (or not Trusting) Microsoft with Your “Content” 24

Chapter 2: Wrestling with the Text 27

Manipulating the Text 27

Selecting text 28

Moving and copying text 28

Taking advantage of the Clipboard task pane 29

Deleting text 30

Speaking, not Typing, the Words 30

Changing the Look of Text 31

Choosing fonts for text 32

Changing the font size of text 34

Applying font styles to text 35

Applying text effects to text 36

Underlining text 37

Changing the color of text 38

Quick Ways to Handle Case, or Capitalization 39

Entering Symbols and Foreign Characters 40

Creating Hyperlinks 42

Linking a hyperlink to a web page 42

Creating a hyperlink to another place in your file 43

Creating an email hyperlink 44

Repairing and removing hyperlinks 45

Chapter 3: Speed Techniques Worth Knowing About 47

Undoing and Repeating Commands 47

Undoing a mistake 48

Repeating an action — and quicker this time 48

Zooming In, Zooming Out 49

Viewing a File Through More Than One Window 50

Correcting Typos on the Fly 51

Entering Text Quickly with the AutoCorrect Command 53

Book 2: Word 2021 55

Chapter 1: Speed Techniques for Using Word 57

Introducing the Word Screen 57

Creating a New Document 59

Getting a Better Look at Your Documents 61

Viewing documents in different ways 61

Splitting the screen 65

Selecting Text in Speedy Ways 66

Moving Around Quickly in Documents 67

Keys for getting around quickly 67

Navigating from page to page or heading to heading 68

Going there fast with the Go To command 69

Bookmarks for hopping around 70

Inserting a Whole File into a Document 71

Getting Word to Read It 71

Entering Information Quickly in a Computerized Form 72

Creating a computerized form 73

Entering data in the form 75

Chapter 2: Laying Out Text and Pages 77

Paragraphs and Formatting 77

Inserting a Section Break for Formatting Purposes 78

Breaking a Line 81

Starting a New Page 81

Setting Up and Changing the Margins 82

Indenting Paragraphs and First Lines 84

Clicking an Indent button (for left-indents) 84

“Eyeballing” it with the ruler 84

Indenting in the Paragraph dialog box 86

Numbering the Pages 86

Numbering with page numbers only 86

Including a page number in a header or footer 87

Changing page number formats 88

Putting Headers and Footers on Pages 89

Creating, editing, and removing headers and footers 90

Fine-tuning a header or footer 92

Adjusting the Space Between Lines 93

Adjusting the Space Between Paragraphs 94

Creating Numbered and Bulleted Lists 95

Simple numbered and bulleted lists 95

Constructing lists of your own 96

Managing a multilevel list 97

Working with Tabs 98

Hyphenating Text 100

Automatically and manually hyphenating a document 101

Unhyphenating and other hyphenation tasks 101

Chapter 3: Word Styles 103

All About Styles 103

Styles and templates 104

Types of styles 104

Applying Styles to Text and Paragraphs 105

Applying a style 105

Experimenting with style sets 107

Choosing which style names appear on the Style menus 107

Creating a New Style 110

Creating a style from a paragraph 111

Creating a style from the ground up 111

Modifying a Style 113

Creating and Managing Templates 114

Creating a new template 115

Opening a template so that you can modify it 118

Modifying, deleting, and renaming styles in templates 120

Chapter 4: Constructing the Perfect Table 121

Talking Table Jargon 122

Creating a Table 122

Entering the Text and Numbers 125

Selecting Different Parts of a Table 126

Laying Out Your Table 126

Changing the size of a table, columns, and rows 126

Adjusting column and row size 127

Inserting columns and rows 128

Deleting columns and rows 129

Moving columns and rows 130

Aligning Text in Columns and Rows 131

Merging and Splitting Cells 132

Repeating Header Rows on Subsequent Pages 133

Formatting Your Table 135

Designing a table with a table style 135

Calling attention to different rows and columns 136

Decorating your table with borders and colors 137

Using Math Formulas in Tables 138

Neat Table Tricks 139

Changing the direction of header row text 140

Wrapping text around a table 140

Using a picture as the table background 141

Drawing diagonal lines on tables 143

Drawing on a table 144

Chapter 5: Taking Advantage of the Proofing Tools 145

Correcting Your Spelling Errors 146

Correcting misspellings one at a time 146

Running a spell check 147

Preventing text from being spell checked 149

Correcting Grammatical Errors 149

Finding and Replacing Text 150

The basics: Finding stray words and phrases 151

Narrowing your search 152

Conducting a find-and-replace operation 157

Finding the Right Word with the Thesaurus 158

Proofing Text Written in a Foreign Language 160

Telling Office which languages you will use 160

Marking text as foreign language text 161

Translating Foreign Language Text 162

Chapter 6: Desktop Publishing with Word 165

Experimenting with Themes 165

Sprucing Up Your Pages 166

Decorating a page with a border 167

Putting a background color on pages 168

Getting Word’s help with cover letters 168

Making Use of Charts, Diagrams, Shapes, and Photos 169

Working with the Drawing Canvas 170

Positioning and Wrapping Objects Relative to the Page and Text 171

Wrapping text around an object 172

Positioning an object on a page 174

Working with Text Boxes 175

Inserting a text box 176

Making text flow from text box to text box 176

Dropping In a Drop Cap 177

Watermarking for the Elegant Effect 178

Putting Newspaper-Style Columns in a Document 179

Doing the preliminary work 179

Running text into columns 179

Landscape Documents 181

Printing on Different Size Paper 182

Showing Online Video in a Document 182

Chapter 7: Getting Word’s Help with Office Chores 183

Highlighting Parts of a Document 183

Commenting on a Document 184

Entering comments 184

Viewing and displaying comments 185

Replying to and resolving comments 186

Caring for and feeding comments 186

Tracking Changes to Documents 187

Telling Word to start marking changes 188

Reading and reviewing a document with revision marks 188

Marking changes when you forgot to turn on revision marks 190

Accepting and rejecting changes to a document 192

Printing an Address on an Envelope 192

Printing a Single Address Label (Or a Page of the Same Label) 194

Churning Out Letters, Envelopes, and Labels for Mass Mailings 196

Preparing the source file 196

Merging the document with the source file 197

Printing form letters, envelopes, and labels 201

Chapter 8: Tools for Reports and Scholarly Papers 203

Alphabetizing a List 204

Outlines for Organizing Your Work 204

Viewing the outline in different ways 205

Rearranging document sections in Outline view 206

Collapsing and Expanding Parts of a Document 206

Generating a Table of Contents 207

Creating a TOC 208

Updating and removing a TOC 208

Customizing a TOC 208

Changing the structure of a TOC 210

Indexing a Document 212

Marking index items in the document 212

Generating the index 214

Editing an index 216

Putting Cross-References in a Document 216

Putting Footnotes and Endnotes in Documents 219

Entering a footnote or endnote 219

Choosing the numbering scheme and position of notes 220

Deleting, moving, and editing notes 221

Compiling a Bibliography 221

Inserting a citation for your bibliography 222

Editing a citation 224

Changing how citations appear in text 224

Generating the bibliography 225

Book 3: Excel 2021 227

Chapter 1: Up and Running with Excel 229

Creating a New Excel Workbook 229

Getting Acquainted with Excel 231

Rows, columns, and cell addresses 233

Workbooks and worksheets 233

Entering Data in a Worksheet 234

The basics of entering data 234

Entering text labels 235

Entering numeric values 236

Entering date and time values 236

Quickly Entering Lists and Serial Data with the AutoFill Command 240

Formatting Numbers, Dates, and Time Values 242

Establishing Data-Validation Rules 244

Chapter 2: Refining Your Worksheet 247

Editing Worksheet Data 247

Moving Around in a Worksheet 248

Getting a Better Look at the Worksheet 249

Freezing and splitting columns and rows 249

Hiding columns and rows 251

Comments for Documenting Your Worksheet 253

Selecting Cells in a Worksheet 254

Deleting, Copying, and Moving Data 255

Handling the Worksheets in a Workbook 256

Keeping Others from Tampering with Worksheets 258

Hiding a worksheet 258

Protecting a worksheet 258

Chapter 3: Formulas and Functions for Crunching Numbers 261

How Formulas Work 261

Referring to cells in formulas 262

Referring to formula results in formulas 264

Operators in formulas 264

The Basics of Entering a Formula 267

Speed Techniques for Entering Formulas 268

Clicking cells to enter cell references 268

Entering a cell range 269

Naming cell ranges so that you can use them in formulas 270

Referring to cells in different worksheets 273

Copying Formulas from Cell to Cell 273

Detecting and Correcting Errors in Formulas 275

Correcting errors one at a time 275

Running the error checker 277

Tracing cell references 277

Working with Functions 278

Using arguments in functions 279

Entering a function in a formula 280

A Look at Some Very Useful Functions 283

AVERAGE for averaging data 283

COUNT and COUNTIF for tabulating data items 284

CONCAT for combining values 286

PMT for calculating how much you can borrow 287

IF for identifying data 288

LEFT, MID, and RIGHT for cleaning up data 289

PROPER for capitalizing words 290

LARGE and SMALL for comparing values 290

NETWORKDAY and TODAY for measuring time in days 291

LEN for Counting Characters in Cells 292

Chapter 4: Making a Worksheet Easier to Read and Understand 293

Laying Out a Worksheet 293

Aligning numbers and text in columns and rows 294

Inserting and deleting rows and columns 296

Changing the size of columns and rows 297

Decorating a Worksheet with Borders and Colors 299

Cell styles for quickly formatting a worksheet 299

Formatting cells with table styles 301

Slapping borders on worksheet cells 302

Decorating worksheets with colors 303

Getting Ready to Print a Worksheet 304

Making a worksheet fit on a page 304

Making a worksheet more presentable 308

Repeating row and column headings on each page 309

Chapter 5: Advanced Techniques for Analyzing Data 311

Seeing What the Sparklines Say 311

Conditional Formats for Calling Attention to Data 313

Managing Information in Lists 314

Sorting a list 314

Filtering a list 315

Forecasting with the Goal Seek Command 317

Performing What-If Analyses with Data Tables 319

Using a one-input table for analysis 319

Using a two-input table for analysis 321

Analyzing Data with PivotTables 323

Getting a PivotTable recommendation from Excel 324

Creating a PivotTable from scratch 325

Putting the finishing touches on a PivotTable 327

Book 4: PowerPoint 2021 329

Chapter 1: Getting Started in PowerPoint 331

Getting Acquainted with PowerPoint 332

A Brief Geography Lesson 333

A Whirlwind Tour of PowerPoint 334

Creating a New Presentation 335

Advice for Building Persuasive Presentations 338

Creating New Slides for Your Presentation 340

Inserting a new slide 341

Speed techniques for inserting slides 342

Conjuring slides from Word document headings 342

Selecting a different layout for a slide 343

Getting a Better View of Your Work 344

Changing views 344

Looking at the different views 344

Hiding and Displaying the Slides Pane and Notes Pane 345

Selecting, Moving, and Deleting Slides 346

Selecting slides 346

Moving slides 347

Deleting slides 347

Putting Together a Photo Album 347

Creating your photo album 347

Putting on the final touches 350

Editing a photo album 350

Hidden Slides for All Contingencies 351

Hiding a slide 351

Showing a hidden slide during a presentation 351

Chapter 2: Fashioning a Look for Your Presentation 353

Looking at Themes and Slide Backgrounds 354

Choosing a Theme for Your Presentation 355

Creating Slide Backgrounds on Your Own 356

Using a solid (or transparent) color for the slide background 356

Creating a gradient color blend for slide backgrounds 357

Placing a picture in the slide background 359

Using a photo of your own for a slide background 360

Using a texture for a slide background 361

Changing the Background of a Single or Handful of Slides 362

Choosing the Slide Size 363

Using Master Slides and Master Styles for a Consistent Design 363

Switching to Slide Master view 364

Understanding master slides and master styles 365

Editing a master slide 366

Changing a master slide layout 366

Chapter 3: Entering the Text 367

Entering Text 367

Choosing fonts for text 368

Changing the font size of text 369

Changing the look of text 369

Fun with Text Boxes and Text Box Shapes 371

Controlling How Text Fits in Text Frames and Text Boxes 373

Choosing how AutoFit works in text frames 373

Choosing how AutoFits works in text boxes 375

Positioning Text in Frames and Text Boxes 376

Handling Bulleted and Numbered Lists 376

Creating a standard bulleted or numbered list 377

Choosing a different bullet character, size, and color 378

Choosing a different list-numbering style, size, and color 379

Putting Footers (and Headers) on Slides 379

Some background on footers and headers 380

Putting a standard footer on all your slides 381

Creating a nonstandard footer 382

Removing a footer from a single slide 382

Chapter 4: Making Your Presentations Livelier 385

Suggestions for Enlivening Your Presentation 385

Presenting Information in a Table 386

Exploring Transitions and Animations 389

Showing transitions between slides 389

Animating parts of a slide 390

Making Audio Part of Your Presentation 392

Inserting an audio file on a slide 393

Telling PowerPoint when and how to play an audio file 394

Playing audio during a presentation 395

Playing Video on Slides 396

Inserting a video on a slide 396

Fine-tuning a video presentation 397

Experimenting with the look of the video 398

Recording a Voice Narration for Slides 399

Chapter 5: Delivering a Presentation 401

All about Notes 401

Rehearsing and Timing Your Presentation 402

Showing Your Presentation 404

Starting and ending a presentation 404

Going from slide to slide 405

Tricks for Making Presentations a Little Livelier 407

Wielding a pen or highlighter in a presentation 408

Blanking the screen 410

Zooming in 410

Delivering a Presentation When You Can’t Be There in Person 410

Providing handouts for your audience 411

Creating a self-running, kiosk-style presentation 412

Creating a user-run presentation 414

Presenting a presentation online 416

Creating a presentation video 418

Showing a presentation as an animated GIF 419

Book 5: Outlook 2021 421

Chapter 1: Outlook Basics 423

What Is Outlook, Anyway? 423

Navigating the Outlook Apps 424

Categorizing Items 425

Creating a category 425

Assigning items to categories 426

Arranging items by category in folders 427

Searching for Stray Folder Items 427

Conducting an instant search 428

Refining a search 428

Conducting an advanced search 429

Deleting Email Messages, Contacts, Tasks, and Other Items 430

Cleaning Out Your Folders 430

Archiving the old stuff 430

Running the Mailbox Cleanup command 433

Chapter 2: Maintaining the People App 435

Entering and Editing Contact Information 436

Entering information about a new contact 436

Changing a contact’s information 438

Contact Groups for Sending Messages to Groups 439

Creating a contact group 439

Addressing email to a contact group 441

Editing a contact group 441

Finding a Contact 441

Printing the Contacts Folder 442

Different ways to print contact information 442

Changing the look of printed pages 443

Chapter 3: Handling Your Email 445

Setting Up an Email Account 445

Addressing and Sending Email Messages 447

The basics: Sending an email message 447

Addressing an email message 449

Sending copies and blind copies of messages 449

Replying to and forwarding email messages 451

Sending Files and Photos 452

Sending a file along with a message 452

Including a photo in an email message 453

Receiving Email Messages 454

Getting your email 455

Being notified that email has arrived 455

Reading Your Email in the Inbox Window 456

Handling Files That Were Sent to You 457

Opening a file you received 458

Saving a file you received 459

Techniques for Organizing Email Messages 459

Flagging email messages 460

Rules for earmarking messages as they arrive 461

All about Email Folders 462

Moving email messages to different folders 463

Creating a new folder for storing email 463

Yes, You Can Prevent Junk Mail (Sort of) 464

Defining what constitutes junk email 465

Preventative medicine for junk email 465

Chapter 4: Managing Your Time and Schedule 467

Introducing the Calendar 467

The Different Kinds of Activities 468

Seeing Your Schedule 469

Going to a different day, week, or month 469

Rearranging the Calendar window 470

Scheduling Appointments and Meetings 470

Scheduling an event: The basics 471

Scheduling a recurring appointment 472

Scheduling an all-day appointment 472

Canceling, Rescheduling, and Altering Activities 473

Managing Meetings with the Calendar 474

Scheduling and inviting colleagues to a meeting 474

Accepting (or declining) meeting invitations 476

Canceling and rescheduling meetings 477

Book 6: Access 2021 479

Chapter 1: Introducing Access 481

What Is a Database, Anyway? 482

Tables, Queries, Forms, and Other Objects 482

Database tables for storing information 482

Forms for entering data 484

Queries for getting the data out 485

Reports for presenting and examining data 486

Macros and modules 487

Creating a Database File 487

Creating a blank database file 488

Getting the help of a template 488

Finding Your Way Around the Navigation Pane 489

Designing a Database 491

Deciding what information you need 491

Separating information into different database tables 492

Choosing fields for database tables 493

Deciding on a primary key field for each database table 494

Mapping the relationships between tables 495

Chapter 2: Building Your Database Tables 497

Creating a Database Table 497

Creating a database table from scratch 498

Creating a database table from a template 499

Importing a table from another database 500

Opening and Viewing Tables 501

Entering and Altering Table Fields 502

Creating a field 503

All about data types 504

Designating the primary key field 506

Moving, renaming, and deleting fields 507

Field Properties for Making Sure That Data Entries Are Accurate 508

A look at the Field Properties settings 509

Creating a lookup data-entry list 514

Indexing for Faster Sorts, Searches, and Queries 516

Indexing a field 517

Indexing based on more than one field 517

Establishing Relationships among Database Tables 519

Types of relationships 519

Handling tables in the Relationships window 521

Forging relationships between tables 522

Editing table relationships 524

Chapter 3: Entering the Data 525

The Two Ways to Enter Data 525

Entering the Data in Datasheet View 527

Entering data 527

Two tricks for entering data quicker 528

Changing the appearance of the datasheet 529

Entering the Data in a Form 530

Creating a form 531

Entering the data 532

Finding a Missing Record 532

Finding and Replacing Data 534

Chapter 4: Sorting, Querying, and Filtering for Data 535

Sorting Records in a Database Table 535

Ascending vs descending sorts 536

Sorting records 536

Filtering to Find Information 536

Different ways to filter a database table 537

“Unfiltering” a database table 539

Filtering by selection 539

Filtering for input 540

Filtering by form 541

Querying: The Basics 542

Creating a new query 543

Viewing queries in Datasheet and Design views 543

Finding your way around the Query Design window 544

Choosing which database tables to query 545

Choosing which fields to query 546

Sorting the query results 547

Choosing which fields appear in query results 547

Entering criteria for a query 548

At last — saving and running a query 550

Six Kinds of Queries 550

Select query 551

Top-value query 551

Summary query 551

Calculation query 552

Delete query 553

Update query 555

Chapter 5: Presenting Data in a Report 557

Creating a Report 557

Opening and Viewing Reports 559

Tweaking a Report 559

Book 7: Publisher 2021 563

Chapter 1: Introducing Publisher 565

“A Print Shop in a Can” 565

Introducing Frames 566

Creating a Publication 567

Redesigning a Publication 568

Choosing a different template 568

Choosing a color scheme 569

Choosing a font scheme 569

Setting up your pages 569

Getting a Better View of Your Work 570

Zooming in and out 570

Viewing single pages and two-page spreads 571

Going from page to page 571

Understanding and Using the Layout Guides 571

Making use of layout guides 572

Aligning objects to ruler and grid lines 574

Chapter 2: Refining a Publication 577

Entering Text on the Pages 577

Making Text Fit in Text Frames 578

Fitting overflow text in a single frame 579

Making text flow from frame to frame 580

Filling out a text frame 581

Formatting Text 581

Making Text Wrap around a Frame or Graphic 582

Replacing the Placeholder Pictures 583

Inserting Frames on the Pages 583

Inserting a new frame 584

Changing the size and position of frames 585

Making Frames Overlap 585

Inserting, Removing, and Moving Pages 586

Chapter 3: Putting on the Finishing Touches 589

Decorating the Text 590

Drawing a horizontal rule on a frame 590

Dropping in a drop cap 591

Techniques for Decorating Pages 592

Plugging in a page part 592

Experimenting with borders and accents 594

Taking advantage of attention getters 594

Backgrounds for pages 595

Master Pages for Handling Page Backgrounds 596

Switching to Master Page view 596

Changing the look of a master page 597

Applying (or unapplying) a master page to publication pages 597

Running the Design Checker 598

Commercially Printing a Publication 599

Book 8: Working with Charts and Graphics 601

Chapter 1: Creating a Chart 603

The Basics: Creating a Chart 603

Choosing the Right Chart 605

Providing the Raw Data for Your Chart 607

Positioning Your Chart in a Workbook, Page, or Slide 609

Changing a Chart’s Appearance 610

Changing the chart type 610

Changing the size and shape of a chart 611

Choosing a new look for your chart 612

Changing the layout of a chart 612

Handling the gridlines 614

Changing a chart element’s color, font, or other particular 615

Saving a Chart as a Template So That You Can Use It Again 616

Saving a chart as a template 616

Creating a chart from a template 617

Chart Tricks for the Daring and Heroic 617

Decorating a chart with a picture 617

Annotating a chart 618

Placing a trendline on a chart 619

Troubleshooting a Chart 620

Chapter 2: Making a SmartArt Diagram 623

The Basics: Creating SmartArt Diagrams 623

Choosing a diagram 624

Making the diagram your own 625

Creating the Initial Diagram 626

Creating a diagram 626

Swapping one diagram for another 627

Changing the Size and Position of a Diagram 628

Laying Out the Diagram Shapes 628

Selecting a diagram shape 628

Removing a shape from a diagram 629

Moving diagram shapes to different positions 629

Adding shapes to diagrams apart from hierarchy diagrams 629

Adding shapes to hierarchy diagrams 630

Adding shapes to Organization charts 632

Promoting and demoting shapes in hierarchy diagrams 634

Handling the Text on Diagram Shapes 634

Entering text on a diagram shape 635

Entering bulleted lists on diagram shapes 635

Changing a Diagram’s Direction 636

Choosing a Look for Your Diagram 637

Changing the Appearance of Diagram Shapes 638

Changing the size of a diagram shape 639

Exchanging one shape for another 639

Changing a shape’s color, fill, or outline 640

Changing fonts and font sizes on shapes 640

Creating a Diagram from Scratch 641

Chapter 3: Handling Graphics and Photos 643

All about Picture File Formats 643

Bitmap and vector graphics 644

Resolution 644

Compression 644

Color depth 645

Choosing file formats for graphics 646

Inserting a Picture in an Office File 646

Inserting a picture of your own 646

Obtaining a picture online 648

Touching Up a Picture 650

Softening and sharpening pictures 650

Correcting a picture’s brightness and contrast 651

Recoloring a picture 652

Choosing an artistic effect 653

Selecting a picture style 654

Cropping off part of a picture 655

Removing the background 656

Compressing Pictures to Save Disk Space 657

Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 659

The Basics: Making Lines, Arrows, and Shapes 660

Handling Lines, Arrows, and Connectors 662

Changing the length and position of a line or arrow 662

Changing the appearance of a line, arrow, or connector 662

Attaching and handling arrowheads on lines and connectors 664

Connecting shapes by using connectors 664

Handling Rectangles, Ovals, Stars, and Other Shapes 666

Drawing a shape 667

Changing a shape’s symmetry 668

Using a shape as a text box 669

Drawing by Freehand 670

Freehand drawing with a pen or highlighter 670

Changing the look of freehand drawings 671

Drawing a math expression 672

Decorating Your Work with Icons 673

Inserting a 3-D Model 674

WordArt for Embellishing Letters and Words 675

Creating WordArt 675

Editing WordArt 676

Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects 676

Selecting objects so that you can manipulate them 678

Hiding and displaying the rulers and grid 678

Changing an Object’s Size and Shape 679

Changing an Object’s Color, Outline Color, and Transparency 681

Filling an object with color, a picture, or a texture 681

Making a color transparent 684

Putting the outline around an object 684

Moving and Positioning Objects 685

Tricks for aligning and distributing objects 686

When objects overlap: Choosing which appears above the other 689

Rotating and flipping objects 691

Grouping objects to make working with them easier 692

Book 9: Office 2021: One Step Beyond 693

Chapter 1: Customizing an Office Program 695

Customizing the Ribbon 695

Displaying and selecting tab, group, and command names 697

Moving tabs and groups on the Ribbon 698

Adding, removing, and renaming tabs, groups, and commands 698

Creating new tabs and groups 700

Resetting your Ribbon customizations 700

Customizing the Quick Access Toolbar 701

Adding buttons to the Quick Access toolbar 701

Changing the order of buttons on the Quick Access toolbar 702

Removing buttons from the Quick Access toolbar 704

Placing the Quick Access toolbar above or below the Ribbon 704

Customizing the Status Bar 704

Changing the Screen Background and Office Theme 705

Customizing Keyboard Shortcuts in Word 706

Chapter 2: Ways of Distributing Your Work 709

Printing — the Old Standby 709

Distributing a File in PDF Format 711

About PDF files 712

Saving an Office file as a PDF 713

Sending Your File in an Email Message 713

Saving an Office File as a Web Page 714

Turning a file into a web page 715

Opening a web page in your browser 716

Book 10: File Sharing and Collaborating 717

Chapter 1: Up and Running on OneDrive 719

Signing In to OneDrive 719

Exploring the OneDrive Window 720

Managing Your OneDrive Folders 721

Creating a folder 721

Viewing and locating folders in the OneDrive window 722

Selecting folders and files 722

Going from folder to folder in OneDrive 724

Deleting, moving, and renaming folders 726

Uploading Files to a Folder on OneDrive 726

Saving a File from Office to OneDrive 727

Opening a File from OneDrive 728

Starting in an Office desktop application 728

Starting in OneDrive 729

Downloading Files from OneDrive to Your Computer 729

Chapter 2: File Sharing and Collaborating 731

Sharing Files: The Big Picture 731

Sharing Your Files and Folders with Others 733

Inviting people by email 733

Generating a link to shared files 734

Generating HTML code 735

Seeing Which Files and Folders Are Shared 736

Investigating and Managing How Files and Folders Are Shared 737

Index 739