Up until today, Excel worked fine and I was able to insert rows and columns, copy rows and columns and Insert Copied Cells, and format cells by selecting, right-clicking, and choosing Format Cells. Today I can't do any of those things. I have searched all over the internet and all I have found is people asking "is it a shared workbook?" or "is the sheet protected?" I'm not an Excel idiot so I assure you the answer to those questions is no. It happens if I open a brand new workbook or an existing one, if I copy and paste special values or just type new values in the cells. What could possibly be causing this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Can't format cells anymore in Excel 2007
- Thread starter sandyw654
- Start date
-
- Tags
- format cells
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Welcome to MrExcel.
Is the worksheet protected? Do you have any other workbooks open or Add-Ins installed?
Is the worksheet protected? Do you have any other workbooks open or Add-Ins installed?
Upvote
0
Excel Facts
Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
I have the same problem. A whole bunch of cells won't allow formatting either if I right click or if i go in through the Home tab. I have tried copying and pasting into a new sheet, I've protected and unprotected it...no luck.
Also how can I upload my excel sheet so you can look at it?
Also how can I upload my excel sheet so you can look at it?
Upvote
0
