Microsoft Office Tutorials and References
In Depth Information
Adding and Moving Columns or Rows
Adding and Moving
Columns or Rows
Paste validation . Choose Validation in the Paste section and click OK. This
leaves all the text and formatting behind but copies any validation settings that
you’ve applied to the cells. (Validation is an advanced spreadsheet protection
maneuver used mainly by Excel power users.)
Combine source and destination cells . Choose All in the Paste section, choose
Add, Subtract, Multiply, or Divide from the Operation section, and then click
OK. For example, if you choose Subtract and paste the number 4 into a cell that
currently has the number 6, Excel will change the cell to 2 (because 6−2=4 ). It’s
an intriguing idea, but few people use the Operation settings, because they’re
not intuitive.
Refrain from copying blank cells. Choose All in the Paste section, click the
“Skip blanks” checkbox at the bottom of the dialog box and click OK. Now, if
any of the cells you’re copying are blank, Excel ignores them and leaves the
current contents of the destination cell intact. (With an ordinary paste, Excel would
overwrite the existing value, leaving a blank cell.)
Adding and Moving Columns or Rows
The cut-and-paste and copy-and-paste operations let you move data from one cell (or
group of cells) to another. But what happens if you want to make some major changes
to your worksheet itself? For example, imagine you have a spreadsheet with 10 filled
columns (A to J) and decide you want to add a new column between columns C and
D. You could cut all the columns from D to J and then paste them starting at E. That
would solve the problem and leave the C column free for your new data. But the
actual task of selecting these columns can be a little awkward, and it only becomes more
difficult as your spreadsheet grows in size.
A much easier option is to use two dedicated Excel commands designed for
inserting new columns and rows into an existing spreadsheet. If you use these features,
you won’t need to disturb your existing cells at all.
Inserting Columns
To insert a new column, follow these steps:
1. Find the column immediately to the right of where you want to place the
That means that if you want to insert a new, blank column between columns A
and B, start by looking at the existing column B.
2. Right-clickthecolumnheader(thegrayboxwiththecolumnletterinit)and
Excel inserts a new column and automatically moves all the columns to the
right of column A (so column B becomes column C, column C becomes
column D, and so on).
Search JabSto ::

Custom Search