Microsoft Office Tutorials and References
In Depth Information
Insert a Cell or Range
Working with Ranges
The Insert dialog box
5 Select the option that
corresponds to how you
want Excel to shift the
existing cells to
accommodate your new cells
( changes to ).
Note: In most cases, if you
selected a horizontal range,
you should click the Shift
cells down option; if you
selected a vertical range, you
should click the Shift cells
6 Click OK.
A Excel inserts the cell or
B The existing data is shifted
down (in this case) or to
7 Click the Insert Options
smart tag ( ).
8 Select a formatting option
for the new row (
Under what circumstances would I insert a
range instead of inserting an entire row or
It is better to insert a range when you have
other data either to the left or right of the
existing range, or above or below the range.
For example, if you have data to the left or
right of the existing range, inserting an entire
row would create a gap in the other data.
How do I know which cells to select to get
my inserted cell or range in the correct
The easiest way to do this is to select the
existing cell or range that is exactly where
you want the new cell or range to appear.
For example, if you want the new range to
be A5:B5 as shown in this section’s example,
you first select the existing A5:B5 range.