+ Reply to Thread
Results 1 to 6 of 6

can't insert row in two tables

  1. #1
    Forum Contributor
    Join Date
    09-21-2015
    Location
    Alexandria
    MS-Off Ver
    2013
    Posts
    106

    can't insert row in two tables

    Hallo! I have 2 tables (part of a column each one), and the insert row is greyed out. How should i fix it?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor PaulSP8's Avatar
    Join Date
    11-21-2017
    Location
    Chorley, England
    MS-Off Ver
    2013 & 2021
    Posts
    437

    Re: can't insert row in two tables

    Right click on the Table itself, your "Insert" won't be greyed out on the Table menu.

    Each table will operate independently from the other so you'll need to do this on both tables if you want an extra row in each.

  3. #3
    Forum Contributor
    Join Date
    09-21-2015
    Location
    Alexandria
    MS-Off Ver
    2013
    Posts
    106

    Re: can't insert row in two tables

    how can it be done simultaneously?
    i want for example to add a row above row 8.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    82,890

    Re: can't insert row in two tables

    You'd need VBA, I think - would you like me to move the thread for you?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Contributor
    Join Date
    09-21-2015
    Location
    Alexandria
    MS-Off Ver
    2013
    Posts
    106

    Re: can't insert row in two tables

    No thank you

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    82,890

    Re: can't insert row in two tables

    OK - then you understand that it can't be done, yes?

+ 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. Insert> Pivot Table versus Insert> Recommended Pivot Tables
    By leaning in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-14-2018, 02:07 AM
  2. vba macro to insert into oracle tables
    By Khaled Diab in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-26-2014, 03:19 AM
  3. [SOLVED] Insert a row in 2 tables with VBA code
    By pezalmendra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2014, 09:00 AM
  4. insert into a table from multiple tables
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2013, 08:59 AM
  5. Insert rows in several tables : how to speed up ?
    By Adrian692 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2013, 02:10 PM
  6. How to insert tables?
    By all4excel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-26-2007, 06:32 AM
  7. Tables tab under the Insert tab
    By Chuck Divine in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-29-2005, 07: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