cell formatting

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell formatting

Cell formatting

resolvedResolved · Medium Priority · Version 2007

Dilip has attended:
Excel Introduction course
Word Intermediate course

Cell formatting

fitting text in cell that has too many characters for size

RE: cell formatting

Hi Dilip

Welcome to the forum.

You can manually change the size of a column by moving your mouse to the column header (the grey horizontal bar with all the capital letters) and clicking and dragging. So if you wanted to change the size of column B, go to the column header B and move just to the right until the mouse pointer becomes a thin black cross. Then click and drag.

You can adjust the cell to automatically resize to the width of the cell with the most info by double clicking in this position.

I hope that answers your question.

David

Mon 15 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips


Server loaded in 0.09 secs.