Chapter 10. Modifying Worksheets
Raw data typed in a monospaced font into fixed-width columns is satisfactory for many worksheets, but it isn’t fine for all worksheets. Excel provides a variety of formatting tools and procedures that you can apply to dress up any worksheet. With minimal effort, you can turn the ordinary into presentation-quality material.
In addition to formatting a sheet, you can alter its structure by changing the widths and heights of selected columns and rows; adding or deleting rows, columns, and cells; and moving or copying data to different areas of the sheet.
Setting Column and Row Sizes
You can change the width of selected columns and the height of selected rows as your data dictates. This is particularly useful when a lengthy ...