ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i get the red x out of a cell (https://www.excelbanter.com/excel-discussion-misc-queries/122332-how-do-i-get-red-x-out-cell.html)

Layla

how do i get the red x out of a cell
 
Tried everything - it will not delete even with clear contents. Someone put
it there in my spreadsheet and I dont' know what it is or where it came from.

Dave F

how do i get the red x out of a cell
 
Perhaps conditional formatting is applied.

Select the cell, then go to Format--Conditional formatting and see if any
conditional formatting is applied to the cell.

If so, delete the formatting conditions, click OK and see if the red x
disappears.

Dave
--
Brevity is the soul of wit.


"Layla" wrote:

Tried everything - it will not delete even with clear contents. Someone put
it there in my spreadsheet and I dont' know what it is or where it came from.


CLR

how do i get the red x out of a cell
 
Try mousing over it and if the cursor changes shape, then right-click and CUT

Vaya con Dios,
Chuck, CABGx3



"Layla" wrote:

Tried everything - it will not delete even with clear contents. Someone put
it there in my spreadsheet and I dont' know what it is or where it came from.



All times are GMT +1. The time now is 05:08 PM.

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