how to fit cell to words in excel 2010

sponsored ads

answer this question

Addison 414

how to do auto fit to cell in excel 2010

1

In Microsoft excel, as you fill out data into each cell, it does not always auto expand to fit your selection.
2

Excel without auto fit

In the screen shot we give an example of above.
3

As you can see with it spread out it does not fit into the cell.
This can become, frustrating for both the user entering the data, and the person who needs to read it.
4

Left Click Selection

There is actually quite a simple solution to this.
in the upper left hand corner of excel. (Screenshot Attached)
Left Click, in the screenshot the line in the upper left represents where to click. This will highlight the complete sheet you are on.
To the left of "A" and above the number "1"
5

Once you have left clicked and the complete sheet, has been highlighted, you will move to the next step. Which is to edit the column width
6

Format Menu

To edit the column width, you will want to go to the Format menu, in 2003, inn 2007 it is on the Home tab to the right as the screenshot indicates.
7

Auto Fit Column Width

Once you have the format menu up select, Auto Fit Column width.
Image attached indicates this selection.
8

Auto fit selection complete

Once complete your sheet will change. It will now take the information it the cells, and expand the cells so the information will fit.

Compare this image to the first image

Answered Sep, 16 2010

Soultrap 153

how can i fit text in excel cell with c#

Well, you can do the following:

Excel.Range xlEntireColumn = null;
Excel.Range xlRange = null;

while (reader.Read()) {
for (int i=0;i<numcols;i++) { 
    xlsheet.ActiveSheet.Cells[row,i+1] = reader.GetValue(i).ToString();

    xlRange = xlSheet.ActiveSheet.Cells[row, i+1];
    xlEntireColumn = xlRange.EntireColumn;
    xlEntireColumn.AutoFit();
}

Hope this helps.

Answered Jul, 13 2010

Hardred 285

how do i get sentences to fit into one cell in excel

There two method I'm aware of

(1) Drag the column large enough so you can see the whole text, but then this look weird

(2) Cell merging, because you merge it, then it become 1 cell.

To do this highlight all the cell you want to merge. Right click. Left click Format Cells...

Left click Alignment
Left click Merge Cells
Left click OK

This is based on Excel 2007, so it might be slightly different but should be similar.

Answered Sep, 24 2010

Search for Related Topics

excel 2010 vba cell word width word 2010 automatically scale picture fit cell phpexcel sized fit cell jasper fit cell excel vbscript excel cell fit word automate widest fit cell word 2010 portable word excel 2010 listview textbox fit cell fit gaussien histogramme excel 2010 word 2010 excel freeze sides break word table excel 2010 excel 2010 resize picture fit cell

Your Answer

community wiki: community owned posts do not generate any reputation for the owner, have a lower reputation barrier for collaborative editing, and show only a revision history instead of a signature block

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.

Username:
Password:

Create one

Related Unresolved Questions

how to group the items in a Date field (1 answers)
How to Format the X-axis and Y-axis in Excel 2010 Charts? (1 answers)
how to round a time to the nearest hour in excel (1 answers)
make web data refresh in different places on microsoft Excel (1 answers)
how to write curved in microsoft excel (1 answers)

how to fit cell to words in excel 2010

More Articles Related • Recent

Recent Searches

Download related software from AFC

FIT Radio 1.0.18