Chapter 4

Managing Worksheets

IN THIS CHAPTER

check Inserting and deleting columns and rows in a worksheet

check Splitting the worksheet into separate panes

check Outlining data in a worksheet

check Inserting, deleting, and reordering worksheets in a workbook

check Opening windows on different worksheets in a workbook

check Working with multiple workbooks

check Opening windows on different workbooks

check 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, ...

Get Excel 2019 All-in-One For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.