ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cell outlines missing (https://www.excelbanter.com/excel-programming/312642-cell-outlines-missing.html)

josh

Cell outlines missing
 
On a worksheet containing data in a list, the text data in one cell is
missing all four (top, bottom, left & right) outlines. The omission is
preserved if the cell is copied.
What causes this and how is it remedied?



Norman Jones

Cell outlines missing
 
Hi Josh,

With the cell selected, click the toolbar Fill Color icon NoFill

Setting a background cell color hides the cell's gridline surround.
..
---
Regards,
Norman



"josh" wrote in message
...
On a worksheet containing data in a list, the text data in one cell is
missing all four (top, bottom, left & right) outlines. The omission is
preserved if the cell is copied.
What causes this and how is it remedied?




Debra Dalgleish

Cell outlines missing
 
The cell may have a white fill colour. To fix it:

Select the cell
Click the dropdown arrow to the right of the Fill Color button
on the Formatting toolbar
Click on 'No Fill'

josh wrote:
On a worksheet containing data in a list, the text data in one cell is
missing all four (top, bottom, left & right) outlines. The omission is
preserved if the cell is copied.
What causes this and how is it remedied?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 02:06 PM.

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