Is there a way to shrink an Excel table to fit the data? -



Is there a way to shrink an Excel table to fit the data? -

i have excel table has several other places in spreadsheet using various reasons, , realized table had bad data. collected new data, , there fewer rows in new info set in previous table.

is there way can shrink table reflect new count of data?

not @ sure understand requirement i'm guessing want cut down size of tables/table without deleting entire rows in spreadsheet (because of content nowadays elsewhere in spreadsheet in same rows table data).

if so, simply select area of table deleted , press delete. if want remove formatting remains select angle icon shown @ extreme bottom right of table , drag suit.

i assuming (table) rows deleted contiguous block @ bottom of table.

excel excel-2013

Comments

Popular posts from this blog

java - How to set log4j.defaultInitOverride property to false in jboss server 6 -

c - GStreamer 1.0 1.4.5 RTSP Example Server sends 503 Service unavailable -

Using ajax with sonata admin list view pagination -