ExcelBanter - cant change the cell format it shows too many different cell form

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - cant change the cell format it shows too many different cell form (https://www.excelbanter.com/excel-worksheet-functions/125289-cant-change-cell-format-shows-too-many-different-cell-form.html)

not able to make changes in sheet

cant change the cell format it shows too many different cell form

my excel sheet table contains good amount of data, which is linked by
formule. now when i am trying to change the format like borders, inserting a
new column etc, it shows too many different file formats. how to tackle it?

All times are GMT +1. The time now is 09:19 PM.