Copy the column width to retain the source of the Excel spreadsheet

In Excel, according to the paper size if the column width is set up, ready to print out a copy of the form, I would like to change the contents of some of its forms as another form, whether or not the form found in the contents of the stick has not changed, but the width of column has changed? Only once again in order to adjust the column width printout. In fact, as long as we do again and then will be able to stick out one form to retain the source column width. If selected in the worksheet cells ready to copy, copy to other cells, you will find a new visco-column width of the table although changed, but the lower right corner of the table but more out of a “Paste Options” button, if there is no found that “Paste Options” button, you can click the “Tools” → Options, in the open “Options” dialog box, select “Edit” tab, look at the “Show Paste Options” is checked on

Click the “Paste Options” button, select “reservations source column width”, stick to keep the same form from the original column width of the!

You might also like

Form regulation with the shortcut keys
Use “Shift” key to change Excel cell into picture
Word Print Settings tips
Two methonds to copy the formula result instead of the formula itself

No Comments »

No comments yet.

RSS feed for comments on this post.

Leave a comment