+ Reply to Thread
Results 1 to 5 of 5

Format Shape

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    North Wales
    MS-Off Ver
    Excel 2016
    Posts
    4

    Format Shape

    I cannot find where to set the position of a shape
    I saw somewhere it was between size & properties
    Help please
    format Shape.png
    The attachment was taken from a Excel help site
    My viww has bo 'position' pane
    Last edited by AndyWC; 11-15-2018 at 12:06 PM. Reason: Added screen shot

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Format Shape

    Grab it and drag it wherever you like.
    Last edited by shg; 11-15-2018 at 01:08 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    North Wales
    MS-Off Ver
    Excel 2016
    Posts
    4

    Re: Format Shape

    Hi,
    I cannot find it - so cannot move it
    The attachment was a screenshot of an excel help site
    Andy

  4. #4
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Format Shape

    Do you mean you can't find the shape itself? That's it's lurking in some unknown distant corner of the worksheet? If so the FindShape macro in the attached spreadsheet will scroll the worksheet to each shape in turn.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by GeoffW283; 11-15-2018 at 10:02 PM.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Format Shape

    If you goto Find & Select>Selection Pane... you should get a pane with list of all the objects on the sheet.

    You can hide/show select your shape(s) from there.
    If posting code please use code tags, see here.

+ 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] with statement to format shape
    By esbencito in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2017, 03:23 AM
  2. Condtional Format a shape
    By rosshkerr in forum Excel General
    Replies: 2
    Last Post: 09-17-2015, 11:01 PM
  3. UK County map in excel shape format
    By ausrunas in forum Excel General
    Replies: 1
    Last Post: 09-11-2013, 05:00 PM
  4. format shape based on cell value
    By masoudij in forum Excel General
    Replies: 1
    Last Post: 06-29-2013, 03:38 PM
  5. How to format pasted Shape in PPoint?
    By mclarke2030 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2013, 03:18 PM
  6. Excel 2007 : Format Shape in buttons
    By soniarun in forum Excel General
    Replies: 19
    Last Post: 06-11-2008, 05:11 AM
  7. Conditional Format for a Shape
    By jpendegraft in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2007, 12:47 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