Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default I would like text to overlap adjacent cell(s)

What if you leave A1 Empty and C1 Empty and Write a long string of text in B1 and Center align it? Can you make the Text appear in A1 and C1. (I'm trying to make a gradient of colors across several cells and I want the text to be over multiple cells but I can not merge them.)


On Friday, August 14, 2009 at 11:44:11 AM UTC-5, Dave Peterson wrote:
If you have a long string in A1 and B1 is empty, then the text in A1 will
overlap into B1 -- as long as A1 isn't formatted to wrap text.

Mike wrote:

I would like text to overlap adjacent cell(s).

How can I select that attribute?


--

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
Total based on text dependancy + number value in adjacent cell EAE Excel Discussion (Misc queries) 4 January 24th 08 04:31 PM
text won't extend to adjacent cell ladymjl Excel Discussion (Misc queries) 2 August 3rd 07 10:00 PM
How can I give text a numerical value in adjacent cell? CT1974 Excel Worksheet Functions 5 May 22nd 07 09:41 AM
Help: Using text from an adjacent cell in a vlookup cyberbrewer Excel Worksheet Functions 4 February 12th 07 05:22 AM
display text in one cell as a number in an adjacent cell in excel Denno New Users to Excel 1 November 16th 06 05:13 PM


All times are GMT +1. The time now is 10:24 AM.

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"