Spacing around text

R

Richard Evans

I have a column of cells containing text. The amount of text varies. I
enter it with word wrap, so the height of each cell adjusts to fit the
text. Therein lies the problem. The text fills the cell from top to
bottom. When I print the column, it looks like a single column of
text.

How can I add some spacing around each block of text so that each is
visually distinct in the printed result?

I tried adding borders, but that just adds clutter.

I don't want to manually resize the cells because I may have as many
as 25,000 entered over a period of months. I don't want to have to
resize it every time I add a new largest cell.
 
S

Shane Devenshire

Hi,

One solution, though far from elegant is to press Alt+Enter at the end of
each line of text.

You could add double bottom borders to all the cells with data.

You could alternate the row color white/blue/white/blue (fill color)

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top