ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting Cells (https://www.excelbanter.com/excel-discussion-misc-queries/81901-formatting-cells.html)

PVE

Formatting Cells
 
I have a document with several different worksheets that are linked. I want
to modify one of the sheets, but no matter what I do, there is one column
that will not allow me to format. I have broken all links, cleared all info,
deleted the column, and when I click on FORMAT CELLS, nothing happens.
--
Thank you very much.
Paula

Kevin B

Formatting Cells
 
Could it be that the cells in that column are locked and worksheet protection
is on?

Click TOOLS in the menu, select PROTECTION and if the cascade menu displays
UNPROTECT then the worksheet is protected, select UNPROTECT. At that point
you may be asked to provide a password if a password has been assigned, if
not, you should be able to format the cells.
--
Kevin Backmann


"PVE" wrote:

I have a document with several different worksheets that are linked. I want
to modify one of the sheets, but no matter what I do, there is one column
that will not allow me to format. I have broken all links, cleared all info,
deleted the column, and when I click on FORMAT CELLS, nothing happens.
--
Thank you very much.
Paula



All times are GMT +1. The time now is 04:22 AM.

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