Microsoft Office Tutorials and References
In Depth Information
Inserting, Deleting, and Hiding Columns and Rows
NOTE: Merge and Center only works if the data you want to center is in the leftmost cell of the
range you want to merge, and if the other cells in the range are empty. If any of these cells also
contain data, their contents will be deleted.
You’re far less likely to use the other two active merge options—Merge Across and Merge
Merge Across lets you select a range consisting of several rows and
columns, and turns each individual row into a single cell (see Figure 5–38).
Figure 5–38. Note the merge effect: Tuesday and July now each occupy a large, merged cell.
Merge Cells lets you turn any range (which can include both rows and/or
columns) into one supercell.
But as with Merge and Center, these only work properly when data is positioned in the
leftmost cell of the selected range (these commands will work with completely empty
ranges, however).
Finally, the awkwardly named Unmerge Cells option restores any merged cells back to
their original state. Select the merged megacell, click Unmerge Cells, and all the original
cells will reappear (see Figure 5–39).
Figure 5–39. Now Tuesday is back in its original cell, and all the cells that had been merged with it are back, too.
Inserting, Deleting, and Hiding Columns and Rows
Merging cells hints at some other important ways in which you can modify the structure of
the worksheet itself, in addition to the data that the worksheet contains. There may be
times when you need to insert or delete a row or column in the worksheet. Say you’ve
constructed a list of employees along with identifying column headings, as in Figure 5–40.
Figure 5–40 The headings for an employee directory. Note the columns have been autofit. .
It then occurs to you that you’ve inadvertently omitted a Salary field, which you want
sandwiched between Telephone Number and Dept. You’ll need to insert a column.
Search JabSto ::

Custom Search