• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Create Diagonal Lines in a Cell in an Excel Spreadsheet

How to Create Diagonal Lines in a Cell in an Excel Spreadsheet

By: Diana V. Faustmann
  • Share
  • Share on Facebook

A single diagonal line within a Microsoft Excel table cell communicates that the cell has two values or no information. Two diagonal lines mark outdated information with an X. Use one of three options to create these lines: a border format, cell style or line graphic.

Checking financial data
Unlike diagonal borders, drawn lines require manual readjustment when cell sizes change.
credit: Rudyanto Wijaya/iStock/Getty Images

Format an Individual Cell

Click the cell and in the Cells group of the "Home" tab, choose the "Format" button, followed "Format Cells." On the subsequent screen, click the "Border" tab. Depending on the slash direction you want, pick one of the two diagonal border buttons available under Border. Then, click "OK" to apply it.

Create a New Cell Style

Place your cursor in a blank cell and then navigate to the Styles group on the Home tab. Click the "Cell Styles" button and choose "New Cell Style." In the subsequent screen, name your new style -- for example, SlashLeft or SlashRight -- and then click "Format." Select the "Border" tab and click either of the two diagonal border buttons under Border. Then, click "OK." To apply the slash afterward, simply click the "Cell Styles" button, followed by your new style's name under Custom.

Video of the Day

Draw a Slash

Choose the "Insert" tab, followed by the "Shapes" button in the Illustrations group. Choose the "Straight Line" drawing option under Lines. Draw a diagonal line within a cell by clicking and dragging your cursor from one corner to another. Use the line's end points to adjust its length and angle.

Show Comments

Related Articles

How to Make Multiple Cells Bigger on Excel

How to Make Multiple Cells Bigger on Excel

Around The Home
Productivity
By: Kathryn Hatashita-Lee
How to Fill an Excel Cell With Two Colors

How to Fill an Excel Cell With Two Colors

Around The Home
Productivity
By: Aaron Parson
How to Split a Cell Diagonally

How to Split a Cell Diagonally

Around The Home
Productivity
By: Foye Robinson
How to Add Horizontally in Excel

How to Add Horizontally in Excel

Around The Home
Productivity
By: Neil Edwards
How to Remove Cell Padding in Word

How to Remove Cell Padding in Word

Around The Home
Productivity
By: Alan Sembera
Definition of Merge Cell

Definition of Merge Cell

Around The Home
Productivity
By: MichaelRyan
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.