How do I place diagonal lines in a cell in Excel.


G

Guest

I would like to place diagonal lines in one or more cells in an Excel
spreadsheet. How do I do this?
 
Ad

Advertisements

G

Guest

Select the required cells. Then from the Format menu select cells. Then
select the Border Tab. Choose the line style you require in the box on the
right and then click just below and to the left of the work "Text" in the
box on the left. Click OK.

Regards
Rowan
 
G

Guest

Rowan, I really appreciate you taking time to answer my question. I need to
know how to place multiple diagonal lines within a cell in Excell.
Respectfully,
ezas1040
 
G

Guest

You have two options I guess.

1. Format > Cells > Patterns and then select one of the diagonal options
from the Patterns drop down.
2. Display the Drawing Toolbar and add the lines manually using the Line
function (click and drag).

HTH
Rowan
 
Ad

Advertisements

Joined
Oct 5, 2016
Messages
1
Reaction score
0
To fill a cell with multiple diagonal line patterns in a cell:
  1. Select the cell(s).
  2. From Styles on the menu ribbon, select New Cell Style
  3. Enter Style name, for example: SlashRight or SlashLeft
  4. Click on the Format button
  5. Select the Fill tab
  6. Select Pattern Style drop-down arrow
  7. Select your desired pattern
  8. Click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top