+ Reply to Thread
Results 1 to 9 of 9

Why doesn't the text stay when editing text in a shape after clicking off the shape.

  1. #1
    Registered User
    Join Date
    06-06-2022
    Location
    Virginia
    MS-Off Ver
    Excel 365
    Posts
    8

    Why doesn't the text stay when editing text in a shape after clicking off the shape.

    So i am testing out with shapes in excel and instead of adding a text box near the shape there is a edit text option when right clicking on a shape that allows you to write text within a shape or further down. When i click a way it disappears. Is it supposed to do this or is there a setting to change this?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,531

    Re: Why doesn't the text stay when editing text in a shape after clicking off the shape.

    When i click a way it disappears.
    What is the "it" you mean here? The shape, or the text?

    When you click elsewhere the focus changes so you no longer see a box for text within the shape. However, if you have entered text, the text stays there. Can you be more specific about what you are seeing, step by step?

    After selecting a shape:
    shape1.jpg

    After right-clicking and selecting Edit Text, typing in text, and setting font color to Automatic:
    shape2.jpg

    After clicking on a cell, shape becomes de-selected, text remains:
    shape3.jpg
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    06-06-2022
    Location
    Virginia
    MS-Off Ver
    Excel 365
    Posts
    8

    Re: Why doesn't the text stay when editing text in a shape after clicking off the shape.

    Its just the text. I can write text in the shape, hit enter, and it stays there. However, if I push that text down so that its out of the shape and over cells, when I click off of it I can no longer see the text that was pushed down outside the cell. I wasn't sure if there is a way to make it the text visible even if its past the shape itself.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,531

    Re: Why doesn't the text stay when editing text in a shape after clicking off the shape.

    I have never seen a shape where you can add text, and then move the text outside the shape. Please attach a file with an example. See yellow banner at the top of the page.

  5. #5
    Registered User
    Join Date
    06-06-2022
    Location
    Virginia
    MS-Off Ver
    Excel 365
    Posts
    8

    Re: Why doesn't the text stay when editing text in a shape after clicking off the shape.

    Hey thanks for the response was wondering how you post an image of an excel worksheet like you did above. I did read the yellow banner and followed those directions however It seems like it only allows me to post a download of my excel file?

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Why doesn't the text stay when editing text in a shape after clicking off the shape.

    An image is useless. Please upload an EXCEL file.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  7. #7
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Why doesn't the text stay when editing text in a shape after clicking off the shape.

    It might be that you are clicking out of the edit field rather then pressing Enter before de-selecting the Shape.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  8. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,531

    Re: Why doesn't the text stay when editing text in a shape after clicking off the shape.

    Quote Originally Posted by Cyberdyne037 View Post
    Hey thanks for the response was wondering how you post an image of an excel worksheet like you did above. I did read the yellow banner and followed those directions however It seems like it only allows me to post a download of my excel file?
    In your case we need the actual file so we can see how it works.

    Just to answer your question, to attach an image, first click Go Advanced under your edit box. Then click on the point in your post where you want the image to go, then press the image icon and attach your image.

  9. #9
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,158

    Re: Why doesn't the text stay when editing text in a shape after clicking off the shape.

    This time the answer in pictorial writing. In addition, in a language incomprehensible to you.
    Point 4 - "Allow text to overflow beyond the shape." Or something similar.

    Artik
    Attached Images Attached Images
    Last edited by Artik; 08-06-2022 at 07:32 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Selecting shape's text through another shape
    By X-tra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2017, 11:37 AM
  2. Replies: 1
    Last Post: 04-29-2013, 05:25 PM
  3. Problem with last line of text in text box shape.
    By MikeWV in forum Excel General
    Replies: 0
    Last Post: 07-03-2012, 05:33 PM
  4. Display text box when clicking a shape
    By ACap in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2012, 05:55 AM
  5. Shape size based on text in shape
    By mwc48910 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2011, 05:43 AM
  6. How to change shape text without selecting shape
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2009, 06:27 PM
  7. Retrieve Shape text when more than 255 characters inside shape
    By Wizz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2009, 10:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1