Cell format

W

WildeWest

I have some cells that have somehow become like they are frozen. They are not
protected but when right click or select 'Format'>'Cell' nothing happens and
I can't format those certain cells. Can someone tell me how to fix this
please?
 
T

trip_to_tokyo

This is a possible work around for your problem.

Try going to elsewhere in the worksheet to a cell that is OK (ie not,
"frozen").

Copy that (blank) cell to the, "frozen" one.

The "frozen" one should now not be frozen and you should be able to format
as you like.

Please hit Yes if my comments have helped.

Thanks.
 
W

WildeWest

It is text and I can't access anything. It won't let me alter borders which
is what I am after in the first place. It won't even bring up any cell
properties.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format cells dialog 3
I can't format cells 2
Strikethough in cells? 4
Format Cells - Fill colour Help 11
format cell does not work 3
Can't Format Cells 4
Can't format cell 2
Sheet Protection 3

Top