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
Post a Comment