I am hoping someone can help me. I am working in a spreadsheet that has 2
freeze pains and numbers and some formulas. For some reason, Excel will not
allow me to insert a new column. When I try this is the message that I get:

'To prevent possible loss of data, Microsoft Excel cannot shift nonblank
cells off the worksheet. Try to locate the nonblank cells by pressing
CTRL &END, and delete or clear all in cells between the last cell and the end
of your data. Then select cell A1 and save your workbook to reset the last
cell used.'

Then it says; 'Or you can move the data to a new location and try again'.