Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 57
Default borders blocked by text

Consider the following situation:
- I define the borders of a block of, say, 10x10 cells such that there are
lines in the "outline" and the "inside" - in other words like a 10x10 grid
- I then enter text in any of the inside cells such that the length of the
text is longer than the wide of the cell I

When I print this (even the screen shows this), the "inside" borders where
the text overflows to the adjacent cells are not displayed or printed.

My question: is there a way to force the borders to show up at all the
borders where any overflow text exist?

My alternate question: What I really want to do is to create some kind of
dotted line (vertical) grid with text (which always overflow the cells)
overlaid on top of it. If there is a way do accomplish this without having to
use border formatting, I am all ears, too.

Thanks a lot.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default borders blocked by text

Few thoughts....

1. The border is not displayed when you have a blank cell to the right.
Enter a space (F2Spacebar) in the right cell to make the border visible. If
you have more blank cells enter space in a unused cell out of your grid.
Select the grid. G5GotoSpecialBlanksRight clickPasteSpecialValues...

2. Hope you already know about 'Wrap Text' option and 'Shrink to Fit'
options available under Format CellsAlignment'Text Control'..


If this post helps click Yes
---------------
Jacob Skaria


"rockhammer" wrote:

Consider the following situation:
- I define the borders of a block of, say, 10x10 cells such that there are
lines in the "outline" and the "inside" - in other words like a 10x10 grid
- I then enter text in any of the inside cells such that the length of the
text is longer than the wide of the cell I

When I print this (even the screen shows this), the "inside" borders where
the text overflows to the adjacent cells are not displayed or printed.

My question: is there a way to force the borders to show up at all the
borders where any overflow text exist?

My alternate question: What I really want to do is to create some kind of
dotted line (vertical) grid with text (which always overflow the cells)
overlaid on top of it. If there is a way do accomplish this without having to
use border formatting, I am all ears, too.

Thanks a lot.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to rotate text without rottating borders rich20 New Users to Excel 5 July 14th 08 10:43 PM
Text is not printing within the borders Nunzia Excel Discussion (Misc queries) 1 June 26th 07 08:36 PM
Cell borders and angled text David M Hargrave Excel Discussion (Misc queries) 2 May 17th 07 09:44 AM
Copyin text only...not borders or shading LS Excel Worksheet Functions 1 April 21st 06 09:40 PM
Borders with aligned text pablo bellissimo Excel Discussion (Misc queries) 1 May 5th 05 06:00 PM


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"