+ Reply to Thread
Results 1 to 4 of 4

how to copy table & arrows so arrows stay in same place?

  1. #1
    Forum Contributor
    Join Date
    10-05-2016
    Location
    orange, ca
    MS-Off Ver
    0365 2209
    Posts
    144

    how to copy table & arrows so arrows stay in same place?

    Hello everyone

    Hope everyone is having a good day. I made some tables and draw arrows and inserted text. When I copy the table to another place, the arrows don't follow and stay in same place

    In the provided sample lets say I want to copy the table on the left to below the table on the right.

    Is there a way to copy or some other method so the arrows stay in the same place with the table?
    Attached Files Attached Files
    Last edited by lar9149; 02-02-2023 at 11:56 PM.

  2. #2
    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,984

    Re: how to copy table & arrows so arrows stay in same place?

    1. Set all relevant columns to a width of 3.57.

    2. Select A1:AK21.

    3. CTRL-C, CTRL-V.

    Is that what you mean??
    Attached Files Attached Files
    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

  3. #3
    Forum Contributor
    Join Date
    10-05-2016
    Location
    orange, ca
    MS-Off Ver
    0365 2209
    Posts
    144

    Re: how to copy table & arrows so arrows stay in same place?

    Quote Originally Posted by Glenn Kennedy View Post
    1. Set all relevant columns to a width of 3.57.

    2. Select A1:AK21.

    3. CTRL-C, CTRL-V.

    Is that what you mean??
    Sorry for not explaining as well.

    What I meant is select B11 to Q19. Copy and paste directly under table that occupies S10 to AH18.

    The table copies but not the arrows.

  4. #4
    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,984

    Re: how to copy table & arrows so arrows stay in same place?

    They won't copy. You have to select an area that includes both ends of all arrows.

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

+ 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] Remove selected table filter arrows
    By GregM56 in forum Excel General
    Replies: 3
    Last Post: 07-02-2019, 04:45 PM
  2. Hiding table filter arrows
    By torch0395 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-29-2018, 02:09 PM
  3. Movement arrows required for league table
    By Muzza86 in forum Excel General
    Replies: 5
    Last Post: 05-02-2017, 04:08 AM
  4. Connect Cells with Arrows in a Table
    By Faustocruz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2013, 07:03 PM
  5. [SOLVED] Add Up/Down Arrows to a Table to increases/decreases in Variances
    By Cortlyn in forum Excel General
    Replies: 2
    Last Post: 05-14-2013, 04:36 PM
  6. Remove Table Filter Arrows on some Columns
    By lipster in forum Excel General
    Replies: 1
    Last Post: 02-14-2010, 04:16 PM
  7. Autofilter arrows on specific columns in table
    By rgarber1950 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2008, 03:49 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