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

cells

ResolvedVersion 2007

Iwona has attended:
Excel Introduction course

Cells

how do I adjust cells in a column into the longest text in it?

RE: cells

Hi Iwona,
Thank you for your question;
In answer; the quickest way to adjust a column width to the widest entry is to double click on the column divider -- for example if you wish to widen column H you would double click in the column indicator bar on the dividing line/join between H and I, I hope that has helped ... Pete

Mon 15 Dec 2008: Automatically marked as resolved.

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

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.13 secs.