Lost Column B

I have a workbook with eight worksheets on it (Excel 2000) and each worksheet covers budget / expenses from 2005 to 2012.

The columns on each worksheet are from A to L. Since column B only indicates the cheque numbers which includes only 4 cheques per year I decided to eliminate column B after transferring the info into another column.

However the columns now are A, C, D etc and there is no column B which makes the formulas in the rest worksheet wrong. I thought by deleting column B the remaining columns will re number to A, B, C, etc.

I saved to file and re open but still there is no column B. Is there a way to re number the columns so I have column B back?

Lo there,

I think you may have column B hidden by mistake. You are right in saying if you deleted column B then column C will be renamed Column B (which in itself may cause formulas to not work properly especially if you are using anchors in the formula).
What you can try is to highlight columns A to C and then right click and Unhide Columns.

hope this helps.
Fidd$

Thanks for the tip Fidd$

Actually doing what you said I discovered that column B (which I had delete) was still there, don’t know why.

I deleted again column B and now all column re numbered properly

Thanks again for the help