On the Home tab, click the Paste option in the Clipboard group and choose Keep Source Column Widths.Select a cell in the destination column.Select the data and press +C to copy the selected values to the Clipboard.With an extra click, you can copy the source column’s width to the target column, as follows: When you copy data into a new column, the column’s width doesn’t automatically adjust to accommodate the new values. For the shortcut enthusiasts, we’ve included a table at the end that contains keyboard shortcuts for most of these operations. In Excel 2003, Paste Special is on the Edit menu. In Excel 20, Paste is in the Clipboard group on the Home tab. These tricks are so easy to implement that you’ll probably find yourself using the paste features a lot more than you used to. Using this basic feature - as well as assorted Paste options - you can make short work of a few common tasks and some rather complex problems. The Paste Special command is in most Office applications, but Excel users probably benefit from it the most. Use them to do everything from transposing data to copying Validation rules. 10 powerful ways to use Excel’s paste featuresĮxcel's Paste and Paste Special commands harbor a multitude of useful options.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |