Microsoft Office Tutorials and References
In Depth Information
Delete a Range
3
chapter
Working with Ranges
The Delete dialog box appears.
5 Select the option that
corresponds to how you want
Excel to shift the remaining cells
after it deletes the range (
changes to ).
Note: In most cases, if you have
data below the selected range,
you should click the Shift cells
up option; if you have data to
the right of the selected range,
you should click the Shift cells
left option.
6 Click OK.
A Excel deletes the range and
shifts the remaining data.
Are there faster ways to delete a range?
Yes. Probably the fastest method is to select
the range and then press + . You can
also select the range, right-click any part of
the range, and then click Delete . Both
methods display the Delete dialog box.
How do I delete a row or column?
To delete a row, select any cell in the row,
click Home , click the Delete , and then
click Delete Sheet Rows . To delete a
column, select any cell in the column, click
Home , click the Delete , and then click
Delete Sheet Columns . You can delete
multiple rows or columns by selecting at
least one cell in each row or column.
 
Search JabSto ::




Custom Search