Building and Formatting Worksheets

In this chapter, you will examine how to build and format worksheets quickly and efficiently in Excel for iPad. You will start by creating the structure of your workbook, inserting and deleting worksheets as needed, renaming and rearranging them, and culling stragglers. You will move on to inserting and deleting rows, columns, and cells; setting column height and row width; and hiding any rows or columns you don’t want people to see. After that, you will dig into formatting cells and ranges, using the Find and Replace features, and sorting and filtering your data to show the records you need. You will finish by looking at how to work with comments and how to print all or part of a workbook.