How do I resize a column in Excel?

Asked by Last Modified  

Follow 0
Answer

Please enter your answer

MCA

Double click on the right border of a column where column labels (A,B,C etc.) exists. It will resize the column to max width of text in it. Other way is to select the column, right click on it and select Column width property. Give the size you want and click on OK.
Comments

Microsoft Certified Expert I Author

HI anand, Please follow these steps to resize a colomn 1.Hover the mouse between two columns or rows until the cursor looks like a bi-directional arrow. 2.Double-click the left mouse button. Your column or row will resize to fit the largest cell in that column or row.
Comments

Microsoft Office

Through Drag cell
Comments

B.Sc (Computers) and a (All India Rankholder) CA.

To do so just by keyboard: - Press ctrl+space bar (to select the column or range of columns) - Press the right click button (available on most keyboards these days) - Press W (to select column width option) & set the width you want by increasing or decreasing the number therein
Comments

View 2 more Answers

Related Questions

What are some cool Microsoft Excel tricks?
there are 1000 of tricks that can be done in excel from basic to complex. but most awesome trick is to play old dosky games in excel, remember the child hood games like mario, boomerman , contra...
Shagufta
0 0
8
How can we convert date into days for any year?
Enter the DATE Select the cell with the returned date. Click the Home tab. Click Format Cells: Number in the Number group.
Sensoph
0 0
9

How many days it will take to complete advance excel course?

The duration to complete any kind, of course, depends on your grasping power and the ability to learn the concepts quickly. Having said that, it usually takes about three to four weeks to learn the topics...
Amit

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Exploring Excel HLOOKUP Formula
Let's break down HLOOKUP in detail. What is HLOOKUP? HLOOKUP (Horizontal Lookup) is an Excel function that searches for a specific value in the first row of a table and returns a value...
G

Ganesh S.

0 0
0


Clipboard Task Pane
When you copy a cell's contents, formula or format, that information goes into the clipboard. The clipboard will hold the information until you decide to paste it somewhere else on the spreadsheet,...

HERE TODAY WE WILL USE THE SUMPRODUCT FUNCTION
A B C D E 1 SR.NO NAME SERIES _1 SERIES_2 TOTAL AMOUNT 2 1 VEERU 2 2 4 =sumproduct(D2,E2) 3 2 MAHIPAL 4 6 24 =sumproduct(D3,E3) 4 3 NIHSA 6 8 48 =sumproduct(D4,E4) 5 4 UMA 10 2 20 =sumproduct(D5,E5) 6 5 SHANKER 12 3 36 =sumproduct(D6,E6) 7 6 MAHESH 7 3 21 =sumproduct(D7,E7) 8 7 KAPIL 8 2 16 =sumproduct(D8,E8) ...

Pivot table - Transform numbers in calculated field
How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking...

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you