Excel 2016 Managing Worksheets

Table of Contents

ABOUT OFFICEPRO – WE CHANGE LIVES! ...............................................................I

WHAT TO EXPECT FROM OFFICEPRO?...................................................................II

TABLE OF CONTENTS ...........................................................................................III

LESSON 1 -

WORKING WITH MULTIPLE WORKSHEETS.......................................1 Using Multiple Worksheets ......................................................................................2 Navigating between Worksheets .............................................................................3 Selecting Worksheets ...............................................................................................4 Renaming Worksheets .............................................................................................5 Selecting Multiple Worksheets.................................................................................6 Coloring Worksheet Tabs .........................................................................................7 Inserting Worksheets ...............................................................................................9 Deleting Worksheets ..............................................................................................10 Printing Selected Worksheets ................................................................................11 Exercise...................................................................................................................14 MANAGING WORKSHEETS............................................................15 Copying Worksheets...............................................................................................16 Moving Worksheets ...............................................................................................17 Using Grouped Worksheets....................................................................................18 Moving Data between Worksheets........................................................................20 Copying Data between Worksheets .......................................................................22 Creating 3-D Formulas............................................................................................23 Using 3-D Ranges in Functions ...............................................................................26 Exercise...................................................................................................................29 USING LARGE WORKSHEETS .........................................................31 Increasing the Magnification..................................................................................32 Decreasing the Magnification.................................................................................33 Changing the Magnification of a Range .................................................................35 Switching to Full Screen View.................................................................................37 Splitting the Window..............................................................................................38 Removing Split Windows........................................................................................40

LESSON 2 -

LESSON 3 -

OFFICEPRO, Inc.

Page iii