Microsoft Office Tutorials and References
In Depth Information
Inserting rows, columns, and cells
Inserting rows, columns, and cells
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.
1
When you insert a row, column, or cell in a worksheet that has had formatting applied, the
Insert Options button appears. When you click the Insert Options button, Excel displays a
list of choices you can make about how the inserted row or column should be formatted,
as described in the following table.
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
If you want to delete a row or column, right-click the row or column head and then, on
the shortcut menu that appears, click Delete. You can temporarily hide rows or columns
by selecting those rows or columns and then, on the Home tab, in the Cells group, clicking
the Format button, pointing to Hide & Unhide, and then clicking either Hide Rows or Hide
Columns. The rows or columns you selected disappear, but they aren’t gone for good as
they would be if you’d used Delete. Instead, they have just been removed from the display
until you call them back. To return the hidden rows to the display, select the row or column
headers on either side of the hidden rows or columns. Then, on the Home tab, in the Cells
group, click the Format button, point to Hide & Unhide, and then click either Unhide Rows
or Unhide Columns.
Search JabSto ::




Custom Search