Click Yes when Excel prompts you with ‘Do you want to convert the table to a normal range?’ and the table will revert to being a regular range—but with its attractive formatting intact. 4.