Chapter 4

Managing Worksheets


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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.