Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Forrest
 
Posts: n/a
Default how can I split a single cell diagonally in Excel 2000

Anyone out there know a way to split a single excel cell diagonally in order
to have it contain 2 pieces of information?
  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

Forrest,

As far as I know, you can not split a cell diagonally so that it can contain
2 pieces of information. However, you can merge cells which might give you
the effect that you want. To do so, go to the standard toolbar and hit
Format - Cells - Alignment Tab - Text Control and work with the merged
cells option.

----
Regards,
John Mansfield
http://www.pdbook.com

"Forrest" wrote:

Anyone out there know a way to split a single excel cell diagonally in order
to have it contain 2 pieces of information?

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

First, try not to do it. It gets more difficult to do stuff based on what's in
the top left corner vs what's in the bottom right corner.

But when I have to do this (and this looks awful!), I type my first value,
alt-enter, some spaces and the second value.

Add a diagonal border and with a little fiddling, it might pass.

Forrest wrote:

Anyone out there know a way to split a single excel cell diagonally in order
to have it contain 2 pieces of information?


--

Dave Peterson
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
In excel, I seem to be "locked" on a cell and unable to click off. Bubba Junie Excel Discussion (Misc queries) 7 May 1st 06 07:46 AM
Excel 2000 crashes when changing fonts. Ross Excel Discussion (Misc queries) 3 January 22nd 05 12:54 AM
How do I copy Tab into a single cell in Excel? bryantebbe Excel Discussion (Misc queries) 3 January 20th 05 12:58 AM
how to add two data validation lists to a single cell? Mike Peter Excel Worksheet Functions 1 December 8th 04 08:22 PM


All times are GMT +1. The time now is 11:55 PM.

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

About Us

"It's about Microsoft Excel"