1. Copy the data u want
2. Goto location where u want to paste
3. Goto Home tab > Paste button (lower part as showing in pic)
4. Click on button "Paste with source width", at 2nd row 2nd column (as showing in pic)
Shortkey is ALT + H + V + W
Tuesday, February 21, 2017
Paste with Source Column Width
Sometimes when u copy data from one location to another, u want to adjust the column width same as source data. You can do it by following steps ...
1. Copy the data u want
2. Goto location where u want to paste
3. Goto Home tab > Paste button (lower part as showing in pic)
4. Click on button "Paste with source width", at 2nd row 2nd column (as showing in pic)
Shortkey is ALT + H + V + W
1. Copy the data u want
2. Goto location where u want to paste
3. Goto Home tab > Paste button (lower part as showing in pic)
4. Click on button "Paste with source width", at 2nd row 2nd column (as showing in pic)
Shortkey is ALT + H + V + W
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment