UrbanPro
true
default_background

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors
✕

Search in

How to add a diagonal line in a cell in MS EXCEL

Profile Photo Manoj Kumar
04/11/2016 0 View Comments0

Many a times we feel the need to use a cell to act as headers for data flowing in two directions -- Rows and columns and for this purpose we may want to add a diagonal line to accomodate the two headers .. But how do we add a diagonal line to a cell.!!! The simplest way to do this is to use the borders feature of a cell.

In MS Excel 201O and later versions you can achive this by the following steps.

Step 1

  1. Select the cell where you want to add a line diagonally
  2. Right click the cell and click on format cells
  3. Click on the Border tab
  4. Under the sub header titoled Border, where you see the various ways in which lines can be added to a cell, selct the diagonal line, lower left to upper right or upper left to lower right..whichever you need.
  5. And what you get is a cell with a line drwan diagonally.

Step 2

Another way to achive the same thing is by pulling the format cell screen by clicking the little arrow under the group titled as FONT under the home tab. Once the format cell window appears, you can follow step 3 and 4 as mentioned ablve to draw  diagonal line

 

0 Dislike
Follow 0 Loading Spinner
Default Profile Photo

Please Enter a comment

Submit

Other Lessons for You


Pivot table - Transform numbers in calculated field
How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking...
Profile Photo

Learning Pivot Table Part-1
You all must have watched movie based on War. One thing you all might have noticed, in most of the movies, armies fought with their enemies hiding inside the bunkers, an army fighting war in open obviously...
Profile Photo

Microsoft Excel
Software developed and manufactured by Microsoft Corporation that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. Microsoft...
Profile Photo

When should you use TRUE in vlookup?
You can use TRUE as the last argument in vlookup function when you are looking up using which is a range with a lower limit and an upper limit. For example if you want to charge a customer according to...
A

Akhilesh Dadhich

0 0
View Comments0
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more