like, when i fill something if the column width is less, then it does not fully display. it gets displayed fully only in the row in the tool bar above when we highlight that row.how to extend the width of the column so that everything i enter is displayed?
2007-02-04 00:53:35 · 5 answers · asked by Anonymous in Computers & Internet ➔ Other - Computers
pls answer fast its urgent..
2007-02-04 00:55:28 · update #1
how can i increase the vertical height of a cell in a column. if i have already entered data how can i retain the data even after increasing the height or width because, once the cell is filled and then if i manipulate the size still all what i ve entered will not be displayed
2007-02-04 01:07:14 · update #2
Say the data is in column A, and the data is not fully displayed. Move the cursor up to where the separator line between column A and B is and move it wider. You can tell it's column width, because a cross-shaped icon with 2 arrows on the sides will display. Just click and drag at this point. Doing this should make the data become displayed in the column.
2007-02-04 00:59:34 · answer #1 · answered by anonymous 1 · 0⤊ 0⤋
Two ways:
- Simply grab the side of the column at the top of the sheet and drag it to the right, this making the column bigger and displaying more text.
- Set the column to 'wrap' so that any text to big to display will wrap inside the column as much as it needs to display the full text. Do this by right-clicking at the top of the relevant column and selecting "Format Cells...". Then go into the Alignment tab and check the "Wrap text" check box.
2007-02-04 09:03:24 · answer #2 · answered by Bamba 5 · 0⤊ 0⤋
You can go to the top of the column place you cursor on the line hold down the mouse button and drag to the right. This will adjust the column width.
2007-02-04 09:06:34 · answer #3 · answered by Jim S 1 · 0⤊ 0⤋
Click on the column you want and highlight it. If you hold your mouse over the vertical line at the top, you will get a + sign. You can then adjust the width. Just one way to do it. There are lots of ways to work in excel. Have you tried their help in the menu? Not too hard to understand sometimes esp. with simple tasks.
2007-02-04 09:00:38 · answer #4 · answered by kk 4 · 0⤊ 0⤋
Go to the top of the screen, where the letters are that indicate the column that you are in. There are lines between them indicating the end of the column. Hold your mouse over the line to the right of the column letter. The mouse cursor will change to arrows. Double click your mouse, and excel will automatically adjust the column size to make your text show. You can also click and drag it manually instead of double clicking.
2007-02-04 08:59:55 · answer #5 · answered by Snoopy 5 · 0⤊ 0⤋