Spacing on Excel sheet

Resolved · Low Priority · Version 2013

Tue 21 Jan 2014, 16:43 Delegate Anne said...

Anne has attended:
Excel Introduction course
Multiple applications course

Spacing on Excel sheet

Can text be put into single line spacing?

Tue 21 Jan 2014, 21:06 Trainer Gary said...

RE: Spacing on Excel sheet

Hi Anne

Thanks for getting in touch. If you're referring to line spacing for text inside a cell, Excel isn't really designed to do that.

If your text is in successive rows, you can adjust the row height by dragging the dividers between rows up and down.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

View all Excel hints and tips

Spacing on Excel sheet

Spacing on Excel sheet

RE: Spacing on Excel sheet

Excel articles

Excel tip:

Selecting blank cells within a range of data