Introduction

At times, you’ll need to reorganize a workbook by adding additional worksheets, moving their appearance order within the workbook, or even deleting an unused or outdated worksheet. You can rename worksheets to better show the theme of your workbook. When using your workbook, there may be times when you’ll want to hide certain worksheets due to sensitive or confidential information. You can also freeze the column and row headings to ease viewing a long list of data.

On any worksheet, you can insert and delete cells, rows, and columns. You can adjust column width and row height so that you can structure the worksheet exactly the way you want. It’s easy to make changes because Microsoft Excel updates cell references in existing formulas ...

Get Excel® 2013 On Demand 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.