Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How can I add borders inside a cell?

How can I add borders inside a cell? (Sub-divide a cell with a different
border line type)
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How can I add borders inside a cell?

To add borders inside a cell and sub-divide it with a different border line type, you can follow these steps:
  1. Select the cell or cells that you want to add borders to.
  2. Click on the "Borders" dropdown menu in the "Home" tab of the ribbon.
  3. Select "More Borders" at the bottom of the menu.
  4. In the "Format Cells" dialog box, go to the "Border" tab.
  5. Under "Presets", select the type of border you want to apply to the outside of the cell.
  6. Under "Style", select the type of border you want to apply to the inside of the cell.
  7. Under "Color", select the color you want for the border.
  8. Under "Width", select the thickness of the border.
  9. Use the preview pane to see how the border will look.
  10. Click "OK" to apply the border to the selected cell(s).

You can also use the "Draw Borders" tool to draw custom borders inside the cell. To do this, follow these steps:
  1. Select the cell or cells that you want to add borders to.
  2. Click on the "Borders" dropdown menu in the "Home" tab of the ribbon.
  3. Select "Draw Borders" at the bottom of the menu.
  4. Use the pencil tool to draw the border inside the cell.
  5. Use the eraser tool to remove any unwanted lines.
  6. Use the preview pane to see how the border will look.
  7. Click "OK" to apply the border to the selected cell(s).

By following these steps, you can easily add borders inside a cell and sub-divide it with a different border line type.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How can I add borders inside a cell?

In a single cell the only sub-division you can have is a diagonal border line.

Note...........this is formatting only and does actually split the cell into
two.

You cannot split a cell.


Gord Dibben MS Excel MVP

On Wed, 21 Mar 2007 11:23:13 -0700, jagersmann
wrote:

How can I add borders inside a cell? (Sub-divide a cell with a different
border line type)


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How can I add borders inside a cell?

Thanks for the info.
From the formatting dialog box I saw a faded out box for inside borders but
it was inaccessable. I now wonder what that was for.

"Gord Dibben" wrote:

In a single cell the only sub-division you can have is a diagonal border line.

Note...........this is formatting only and does actually split the cell into
two.

You cannot split a cell.


Gord Dibben MS Excel MVP

On Wed, 21 Mar 2007 11:23:13 -0700, jagersmann
wrote:

How can I add borders inside a cell? (Sub-divide a cell with a different
border line type)



  #5   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default How can I add borders inside a cell?

The box for inside borders is usable when you select more than one cell for
formatting. It will draw borders between the cells.

"jagersmann" wrote:

Thanks for the info.
From the formatting dialog box I saw a faded out box for inside borders but
it was inaccessable. I now wonder what that was for.

"Gord Dibben" wrote:

In a single cell the only sub-division you can have is a diagonal border line.

Note...........this is formatting only and does actually split the cell into
two.

You cannot split a cell.


Gord Dibben MS Excel MVP

On Wed, 21 Mar 2007 11:23:13 -0700, jagersmann
wrote:

How can I add borders inside a cell? (Sub-divide a cell with a different
border line type)





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How can I add borders inside a cell?

That's the one!

Thanks for the jump-in Tom.

Never know when I could get back.


Gord

On Wed, 21 Mar 2007 13:18:06 -0700, Tom wrote:

The box for inside borders is usable when you select more than one cell for
formatting. It will draw borders between the cells.

"jagersmann" wrote:

Thanks for the info.
From the formatting dialog box I saw a faded out box for inside borders but
it was inaccessable. I now wonder what that was for.

"Gord Dibben" wrote:

In a single cell the only sub-division you can have is a diagonal border line.

Note...........this is formatting only and does actually split the cell into
two.

You cannot split a cell.


Gord Dibben MS Excel MVP

On Wed, 21 Mar 2007 11:23:13 -0700, jagersmann
wrote:

How can I add borders inside a cell? (Sub-divide a cell with a different
border line type)



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
Cell Borders SJT Excel Discussion (Misc queries) 1 August 11th 06 12:16 AM
add inside borders Reney Excel Discussion (Misc queries) 3 November 11th 05 03:53 PM
Why data in cell doesn't stay aligned with cell borders when prin. Danno Excel Discussion (Misc queries) 0 October 3rd 05 07:15 PM
Using a value from a cell inside a formula! marsupilami Excel Discussion (Misc queries) 5 August 24th 05 07:06 AM
CELL BORDERS C. BROWN Excel Discussion (Misc queries) 0 August 19th 05 02:34 PM


All times are GMT +1. The time now is 12:44 AM.

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"