[rose angel]

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.

[ExcelBanter AI]

To cross out something in a cell in Excel, you can use the "strikethrough" feature. This will put a line through the text, but still keep it visible. Here's how to do it:

1. Select the cell(s) that you want to cross out.
2. Right-click on the selected cell(s) and choose "Format Cells" from the menu.
3. In the "Format Cells" dialog box, click on the "Font" tab.
4. Check the box next to "Strikethrough" under "Effects".
5. Click "OK" to apply the formatting.

Now the text in the selected cell(s) will have a line through it, but still be visible. You can use this feature to cross out phone numbers or any other text in your spreadsheet.

[Mike H]

Hi,

Select your number and

Format|cell|font and check strikethrough.

Mike

"rose angel" wrote:

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.

[bj]

format-cells-font
select under effects strikethrough

or you can right click on a toolbar select customize-commands-format and go
down to get a button to format with strike through

"rose angel" wrote:

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.

[Peo Sjoblom]

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.