Posted on 2002-03-13
A general question:
What is the most efficient way of storing data in EXCEL?
ie what takes up most (disk) space in an EXCEL spreadsheet? - colour of cells? strings? formulae?
So if I have 2 cells that will contain the same data is it better to have cell1 hold the (eg) string and have cell2 containing a formula saying that it is the same as cell1? Or is it better to hold the string twice, once in each cell?
Is it better to have coloured formats for easy reading of data or does that take up space so it is more efficient (ie smaller disk space) to hold the data without coloured strings, borders etc but make th data harder to pick out?