ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't format cell (https://www.excelbanter.com/excel-discussion-misc-queries/115028-cant-format-cell.html)

Larissa25

Can't format cell
 
Trying to reformat a cell on an Excel worksheet, but the Format cell window
won't open up. It won't appear on any option (from right-click menu, from the
Format -- Cell menu, by clicking on the borders icons, nothing). An adjacent
cell behaves normally, but this group of cells doesn't. File is not
read-only, and it is not protected. No error message appears; nothing happens
at all. Any ideas? Thanks in advance.

JLGWhiz

Can't format cell
 
It has some kind of protection on it. Maybe the other cells work because
they have been excepted from the protection.

"Larissa25" wrote:

Trying to reformat a cell on an Excel worksheet, but the Format cell window
won't open up. It won't appear on any option (from right-click menu, from the
Format -- Cell menu, by clicking on the borders icons, nothing). An adjacent
cell behaves normally, but this group of cells doesn't. File is not
read-only, and it is not protected. No error message appears; nothing happens
at all. Any ideas? Thanks in advance.


Jim Rech

Can't format cell
 
and it is not protected

So Tools, Protection, Unprotect Sheet doesn't help?

--
Jim
"Larissa25" wrote in message
...
| Trying to reformat a cell on an Excel worksheet, but the Format cell
window
| won't open up. It won't appear on any option (from right-click menu, from
the
| Format -- Cell menu, by clicking on the borders icons, nothing). An
adjacent
| cell behaves normally, but this group of cells doesn't. File is not
| read-only, and it is not protected. No error message appears; nothing
happens
| at all. Any ideas? Thanks in advance.




All times are GMT +1. The time now is 06:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com