SOLVED

How to delete the handle to change size of a table

%3CLINGO-SUB%20id%3D%22lingo-sub-1164033%22%20slang%3D%22en-US%22%3EHow%20to%20delete%20the%20handle%20to%20change%20size%20of%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1164033%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%26nbsp%3Bdelete%20the%20handle%20to%20change%20the%20size%20of%20the%20table%3F%20It's%20located%20in%20the%20lower%20right%20corner%20of%20a%20table.%26nbsp%3BI%20don't%20want%20to%20see%20that%20little%20handle%20when%20I%20paste%20the%20table%20to%20for%20example%20Word%20as%20an%20image.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards!%3C%2FP%3E%3CP%3EMagnus%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1164033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1164584%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20the%20handle%20to%20change%20size%20of%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1164584%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F551851%22%20target%3D%22_blank%22%3E%40magnussandberg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20little%20triangle%20is%20there%20to%20indicate%20that%20you%20have%20a%20structured%20table.%20Convert%20the%20table%20to%20a%20Range%20(on%20the%20Table%20ribbon)before%20copying%20it%20and%20pasting%20it%20as%20a%20picture%20in%20word.%20Then%20just%20don't%20save%20your%20workbook%20so%20that%20you%20retain%20the%20table%20properties.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-02-10%20at%2018.04.10.png%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F170118i77C48803E77E6D45%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20title%3D%22Screenshot%202020-02-10%20at%2018.04.10.png%22%20alt%3D%22Screenshot%202020-02-10%20at%2018.04.10.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1992312%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20the%20handle%20to%20change%20size%20of%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1992312%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThanks!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20was%20hoping%20for%20a%20more%20permanent%20solution%20%22smilie%22%3CBR%20%2F%3EWe%20have%20a%20lot%20of%20tables%20for%20our%20year-end%20annual%20report%2C%20so%20I%20came%20up%20with%20the%20work%20around%20to%20add%20one%20more%20empty%20column%20to%20the%20right%20in%20each%20table.%20And%20when%20we%20are%20snipping%20the%20table%20to%20insert%20in%20the%20annual%20report%20as%20an%20image%2C%20we%20don't%20include%20the%20last%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1992341%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20the%20handle%20to%20change%20size%20of%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1992341%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F551851%22%20target%3D%22_blank%22%3E%40magnussandberg%3C%2FA%3E%26nbsp%3BFair%20enough!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi!

 

Is it possible to delete the handle to change the size of the table? It's located in the lower right corner of a table. I don't want to see that little handle when I paste the table to for example Word as an image.

 

Best regards!

Magnus

3 Replies
best response confirmed by magnussandberg (New Contributor)
Solution

@magnussandberg 

The little triangle is there to indicate that you have a structured table. Convert the table to a Range (on the Table ribbon)before copying it and pasting it as a picture in word. Then just don't save your workbook so that you retain the table properties.

Screenshot 2020-02-10 at 18.04.10.png

@Riny_van_Eekelen Thanks!

I was hoping for a more permanent solution "smilie"
We have a lot of tables for our year-end annual report, so I came up with the work around to add one more empty column to the right in each table. And when we are snipping the table to insert in the annual report as an image, we don't include the last column.