• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Formatting Your Worksheets > Formatting Columns and Rows

Formatting Columns and Rows

Another way of formatting your worksheet is to manipulate the appearance of columns and rows. You can easily change the size of columns and rows and insert new columns and rows as needed. You can also choose to hide data you want to keep confidential by hiding columns and rows, or you can merge the data from several cells into one. Making an adjustment to a column or row can greatly improve the appearance of your data.

For example, in a new worksheet, all the columns are the same size. As you enter data, you'll find that this size isn't going to work for all your entries. You may have an entry that is too big. When you enter a long entry, several things can happen. If it's text that is too long, Excel truncates the entry. If it's a number that is too long, Excel displays number signs (#####) in the cell. In these instances, you can widen the column to make more room for your data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint