Microsoft Office Tutorials and References
In Depth Information
Modifying Worksheets
After you put up the signposts that make your data easy to find, you can take other
steps to make the data in your workbooks easier to work with. For example, you can
change the width of a column or the height of a row in a worksheet by dragging the
column’s right border or the row’s bottom border to the desired position. Increasing
a column’s width or a row’s height increases the space between cell contents, making
your data easier to read and work with.
Tip You can apply the same change to more than one row or column by selecting the rows
or columns you want to change and then dragging the border of one of the selected rows or
columns to the desired location. When you release the mouse button, all the selected rows
or columns change to the new height or width.
Modifying column width and row height can make a workbook’s contents easier to work
with, but you can also insert a row or column between cells that contain data to make
your data easier to read. Adding space between the edge of a worksheet and cells that
contain data, or perhaps between a label and the data to which it refers, makes the
workbook’s contents less crowded. You insert rows by clicking a cell and clicking the Home
tab on the ribbon. Then, in the Cells group, in the Insert list, click Insert Sheet Rows. Excel
inserts a row above the row that contains the active cell. You insert a column in much the
same way, by choosing Insert Sheet Columns from the Insert list. When you do this, Excel
inserts a column to the left of the active cell.
When you insert a row, column, or cell in a worksheet that has had formatting applied,
the Insert Options button appears. Clicking the Insert Options button displays a list of
choices you can make about how the inserted row or column should be formatted. The
following table summarizes your options.
Option
Action
Format Same As Above
Applies the formatting of the row above the inserted row to the
new row
Format Same As Below
Applies the formatting of the row below the inserted row to the
new row
Format Same As Left
Applies the formatting of the column to the left of the inserted
column to the new column
Format Same As Right
Applies the formatting of the column to the right of the inserted
column to the new column
Clear Formatting
Applies the default format to the new row or column
 
Search JabSto ::




Custom Search