My Excel 2010 Paste Options have Disappeared
Posted on 2012-03-16
My paste options have disappeared in Excel 2010. My laptop crashed earlier this week. I just finished re-installing Windows 7, clean installation. I re-installed Office 2010 and started working on a simple spreadsheet from the default spreadsheet. I started a column for numbering the lines. Instead of fill, I just started the column with 1, =1+A1 on the next line and then I normally just copy the formula down as far as I need to. But, when I paste, the only option to paste is “Keep Text Only”. Normally there are a dozen options. I read some threads, tried the registry change, tried the reset to defaults, but I still did not have paste options. So, I did an Office repair. I opened that spreadsheet this morning, tried copy and it worked, for a while. I can no longer paste formulas in this spreadsheet. I tried a default spreadsheet, but paste does not work. I tried an old legacy spreadsheet thinking there may be something I did to the spreadsheet, but paste does not work on the legacy spreadsheet either. Our customizations include font, template location, default save location and some quick access bar changes. I did not have this problem before the crash. I will greatly appreciate any help you can give me! I am trying to assemble tax information! Thanks!