View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default how do I cross out something in a cell to keep it visible

Format the font using strike through


another way

Put a text box in the cell, type in hyphens
like -----------------------------

right click the border of the text box and select format text box, select
colors and lines and
set transparency to 100%. Of course it will be harder to edit the cell



--
Regards,

Peo Sjoblom




"rose angel" <rose wrote in message
...
I am using a spreadsheet with phone numbers in it and need to cross the
number out but leave it visible. How do I do this.