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
LVL 7
gudii9Asked:
Who is Participating?
 
Bill PrewCommented:
Highlight the row, or cells, right click on them, select Format Cells, choose the Font tab, and enable the Strikethrough property.  Click Okay.


»bp
0
 
gudii9Author Commented:
select Format Cells, choose the Font tab

i could not find Font Tab under Format cells.

can you please put some screenshots
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Bill PrewCommented:
sshot-436.png
0
 
Martin LissConnect With a Mentor Older than dirtCommented:
In this worksheet select the cell(s) you want to cancel and press Ctrl+Shift+c . The gray color can be changed or eliminated.
29084446.xlsm
0
 
Martin LissOlder than dirtCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.