Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2010

Mainul has attended:
Excel Introduction course
Excel Intermediate course

Excel

How do I adjust column width for multiple cells quickly?
I want all my columns to have the same width.

RE: Excel

Hi Mainul

You can adjust multiple columns to exactly the same width for example for columns B to K as follows:

1. Highlight all the columns to adjust by selecting the column heading B and dragging to K.
2. Go to the gap between any two column heading. (For example between B and C) then click and drag to the required width.

Now all the columns selected will be exactly that width.

An alternative is to right click on of the selected column heading, choose Column Width and type a number for the width. (standard width is about 8)

Hope that is what you are wanting?

Regards
Doug
Best STL

RE: Excel

Hello,

Thank you Doug, that's exactly what I was looking for.

Mainul

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.