Forum Discussion

NathanRS's avatar
NathanRS
Copper Contributor
Dec 03, 2019
Solved

Excel Tables

I am working on creating a workbook with multiple tables on multiple worksheets.  On each worksheet, I have different tables above and below each other, as well as to the left and right or each other...
excel
  • NathanRS's avatar
    NathanRS
    Dec 05, 2019

    I figured it out.  If there is a table with more columns under the table to which i am attempting to add columns, it will not allow.NathanRS 

jukapil's avatar
jukapil
MCT
Dec 03, 2019

Greetings,

 

I feel that in 2013 and above version, it is easy. You just select any of the cell in a row in the table where you want to insert the row and just press short cut "Shift + Space" and then press "CTRL+Enter" key. It will work for you and insert the row in the selected table

 

Else you can right click on the cell in a table and select Insert and then Insert Row in Table Rows above.

 

Hope it works for you

 

Regards

Kapil Juneja

Resources