Tuesday, September 6, 2011

How to Insert a Diagonal Line in Excel Spreadsheet Cell


How do you make a diagonal strike through line in a Microsoft Excel spreadsheet cell? If you're using Excel 2007 go to the home tab where you'll see the Format Numbers options area. There is a drop-down box which may be currently displaying "date". Click the arrow and select "More number formats." You'll see a bunch of tabs on the top of the pop up display. Go to the "border" tab. Select the diagonal line. This will insert a diagonal line from the lower left hand to the upper right hand corner of a cell, creating a "strike-through" effect if you will. Easy eh?

2 comments:

  1. Hi Nick,

    I want to know if I can insert a diagonal line like the one above but only for the digit(s) in the cell.

    Appreciate your help.

    Thanks,
    sam

    ReplyDelete
    Replies
    1. Hi Sam,

      Just to clarify, you want to cross out only cells with digits or cross out the individual digits themselves?

      Thanks,
      Nick

      Delete

I'd love to hear from you!
-Nick