I have a large Excel workbook and it has gone through many iterations. Something has happened along the way that when I right click and then click on insert, the options to insert cells right or down are greyed out and I can only insert entire rows or columns. Does anyone know how I can fix this or how to prevent it in the future?