Excel 2016 All-in-One For Dummies

Chapter 4

Managing Worksheets

In This Chapter

Inserting and deleting columns and rows in a worksheet

Splitting the worksheet into separate panes

Outlining data in a worksheet

Inserting, deleting, and reordering worksheets in a workbook

Opening windows on different worksheets in a workbook

Working with multiple workbooks

Opening windows on different workbooks

Consolidating worksheet data

Being able to manage and reorganize the information in your spreadsheet is almost as important as being able to input data and edit it. As part of these skills, you need to know how to manipulate the columns and rows of a single worksheet, the various worksheets within a single workbook, and, at times, ...