asked on

how to cross a line in excel row

how to cross excel spreadsheet row.

Lets say i have 10 rows in excel spreadsheet called Proposals.

Lets say 7th proposal cancelled due to discussion with client.(if you see in attachment row 7 "Implement" in yellow crossed in one of other document...i want to do same way..not sure how to do)

how to put one line crossing it still people should see it in background.

please advise
CrossRow.png

Bill Prew

Highlight the row, or cells, right click on them, select Format Cells, choose the Font tab, and enable the Strikethrough property. Click Okay.

»bp

gudii9

ASKER

select Format Cells, choose the Font tab

i could not find Font Tab under Format cells.

can you please put some screenshots

Bill Prew

ASKER CERTIFIED SOLUTION

Bill Prew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Martin Liss

I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017