Removed column and now formulas are corrupt.
Posted on 2013-02-06
I have an excel workbook that has 2 worksheets in it. one is a summary report, the other is a data page. the summary report uses the data on the data sheet to show numbers. the numbers are derived from formulas in the cells. I noticed on the data sheet that there was a blank colu,n between month and year so I tried to highlight it only to find that the year colu,n was merged with this blank column. I seperated the two columns then highlighted the blank one and chose deleter and to shift the cell to the left. once I did that and went back to my summary sheet all of my 250 formulas were showing #REF! and looking at them where there once was a rang of :
it now shows:
I can do a ctrlZ and put them back the way they were but is there a way for me to removed the merged column without breaking the reference to the data?