ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Bordering in Excell (https://www.excelbanter.com/excel-discussion-misc-queries/215070-bordering-excell.html)

olrjr

Bordering in Excell
 
I have been working on a spread (text only) sheet and for the life of me I
can't get the borders to cover the few remaining cells that seem to have no
borders. I have tried everything; from trying to cut and past borders, to
using the border tool. No matter what I do, it seems that I can't close the
borders around certain cells. Can someone out there help me with this
problem. It is driving me crazy and I am under a deadline to get this project
completed.

Thanks

FSt1

Bordering in Excell
 
hi
if the text overlaps the cell, the right border will disappear. try widening
the problems cells.

Regards
FSt1

"olrjr" wrote:

I have been working on a spread (text only) sheet and for the life of me I
can't get the borders to cover the few remaining cells that seem to have no
borders. I have tried everything; from trying to cut and past borders, to
using the border tool. No matter what I do, it seems that I can't close the
borders around certain cells. Can someone out there help me with this
problem. It is driving me crazy and I am under a deadline to get this project
completed.

Thanks


Ken Johnson

Bordering in Excell
 
On Jan 1, 9:36*am, olrjr wrote:
I have been working on a spread (text only) sheet and for the life of me I
can't get the borders to cover the few remaining cells that seem to have no
borders. I have tried everything; from trying to cut and past borders, to
using the border tool. No matter what I do, it seems that I can't close the
borders around certain cells. Can someone out there help me *with this
problem. It is driving me crazy and I am under a deadline to get this project
completed.

Thanks


One possibility is a forgotten Conditional Format is over-riding the
borders you are applying. Select a stubborn cell and go Format|
Conditional Formatting... to see if this is the cause of the
disappearing borders.

Ken Johnson


All times are GMT +1. The time now is 10:56 PM.

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