|  | Cell Border Width | | |
| | | Guest |  |
|  Posted: Tue Aug 12, 2008 6:59 pm Post subject: Cell Border Width |  |
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 | |
| | Posted: Tue Aug 12, 2008 6:59 pm Post subject: Re: Cell Border Width | |
I you experimented with making the columns wider and the rows deeper?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
LINK
remove caps from email
<mark.wolven@gmail.com> wrote in message
news:df49d9bb-4508-470c-b042-d6d27c917e86@d1g2000hsg.googlegroups.com...
| Quote: | 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). |
|
| |
| | | Gord Dibben | |
| | Posted: Tue Aug 12, 2008 7:16 pm Post subject: Re: Cell Border Width | |
See in-line............
On Tue, 12 Aug 2008 13:00:48 -0700 (PDT), mark.wolven@gmail.com wrote:
| Quote: | 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?
| Quote: |
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.
| Quote: |
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 |
| |
| | | Guest | |
| | Posted: Tue Aug 12, 2008 8:00 pm Post subject: Re: Cell Border Width | |
| |  | |
On Aug 12, 3:11 pm, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca>
wrote:
| Quote: | I you experimented with making the columns wider and the rows deeper?
best wishes
--
Bernard V Liengme
Microsoft Excel LINK
remove caps from email
mark.wol...@gmail.com> wrote in message
news:df49d9bb-4508-470c-b042-d6d27c917e86@d1g2000hsg.googlegroups.com...
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).
|
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. |
| |
| | | Guest | |
| | Posted: Wed Aug 13, 2008 2:45 pm Post subject: Re: Cell Border Width | |
| | | |
On Aug 12, 5:16 pm, Gord Dibben <gorddibbATshawDOTca> wrote:
| Quote: | See in-line............
On Tue, 12 Aug 2008 13:00:48 -0700 (PDT), mark.wol...@gmail.com wrote:
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
|
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 | |
| | Posted: Wed Aug 13, 2008 5:57 pm Post subject: Re: Cell Border Width | |
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
On Wed, 13 Aug 2008 07:45:18 -0700 (PDT), mark.wolven@gmail.com wrote:
| Quote: | 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? |
|
| |
| | | Rick Rothstein (MVP - VB) | |
| | Posted: Thu Aug 14, 2008 2:32 am Post subject: Re: Cell Border Width | |
| Quote: | 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 |
| |
|
|
