Content,Format,Style of Table after resize

[ionelz]

I am New to the Forum.

On the Bottom Right of Table, I am dragging the corner up to resize the table numbers of rows because of unused rows in table
But all the the Table Format/Style remain on spreadsheet
Also, formulas from cell table remain on spreadsheet too.
I need to manually clean the spreadsheet bellow table
How to fix this ? Why the format/style/cell content remain on spreadsheet and is not applied only to table ?

 

[sureshxcell]

Hi,

Try ALT + E + F to remove the format manually below the table
Try ALT + E + A + A to clear all the contents along with the format

 

[sureshxcell]

Sorry for the Typo

It's ALT + E + A + F

 

[ionelz]

My question is : after resize of table, format/style/content(formulas with error message) remain bellow table

 

[sureshxcell]

Could you please tell which version of office you are using?

 

[ionelz]

2016

 

[ionelz]

If I remove all Formats from Table and Spreadsheet, apply new style to Table, resize up and down, bellow Table remain Table format/style,errors from table cells formulas...

 

[sureshxcell]

Try

1. Convert the table to range
2. Select the unwanted rows and press ALT + E + A + F
3. Press Ctrl + T to get back your table.