Microsoft Office Tutorials and References
In Depth Information
Staying in Step with Insert
Staying in Step with Insert
For those inevitable times when you need to squeeze new entries into an
already populated region of the worksheet, you can insert new cells in the
area rather than go through all the trouble of moving and rearranging
several individual cell ranges. To insert a new cell range, select the cells (many
of which are already occupied) where you want the new cells to appear and
then click the drop-down button on the right end of the Insert command
button (rather than the button itself) in the Cells group of the Home tab and
then click Insert Cells on the drop-down menu (or press Alt+HII). The Insert
dialog box opens with the following option buttons:
Shift Cells Right: Select this to shift existing cells to the right to make
room for the ones you want to add before clicking OK or pressing Enter.
Shift Cells Down: Use this default to instruct the program to shift
existing entries down before clicking OK or pressing Enter.
Entire Row or Entire Column: When you insert cells with the Insert dialog
box, you can insert complete rows or columns in the cell range by
selecting either of these radio buttons. You can also select the row number or
column letter on the frame before you choose the Insert command.
If you know that you want to shift the existing cells to the right to make room
for the newly inserted cells, you can simply click the Insert command button
on the Ribbon’s Home tab (this is the same thing as opening the Insert dialog
box and then clicking OK when the Shift Cells Right button is selected).
Remember that you can also insert entire columns and rows in a worksheet
by right-clicking the selection and then clicking Insert on the column’s or
row’s shortcut menu.
As when you delete whole columns and rows, inserting entire columns and
rows affects the entire worksheet, not just the part you see. If you don’t know
what’s out in the hinterlands of the worksheet, you can’t be sure how the
insertion will affect — perhaps even sabotage — stuff (especially formulas) in
the other unseen areas. I suggest that you scroll all the way out in both
directions to make sure that nothing’s out there.
Stamping Out Your Spelling Errors
If you’re as good a speller as I am, you’ll be relieved to know that Excel 2013
has a built-in spell checker that can catch and remove all those embarrassing
Search JabSto ::




Custom Search