Dear All
Normally if cell text exceeds its width it overflows to adjacent cell if it is empty.
is there a way (not VBA) to make it overflow to adjacent cell with value of =""?
I don not want to change the size of the cell
Thank you
Dear All
Normally if cell text exceeds its width it overflows to adjacent cell if it is empty.
is there a way (not VBA) to make it overflow to adjacent cell with value of =""?
I don not want to change the size of the cell
Thank you
GUURE
Instead of picture if you attach your sample file with required result its more helpful.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
dear Avk
a workbook is attached with desired reault
thank you for your time
If there is anything at all in the adjacent cell, it will not overlap
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Text will not spill over to the adjacent cell if that cell contains anything.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
you can try with Alt H O H Ok then Alt H W
Thank you all for your help.
you can try with Alt H O H Ok=(Enter) then Alt H W
altHOHOKaltHW.jpg
edit: seems like dups but it is notI didn't saw latest posts except Fords post
Last edited by sandy666; 03-31-2018 at 02:31 AM.
it this is not what you want could you show what you want to achieve?
example.jpg
maybe you tryin' something like this?
yellow.jpg
with any value in yellow cell, but it doesn't work![]()
Last edited by sandy666; 03-31-2018 at 02:43 AM.
dear Sandy
thank you for this
from your picture, cell f3 text overflows to adjacent cells because they are empty. for example suppose G5 contanis =""
I wanted F5 text to overflows to G5 and and other right adjacest cells like F3 text overflows to G3 and other right adjacent cells.
refresh thread and see next picture
btw. G5 is totally blank (no any ="")!
and don't quote whole post if it is not really necessary
maybe like this one
overlap.jpg
Last edited by sandy666; 03-31-2018 at 03:08 AM.
my question is
if G5 is ="" would F5 overflows to it?
The answer to that question is no.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
it depends on what you want to achieve
answer is Yes and No
for fun = Yes
for standard use = No
red.jpg
I can change red text to =""
Last edited by sandy666; 03-31-2018 at 03:22 AM.
Text will NOT overflow on an adjacent cell containing anything at all, no matter what you do
Ford is right. I should say that I can visualize this case(for fun)
ok, well noted.
would you attach this as workbook instead of picture?
Sure, but it doesn't make any sense for normal use with data. Excel is not a Word/Publisher/Visio etc... so you will only waste your time![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks