Written by Tijana Google Workplace / Sheets
Long-term Microsoft Excel users are familiar with inserting diagonal lines in a cell when working with sheets. Adding diagonal lines can help out when trying to separate the title at the top of the row and the first column within a table in the file, for example.
However, users are often unaware that even though Google Sheets offers nearly all the same features and services, it often happens for some of those to be missing.
In this case, there is no built-in feature that splits cells diagonally in Google Sheets. As annoyed as you might feel at the moment, there are workarounds that can help with just that.
Since using Google Sheets is more convenient as opposed to Excel, learn how to adjust to Sheets and get the best experience out of Google Workplace. Check out the workarounds in the article below!
Check out: How to Color Every Other Row in Google Sheets.
If you're trying to insert a diagonal line in a blank cell in Google Sheets, the best option is using the SPARKLINE function.
The SPARKLINE function creates small charts within a single blank cell.
The SPARKLINE function is as follows:
=SPARKLINE(data, [options])
Follow these steps:
Note: If you resize the selected cell, and adjust the width and height, this will automatically resize the line.
You might also like: How to Unhide Rows in Google Sheets.
When using the drawing tool, the diagonal line will look more professional as opposed to tilting the text to the side.
The drawing tool is a built-in feature, which makes it easy to navigate.
Follow these steps:
Even though Microsoft Excel and Google Sheets offer more or less the same services, it often happens for some features to be a bit different.
Google Sheets doesn't have a built-in tool to add diagonal lines in cells, but in this article, we covered two different workarounds.
If you liked this article, check out: How to Remove Gridlines in Google Sheets and How to Combine First and Last Names in Google Sheets.
You might also find these articles interesting: