In this article:

How to Split a Cell Diagonally in Google Sheets (2024 Guide)

April 12, 2024

Method 1: Using the Tilt Feature and Line Breaks

Follow the steps below to split a cell diagonally using the tilt feature and line breaks.

Step 1: Clear Existing Borders

Start by clearing any borders from the cell or range of cells you wish to split diagonally to avoid any visual clutter.

Step 2: Insert Line Break and Dashes

Click inside the cell where you want the diagonal split. Place your cursor where you want to insert a break, then press Ctrl + Enter (or Cmd + Enter on Mac) to create a line break. After the break, insert several dashes (-) to create a makeshift line.

Below is a demonstration:

google sheets split cell diagonally

Step 3: Apply Text Rotation 

With the cell still selected, go to the Format menu, choose Rotation, and then select an option (Tilt Up or Tilt Down, depending on your preference) that tilts the text to align with your makeshift line. 

how to split a cell diagonally in google sheets

Here's what it should look like: 

split cell diagonally google sheets

Method 2: Drawing a Diagonal Line Manually

Follow the steps below to split a cell diagonally by drawing a diagonal line manually.  

Step 1: Organize Text 

Arrange the text in your cell in a way that leaves space for a diagonal line. You might want to place one part of the text at the top of the cell and the other at the bottom.

split a cell diagonally in google sheets

Step 2: Create a Diagonal Line

Go to the Insert menu, choose Drawing, and then select + New. Use the line tool in the drawing panel to draw a diagonal line.

how to diagonally split a cell in google sheets
split cell diagonally in google sheets

Step 3: Finalize and Position the Line within the Cell

Once the line is drawn, click Save and Close. Adjust the drawing's position so that the line aligns perfectly within the cell, creating a clear visual split.

how to split cell diagonally in google sheets

Using the SPARKLINE Function

Follow the steps below to split a cell diagonally using the SPARKLINE function.

1. Create Diagonal Line 

Click in the cell where you want the diagonal split. Enter the SPARKLINE function with parameters to create a line, for example, =SPARKLINE({0,1}) for a line from the bottom left to the top right, or =SPARKLINE({1,0}) for the opposite.

is there a way to split cell diagonally in google sheets
can you split a cell diagonally in google sheets

Step 2: Change the Line Color 

You can customize the color of the diagonal line by adding options to the function, like =SPARKLINE({0,1},{"color","red"}).

google sheets how to split a cell diagonally

Note: With the SPARKLINE function, you won't be able to add any text.

We hope that this article has helped you and given you a better understanding of how to split a cell diagonally in Google Sheets. If you enjoyed this article, you might also like our articles on how to set up an income tax calculator in Google Sheets and how to fix the problem of Google Sheets not saving changes.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->