Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I border a bottom half of a cell in excel

I would like to know if there is a way to broder a partial edge of a cell. or
if I can add another column with out all of the cells in that Column. For
example. Can I add another columbn fomr C32 to C34?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default How do I border a bottom half of a cell in excel

I'm afraid that Santa only has coal for your stocking this year. If you're
using any version of Excel before 2007, the answer to both questions is no.

Even with 2007, splitting cells in a column (to get that different column at
C32 to C34 without new cells above/below that range) is not possible. You
could achieve the appearance of such by merging cell-pairs in columns C:D
from C1:D1 to C31:D31 and below C34:D34, but merging cells is not something I
recommend you use without thinking about it befo merging cells creates
associated problems at times.

I don't have 2007 on this machine (and I'm away from home, so no 2007 system
available right now) so I'm not sure what you could do in it, if anything, to
achieve a partially bordered appearance in cells. Remember that you can just
border a single edge of a cell, such as the bottom of it/them only in any
version of Excel.

"Matsnake" wrote:

I would like to know if there is a way to broder a partial edge of a cell. or
if I can add another column with out all of the cells in that Column. For
example. Can I add another columbn fomr C32 to C34?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default How do I border a bottom half of a cell in excel

Have you considered putting a graphics line or box in the cell? Unless I'm
misunderstanding the question, it seems you could put a box with a
transparent fill in the cell and expand it or shrink it to fit.
--
Dave Benson


"Matsnake" wrote:

I would like to know if there is a way to broder a partial edge of a cell. or
if I can add another column with out all of the cells in that Column. For
example. Can I add another columbn fomr C32 to C34?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default How do I border a bottom half of a cell in excel

I thought about something like that also - a box with 'faded' shading so that
just the lower half appears shaded. Problem with graphics is positioning if
cells (rows / columns) are resized and also if they overlay a cell that needs
to be chosen, it makes it very difficult to get to the cell(s). Whether or
not that would play into this, I don't know - only the OP could determine if
such a solution would work for him/her.


"Dave Benson" wrote:

Have you considered putting a graphics line or box in the cell? Unless I'm
misunderstanding the question, it seems you could put a box with a
transparent fill in the cell and expand it or shrink it to fit.
--
Dave Benson


"Matsnake" wrote:

I would like to know if there is a way to broder a partial edge of a cell. or
if I can add another column with out all of the cells in that Column. For
example. Can I add another columbn fomr C32 to C34?

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
Bottom Double Border in Toolbar- Excel 2003 F W Green Excel Discussion (Misc queries) 2 August 11th 07 01:38 PM
Excel Bottom Double Border ICON Phil0 Excel Discussion (Misc queries) 0 April 25th 07 08:24 PM
Text extending beyond the right and bottom border of cell LTeeple Excel Discussion (Misc queries) 5 April 5th 07 10:42 AM
why doesn't Excel 2003 bottom double border icon work RunwithGod Excel Discussion (Misc queries) 2 May 17th 06 01:26 PM
only last cell on page to have bottom border (cell area outline) Wiggum Excel Worksheet Functions 1 April 29th 05 03:53 PM


All times are GMT +1. The time now is 06:31 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"