Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
1. I enter data. Cells that have calculations dependant on that data sometimes self-fill, and other times I have to copy and paste. (Yes, I love <c>R, <c>D.) I'm not sure what is making the distinction. C = A + B. Sometimes C fills itself, sometimes I copy the cell above to continue the series in a column of C's.
2. I have one spreadsheet in particular that has a lot of macro-econ data, and the formats keep slipping off. I will format the whole column and save. Two days later I enter more data and have to do it again. Although the data from the prior session holds the format, unfilled cells do not. Seems like some sort of corruption, but each column needs varying format (index scaled numbers vs. percentages). I'm getting tired of re-setting them. Is this hopelessly corrupted and I have to reload into a clean, new workbook? Which leads me to.....
3. Is there any way to make sure that the default format for each entire new workbook is customized? Or does one really have to start each tab with setting that default format? I can't seem to find via Help any references to such a global setting. Read More