Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Copy Column Widths in MS Excel

Thursday, November 3rd, 2005 by | Filed Under: MS Excel
 
Loading...


Copy Only Column Width?

How much time have you wasted changing and re-changing column widths trying to match one column with another in MS Excel? You could use the Format menu, Column sub-menu, Width choice and enter the width you need. Of course, then you’d have to know exactly what width you need and keep it all straight… not worth the time.

Do you have to go back to highlighting all the columns that should match and resizing yet again? No, certainly not!

Let’s take a look at copying just the column width from one column to another. The first step is to have a cell selected in the column that has the width you want to transfer.

Copy that cell. .Use the Copy button, Ctrl + C, Edit menu, Copy choice… whatever method you prefer.

Now select a cell in the column that needs the new width.

Here you’re looking to use Paste Special. You can reach this via the Edit menu or a right click.

Once you’re in the Paste Special window, locate the Column Width choice.

image

Select it and click OK.

Poof! Just like magic, the width of the new column is altered without transferring any of the data or other formatting from the copied cell!

~ April

Comments are closed.

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: