+ Reply to Thread
Results 1 to 2 of 2

How to prevent tables from shifting down when adding rows to other tables

  1. #1
    Registered User
    Join Date
    04-27-2020
    Location
    Raleigh, NC
    MS-Off Ver
    Microsoft Office for MAC
    Posts
    1

    Exclamation How to prevent tables from shifting down when adding rows to other tables

    Hello all,

    I am working on a new project for my company and it involves creating a pdf form with multiple drop down boxes. I am currently building the form in excel and have the basic form layout all set up in a sheet. I am now working on a separate sheet within the same workbook that will contain all of the data required for the drop down list options that users can select from. I started to build my tables so that I can use Data Validation and create a list in my pdf that can be clicked on and provide easy drop down options for the user to select from instead of them having to enter it in manually. I have created multiple lists in several columns with ten or so rows below them. The problem is that if I forgot to add something to one of the lists at the top and need to add a row, it then adds a row to all of the lists within the sheet and creates blank cells within my data. Is there a way to make it so that if one list requires additional cells to be added that it wont affect others lists. I have tried to google this but only can find things about locking, freezing, and grouping cells. I don't want to lock the cells and prevent future users from being able to edit the lists, but want the data within the list to not move. In addition, if future users need to add cells (for example 20 new states that we operate in) to a current drop down list, will the range of data be updated automatically without affecting other lists around or below it?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: How to prevent tables from shifting down when adding rows to other tables

    Hi just sun guy and welcome to the forum,

    It sounds like you need to put blank columns between your lists so adding a row in one list doesn't affect the others. I hope that makes sense, if I've understood the problem.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. Formulas changing when adding/removing rows from tables
    By jhuvba in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-09-2018, 10:24 AM
  2. Adding and Deleting Columns/Rows to Multiple tables
    By TrundleTheGreat in forum Excel General
    Replies: 8
    Last Post: 01-10-2018, 12:45 PM
  3. Replies: 3
    Last Post: 07-22-2016, 06:57 PM
  4. [SOLVED] Updating 2 tables by shifting down rows based upon the other table
    By chall04 in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 06-17-2013, 05:30 AM
  5. Replies: 4
    Last Post: 04-24-2013, 04:58 AM
  6. Replies: 6
    Last Post: 06-18-2012, 01:26 AM
  7. Adding multiple rows in different tables of the same worksheet
    By JMarchante in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2010, 07:42 AM

Tags for this Thread

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