Excel cells not displaying full contents

  morters 20 Oct 12
Locked
Answered

I am in the process of producing a catalogue of some 450 antiquarian books as an Excel (2007) spreadsheet. I am using 7 columns (author, title, printer/year of publication, edition number, etc). Some entries are no more than one line but others go to 6 or more lines. As I was reviewing it today, I realised that some of the cells are not displaying all the lines entered. I can readily correct these manually simply by dragging the lower cell edge down until everything is displayed. But this is quite a laborious task and there is always the danger I will miss some cells that are partially obscuring lines. Is there any way of doing this automatically?

  TonyV 20 Oct 12

morters

I haven't got Excel 2007 on this machine, and my laptop is having its battery sorted, but from memory I think you need to look at "Wrap" which should automatically wrap the text with in the cell width. Check it out through Formatting.

Cheers

TonyV

  morters 20 Oct 12

Thanks, TonyV, but as far as I can the cells already are set to wrap.

  Woolwell 20 Oct 12

Try clicking top left corner of the spreadsheet which selects all of the cells or ctrl-a then on the home tab - cells - format - dropdown -choose autofit row height.

  TonyV 20 Oct 12

morters

Alternatively, following on from Woolwell's response, select all the worksheet, and then go into the Alignment Dialog Box Launcher and select the Wrap text box. This should then allow all cells to wrap where necessary, which in effect means those that do not require wrapping will not be!

The notes here have come from "The Brilliant Office 2007" hand book.

TonyV

  morters 20 Oct 12

Thanks TonyV and Woolwell - had to pop out for ciggies hence delay responding.

I'm going to make a copy of my work (it represnts many, many hours work) beforre attempting either solution.

  Woolwell 20 Oct 12

I hope that you do backups.

Undo will put it back as before very quickly.

  morters 20 Oct 12
Answer

Bingo, Woolwell, seems to have worked a treat! TonyV, your suggestion would ensure everything is wrapped. I'll use both for belt and braces job, thank you both!

Advertisement

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

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

Encore creates eerie effects for Spielberg's new TV show The Whispers

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message