+ Reply to Thread
Results 1 to 4 of 4

Can't select the right shape to use as the basis for alignment

  1. #1
    Forum Contributor
    Join Date
    11-15-2012
    Location
    New York City
    MS-Off Ver
    Excel 2010
    Posts
    245

    Can't select the right shape to use as the basis for alignment

    I have a set of identical shapes in multiple rows. I have set up the horizontal spacing for the top row, and I want to have the columns underneath each member of the top row aligned into a consistent columnar manner. My trouble is, when I select the relevant shapes, they all align to the leftmost shape. With other drawing programs the first shape (generally) becomes the anchor, and the other shapes align to it. Excel typically works in one of two ways - if you Shift-Click the first shape selected is the anchor, and if you Ctrl-CLick, the last shape selected becomes the anchor.

    Powerpoint seems neither to be consistent (if I ALign Right, it's still to the right-edge of the leftmost shape), nor to document how it chooses. (Typical Microsoft, I've found).

    Can anyone tell me how Powerpoint picks the anchor shape?

    Tony

    PS Yes - I can set up all sorts of guide-lines and simply snap to them, but then this makes the Align-To capability somewhat irrelevant.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,592

    Re: Can't select the right shape to use as the basis for alignment

    Excel is not a program that is meant for this like PowerPoint or Word
    In Excel you have to tell it where to place what and waht to do with it, with everything and with shapes it's the same, you allign a shape accorign to a cell, column, row, and then also there's the size, scaling etc.
    If you allign a first sphape to let's say Cell C 2 then the next shape if below this one then it will the the top of this shape plus its height and the left will be the same and so on.
    I use macros to allign my shapes and then of course you need to increase the row heights accordingly.
    For a shape's height you can also use a row height.
    Excel is not a desktop publishing application so it works in entirely another manner
    Hope I have ben able to explain the idea
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    11-15-2012
    Location
    New York City
    MS-Off Ver
    Excel 2010
    Posts
    245

    Re: Can't select the right shape to use as the basis for alignment

    Thanks, Hans,

    My question is about PowerPoint. Excel works just fine.

    I'm trying to align shapes on a slide. The problem is that the basis for alignment is the leftmost shape rather than the first or last shape selected.

    I posted on the Excel Forum because the quality of support here is so good. I tried to post on a PowerPoint part of the forum, but I may have missed - sorry.

    I'll see if I can make a dummy slide to show what I mean.

    Thanks,

    Tony

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,592

    Re: Can't select the right shape to use as the basis for alignment

    Okay, clear

+ 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] Select data on basis multiple vertical criteria
    By sanjuss2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-27-2021, 12:52 PM
  2. Replies: 0
    Last Post: 10-01-2020, 05:40 AM
  3. [SOLVED] Show shape on cell select, Hide shape when cell is deselected
    By brendangroff in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-25-2016, 03:36 PM
  4. [SOLVED] A macro after setting onaction for a shape that will select the shape.
    By vonRobbo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2014, 11:34 PM
  5. Select a shape based on a cell value and update the shape when value changes
    By BigAl99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2013, 12:06 PM
  6. Excel 2010 - shape alignment problem
    By OllieB in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-14-2013, 08:10 AM
  7. [SOLVED] how to select a shape
    By EXCEL NEWS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-11-2006, 10:35 PM

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