I have a column with 100,00 records. Sometimes when placing a filter and sorting it runs long and times out. Does creating a table for that column help in process time? Another words it wont take as long to filter etc in table format as opposed to a plain column filter? Maybe the processing speed between a table and regular column doesnt matter? Thanks
Try this by selecting cell A1 and and press CTRL + End. It moves to last cell of the table.
Delete all the rows / columns after where your actual data ends. Save the file, close it, and reopen it.
If this is not working, copy your data to new workbook will help you.