how to put a slash through a cell in excel

How to Add a Slash (/)/Diagonal Line through Cell in Excel

By Jessica Young
AD

Accented or special characters, like the slash (/) can be essential in Excel for indicating a time duration, setting ratios, or even adding style to text. So, how do you go about putting a slash through a cell in Excel? It's surprisingly simple once you know how. Let's dive in.

Before we commence, it's crucial to understand that Excel doesn't support the diagonal slash (/) as a keyboard entry directly. However, you can insert it easily using a few tricks. We'll explore two methods: using the Insert Symbol dialog box and using the CHAR function.

Using the Insert Symbol Dialog Box

This method is straightforward and requires no complex functions. Here's how you can do it:

AD
How to Split Text Data of a Cell to Column in Excel - ExcelDataPro
How to Split Text Data of a Cell to Column in Excel - ExcelDataPro
an excel spreadsheet with the text slant cells in excel on top of it
an excel spreadsheet with the text slant cells in excel on top of it
Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know

1. **Open the Insert Symbol Dialog Box**: Select the cell where you want to insert the slash, then click on the 'Symbol' option in the Insert tab.

2. **Choose the Diagonal Slash**: In the 'Symbol' dialog box, scroll through the available symbols until you find the diagonal slash (/). Click on it to highlight it.

How to Split a Cell in Excel 2016
How to Split a Cell in Excel 2016
Excel tricks
Excel tricks

3. **Insert the Slash**: Click on 'Insert' to place the diagonal slash in your selected cell, then click 'Close' to exit the dialog box.

Using the CHAR Function

If you prefer using formulas and functions or need to insert slashes over an entire range of cells, the CHAR function is quite useful.

AD

1. **Understand the CHAR Function**: The CHAR function returns a character as a text string. It uses a numeric code (0-255) to represent the character.

2. **Use the CHAR Function**: To insert a diagonal slash, use the formula `=CHAR(47)`. This will return a diagonal slash in the cell where you place the formula. To apply it over a range of cells, drag the fill handle (small black square in the cell's bottom-right corner) over the cells you want to fill.

Potential Issues and Solutions

While these methods are generally reliable, you might encounter a few issues:

AD

1. **Character Encoding**: Excel uses ASCII for character encoding. If the code or symbol you're trying to insert isn't in the ASCII table (like emojis), you won't be able to insert it.

2. **Formatting Issues**: Sometimes, the diagonal slash might not appear due to formatting issues. To solve this, try changing the font to one that supports the slash, or adjust the cell's width or height.

Remember, practice makes perfect. The more you use these methods, the more natural they'll become. Happy Excel-ing!

AD
AD