Share via

Excel Movable Boxes

Anonymous
2018-05-04T14:00:40+00:00

I am trying to set up 4 to 6 boxes of information, (4 columns wide and 20 rows), that I can grab, move and interchange. The boxes or groups of information exceed visual range and it helps to put 2 groups next to each other for comparison. Best case is to be able to pull group 5 over to replace say group 2 and all groups slide to the right. Flouting boxes.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

4 answers

Sort by: Most helpful
  1. Anonymous
    2018-05-04T15:33:24+00:00

    https://1drv.ms/x/s!AvA46mqnMeD0aRTEPT6vtHjK4RE

    This should be the link. Thanks for the help

    Was this answer helpful?

    0 comments No comments
  2. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-05-04T15:02:18+00:00

    I need to have a look on your workbook to provide you the solution specific to your problem.

    Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link? It will help me to give prompt and right solution.

    You can upload from Onedrive application on your computer.

    If you don't have this application,

    1. Login to https://onedrive.live.com/ utilizing the same Login ID and Password which you have used on this forum. (or use the installed Onedrive on your computer)
    2. Click Upload in the top OR drag and drop the file here.
    3. After uploading, right click the file and choose share.
    4. Optional but recommended - Uncheck the Allow Editing
    5. Click Get a Link.
    6. Copy the link and paste the link here.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2018-05-04T14:58:16+00:00

    Thank you for asking and no apology needed it is a complicated question. I have a set of data perimeters that will have different values and I need to have side by side for comparison. What I would like to see if possible is to have (example below) data 3 box be able to move where data 2 is and data 2 automatically slide to the right. Is there a way in excel to create a box that can move like that? 

    Data 1 Data 2 Data 3
    Sale
    Location
    Size in Sq Ft
    Feature
    Feature
    Feature

    Was this answer helpful?

    0 comments No comments
  4. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-05-04T14:04:34+00:00

    Thank you for posting this. The problem statement is not emerging. Could you describe what exact help is needed.

    My apologies for asking for the clarification.

    Was this answer helpful?

    0 comments No comments