Expand dynamic table on Mac (!)

%3CLINGO-SUB%20id%3D%22lingo-sub-1585578%22%20slang%3D%22en-US%22%3EExpand%20dynamic%20table%20on%20Mac%20(!)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585578%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20I'm%20new%20here%20and%20was%20hoping%20someone%20would%20be%20able%20to%20help%20me.%20I%20am%20working%20on%20my%20MacBook%20in%20Excel.%20I%20have%20a%20dynamic%20table%20that%20a%20colleague%20created%20with%20a%20certain%20color%20scheme%20that%20I%20would%20like%20to%20expand%20by%20adding%20new%20data%20below%3B%20as%20there%20is%20a%20big%20amount%20of%20data%20I%20pasted%20from%20another%20document%2C%20the%20table%20does%20not%20expand%20automatically%20where%20I%20pasted%20entire%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20a%20way%20how%20I%20can%20manually%20expand%20the%20same%20table%20on%20my%20Mac%20version%2016.34%20of%20excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20to%20anyone%20who%20takes%20the%20time%20to%20reply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1585578%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1585718%22%20slang%3D%22en-US%22%3ERe%3A%20Expand%20dynamic%20table%20on%20Mac%20(!)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585718%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F757828%22%20target%3D%22_blank%22%3E%40Kris77%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20if%20this%20works%20the%20same%20way%20in%20Mac%20with%20Windows%2C%20but%20it%20worths%20checking%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20usually%20a%20small%20mark%2Fedge%20on%20the%20cell%20where%20the%20table%20ends%20%5Bsee%20the%20highlighted%20section%20in%20the%20image%5D.%20You%20can%20actually%20drag%20this%20mark%20to%20cover%20all%20the%20new%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22wumolad_0-1597280604749.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212151iB33651A5ECACDB0A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22wumolad_0-1597280604749.png%22%20alt%3D%22wumolad_0-1597280604749.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20let%20me%20know%20if%20this%20is%20what%20you%20are%20referring%20to%20or%20if%20further%20clarification%20is%20required.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1587883%22%20slang%3D%22en-US%22%3ERe%3A%20Expand%20dynamic%20table%20on%20Mac%20(!)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587883%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F622486%22%20target%3D%22_blank%22%3E%40wumolad%3C%2FA%3E%26nbsp%3B%2C%20thanks%20for%20your%20reply!%3C%2FP%3E%3CP%3EThat%20is%20the%20answer%20that%20I%20found%20everywhere%20I%20looked.%20Although%20it%20did%20include%20the%20new%20data%20in%20the%20table%2C%20the%20formating%20of%20the%20original%20table%20was%20not%20continued.%20What%20eventually%20worked%20was%20creating%20a%20new%20table%20template%20with%20the%20exact%20same%20format%20as%20the%20original%20table%2C%20in%20addition%20to%20doing%20what%20you%20suggested.%20Even%20then%20a%20few%20things%20had%20to%20be%20adjusted%20manually.%20I%20wonder%20if%20there%20is%20an%20easier%20way%20to%20do%20this%2C%20where%20the%20original%20format%20is%20automatically%20continued%20when%20dragging%20down%20that%20small%20mark%20-%20but%20at%20least%20I%20got%20there%20eventually.%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20again%20and%20best%20wishes%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi everyone, I'm new here and was hoping someone would be able to help me. I am working on my MacBook in Excel. I have a dynamic table that a colleague created with a certain color scheme that I would like to expand by adding new data below; as there is a big amount of data I pasted from another document, the table does not expand automatically where I pasted entire columns.

 

Does anyone know a way how I can manually expand the same table on my Mac version 16.34 of excel?

 

Thanks in advance to anyone who takes the time to reply.

 

2 Replies
Highlighted

Hi @Kris77 

 

I am not if this works the same way in Mac with Windows, but it worths checking out.

 

There is usually a small mark/edge on the cell where the table ends [see the highlighted section in the image]. You can actually drag this mark to cover all the new data.

 

wumolad_0-1597280604749.png

 

Do let me know if this is what you are referring to or if further clarification is required.

 

Cheers

 

 

 

Highlighted

Hi @wumolad , thanks for your reply!

That is the answer that I found everywhere I looked. Although it did include the new data in the table, the formating of the original table was not continued. What eventually worked was creating a new table template with the exact same format as the original table, in addition to doing what you suggested. Even then a few things had to be adjusted manually. I wonder if there is an easier way to do this, where the original format is automatically continued when dragging down that small mark - but at least I got there eventually. 

thanks again and best wishes