Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Making a Worksheet Easier to Read and Understand
Changing the orientation of text in cells is an elegant solution to the problem
of keeping a worksheet from getting too wide. Numbers are usually a few
characters wide, but heading labels can be much wider than that. By
changing the orientation of a heading label, you make columns narrower and keep
worksheets from growing too wide to fit on the screen or page.
Inserting and deleting rows and columns
At some point, everybody has to insert new columns and rows and delete
ones that are no longer needed. Make sure before you delete a row or
column that you don’t delete data that you really need. Do the following to
insert and delete rows and columns:
✦ Deleting rows or columns: Drag across the row numbers or column
letters of the rows or columns you want to delete; then right-click and
choose Delete, or, on the Home tab, open the drop-down list on the
Delete button and select Delete Sheet Rows or Delete Sheet Columns.
✦ Inserting rows: Select the row below the row you want to insert; then,
on the Home tab, open the drop-down list on the Insert button and choose
Insert Sheet Rows, or right-click the row you selected and choose Insert
on the shortcut menu. For example, to insert a new row above row 11,
select the current row 11 before choosing Insert Sheet Rows. You can
insert more than one row at a time by selecting more than one row
before giving the Insert Sheet Rows command.
✦ Inserting columns: Select the column to the right of where you want
the new column to be; then, on the Home tab, open the drop-down list
on the Insert button and choose Insert Sheet Columns, or right-click
the column you selected and choose Insert on the shortcut menu. You
can insert more than one column this way by selecting more than one
column before giving the Insert command.
A fast way to insert several rows or columns is to insert one and keep
pressing F4 (the Repeat command) until you insert all the rows or columns you
After you insert rows or columns, the Insert Options button appears. Click it
and choose an option from the drop-down list if you want your new row or
column to have the same or different formats as the row or column you
selected to start the Insert operation.
To insert more than one row or column at a time, select more than one row
number or column letter before giving the Insert command.