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

expanding columns

ResolvedVersion 2003

Christina has attended:
Excel Introduction course

Expanding columns

what is the fastest way to expand a column?

RE: expanding columns

Hi Christina,

Thanks for your question and welcome to the forum.

The quickest way to expand a column is to place your mouse on the line between the column you want to expand and the column to the right until your mouse pointer becomes a black bar with two arrows (one pointing left, one pointing right) then double left mouse click. This will resize your column to the largest entry.

Thanks and kind regards

Maggie

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

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