MS Excel : Adjust column widths with SPECIAL PASTE

MS Excel : Adjust column widths with SPECIAL PASTE

When you click on the Copy button on the Home tab,
by pressing Ctrl + C, or by clicking Copy in context
menu, you can easily copy the contents of a range
of cells so you can paste the content somewhere
More on your worksheet. The cells can contain many
information.When you glue with Glue Extraordinary, you
Choose precisely what data you need to glue.

You can choose to paste everything or you can
choose to paste only one element of the cell
contents, such as formula, value, format,
comment, validation or column width.

you can glue more than once.. For example when
paste by clicking Paste, Excel paste the values,
formulas and formats but does not adjust the
column widths You can remedy this problem.
pasting in two steps. In the first step, paste the column
widths Excel adjusts column widths. At
second step, paste your values, formulas and
formats

1 Click and drag to select the cells
do you want to copy
2 Click the Start tab.
3 Click on the Copy button.
4 Place the cursor in the cell (s)
in which you want to paste.
5 Click Paste.
A menu appears.
6 Click Paste Special.

The Paste Special dialog box
appears.
7 Click Column Widths
(changes to).
8 Click OK.

Excel copies the
column widths
from the source to
destiny.
9 Click Paste.

Excel paste the contents of the cell.
You can press Esc to end the copy session.

Did you know

You can choose Skip Blanks
option (change to) in the
Paste Special dialog box if your
Source includes any blank space. If you
do, Excel will not overwrite a
target cell with a blank if the
The destination cell has data.

Did you know

You can press Ctrl + C to copy. you
You can press Ctrl + V to paste. you can press ctrl x to cut.
Cutting movements
data from your current location to
The location where you paste it.

Did you know

The office clipboard has
graphic objects, so you can
use it to bring digital photos,
WordArt and clip art of
Other programs in Excel.