Microsoft Office Tutorials and References
In Depth Information
Adjust column widths with
PASTE SPECIAL
By clicking the Copy button on the Home tab,
pressing Ctrl+C, or clicking Copy on a contextual
menu, you can easily copy the contents of a range
of cells so you can paste the contents somewhere
else in your worksheet. Cells can contain a lot of
information. When you paste with Paste Special, you
decide exactly what information you want to paste.
You can choose to paste everything or you can
choose to paste just one element of the cell’s
contents, such as the formula, value, format,
comment, validation, or column width.
You can paste more than once. For example, when
you paste by clicking Paste, Excel pastes the values,
formulas, and formats but does not adjust the
column widths. You can remedy this problem by
pasting in two steps. In the first step, paste column
widths. Excel adjusts the column widths. In the
second step, paste your values, formulas, and
formats.
2
3
1
Click and drag to select the cells
you want to copy.
5
2
Click the Home tab.
4
3
Click the Copy button.
4
Place the cursor in the cell(s)
into which you want to paste.
6
5
Click Paste.
A menu appears.
1
6
Click Paste Special.
l The Paste Special dialog box
appears.
7
Click Column Widths
(
changes to
).
8
Click OK.
7
8
64
 
Search JabSto ::




Custom Search