![]() |
Formatted Cell Changes Format When Information Is Entered
I am using a worksheet that someone else set up. When I enter information in
a cell the format changes. I clicked "Undo" and then checked the number and alignment format and both are set to general and there is an upper border to the cell. When I enter text the border disappears and the text is centered. I cannot determined what is causing this to happen. Also the person who set up the worksheet is no longer with the company. Thank you. |
Is it conditional formatting?
FormatConditional formatting If you select the cell then check the menu you may see the formatting in the dialog - you can delete from here too. cheers Simon "SundanceKidLudwig" wrote in message ... I am using a worksheet that someone else set up. When I enter information in a cell the format changes. I clicked "Undo" and then checked the number and alignment format and both are set to general and there is an upper border to the cell. When I enter text the border disappears and the text is centered. I cannot determined what is causing this to happen. Also the person who set up the worksheet is no longer with the company. Thank you. |
All times are GMT +1. The time now is 01:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com