Forum Discussion
Excel show empty column but when downloaded/referred it's ignored
This is a simplified version of my sheet. It was one of the excel sheets that my ex-colleague created. Currently, there are two behaviours that I couldn't explain and it's confusing ...
Hi,
Excel assumes that columns with NO data at all are not part of the data set.
If you want to export as ,FY, then you need to put ="" in each cell in the first column. This is letting Excel know that these cells are blank but included in the data set.
Excel assumes that columns with NO data at all are not part of the data set.
If you want to export as ,FY, then you need to put ="" in each cell in the first column. This is letting Excel know that these cells are blank but included in the data set.
