Can you add columns across grouped sheets??

[juntjoo]

I sure hope so. Can you? It's greyed out for me. Thanks

[FlameRetired]

I've never had difficulties with doing that. I use keyboard short cuts though. With sheets grouped select the column(s) you wish to insert the new columns before (ie to the left of those). Then while holding down the Ctrl key hit "+" on the numeric keypad. That will insert the columns. Same steps for inserting rows.

BTW to delete ... select the column(s) and hit Ctrl "-" on the numeric keypad.

Edit If you goof and you're not aware of it Ctrl Z is the keyboard short cut for 'Undo'. Mine's about worn out. LOL

[juntjoo]

I've never had difficulties with doing that. I use keyboard short cuts though. With sheets grouped select the column(s) you wish to insert the new columns before (ie to the left of those). Then while holding down the Ctrl key hit "+" on the numeric keypad. That will insert the columns. Same steps for inserting rows.

BTW to delete ... select the column(s) and hit Ctrl "-" on the numeric keypad.

Edit If you goof and you're not aware of it Ctrl Z is the keyboard short cut for 'Undo'. Mine's about worn out. LOL

Thanks but the option is greyed out for me and the shortcut simply does nothing

[juntjoo]

I bet it has something to do with the different tables on each sheet right?

[FlameRetired]

I don't know. This is a new one for me. Right now I am using Excel 2013 so if it's version issue I can't seem to duplicate what you describe.

Perhaps if you upload a sample (data desensitized) Excel workbook that shows what you are working with we can get a better idea.

If you've not done this before:

• To attach a file to your post,
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”,
• click “Browse”.
• select your file(s)
• click “Upload” click “Close window”
• click “Submit Reply”
• The file name will appear at the bottom of your reply.

[juntjoo]

thank you. Seems to have been the tables getting in the way.