excel 2002 query

  sunny staines 16:31 04 Apr 06
Locked

I am using excel in office XP.

On typing in a cell how to I get the sentence to move down without going into the cell below. All I am getting are very long cell one line long instead of a shorter cell a couple of lines deep.

anyone with any tips please.

  johnnyrocker 16:33 04 Apr 06

format/cells and autofit i think is the solution.


johnny.

  sunny staines 16:38 04 Apr 06

JohnnyRocker

Thanks I will look at formatting options.

  GroupFC 16:49 04 Apr 06

I have just been having an expriment - in excel 2000 it is Format>cells>alignment and put a tick in "wrap to text".

HTH.

  sunny staines 16:57 04 Apr 06

JohnnyRocker / Group FC

Thanks for the tips you were spot on.

  Simsy 18:15 04 Apr 06

to force a line break within a cell you can use ALT+Return

Regards,

Simsy

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

iPad Pro 12.9 vs Surface Pro 5