Cell Border Width

[mark.wolven]

Is there a way in Excel to increase the width of a border?

I have lots of text that I am managing in Excel, and when I print it
out, the cells tend to run together a little bit - is there any way to
increase the amount of white space between rows and columns - without
adding a thin empty column between the columns (and a thin empty row
between the rows).

 

[Bernard Liengme]

I you experimented with making the columns wider and the rows deeper?
best wishes

 

[mark.wolven]

I you experimented with making the columns wider and the rows deeper?
best wishes

I was using auto row height to set the height of the row - but after a
certain number of characters it no longer functions for setting the
row height.

As for width - if I have a paragraph in the cell, making the cell
wider just puts more characters on each line - it doesn't make the
characters any farther from the characters in the adjacent cell.

In one range, I have 258 rows and 13 columns - I know that I have to
manually check each row height now - but I was hoping for some help on
the adjacent columns issue.

 

[Gord Dibben]

See in-line............

I was using auto row height to set the height of the row - but after a
certain number of characters it no longer functions for setting the
row height.

Excel has a 1024 limit on displayed characters in a cell. Are you running
over this limit?

As for width - if I have a paragraph in the cell, making the cell
wider just puts more characters on each line - it doesn't make the
characters any farther from the characters in the adjacent cell.

You can format the cells to wrap text and have an indent right or left.
Play with those settings.

In one range, I have 258 rows and 13 columns - I know that I have to
manually check each row height now - but I was hoping for some help on
the adjacent columns issue.

Gord Dibben MS Excel MVP

 

[mark.wolven]

See in-line............



Excel has a 1024 limit on displayed characters in a cell.  Are you running
over this limit?




You can format the cells to wrap text and have an indent right or left.
Play with those settings.




Gord Dibben  MS Excel MVP

Thanks - I had completely overlooked the left and right indent -
unfortunately, it's a left OR right in indent on not both but that
will work perfectly.

As for the display limit - yes, I have a number of instances where we
exceed 1024 cells. Other than putting less text in the cells, do you
have any thoughts on displaying this information more efficiently?

 

[Gord Dibben]

If you add an Alt + Enter linefeed about every 100 characters you can
increase the 1024 limit by quite a bit.


Gord Dibben MS Excel MVP

 

[Rick Rothstein \(MVP - VB\)]

Thanks - I had completely overlooked the left and right

indent - unfortunately, it's a left OR right in indent on not
both but that will work perfectly.

My guess is that this is probably not what you want, but there is a
Distributed (Indent) available.

Rick