Crossing cells in Excel is quite simple, but with Google Sheets you do not have the option to cross cells and will need another application to support. There are several ways for us to cross cells in Google Sheets and these methods are relatively simple and easy to do. Below are instructions for crossing cells in Google Sheets.
How to Cross Out Cells in Google Sheets
Step 1:
First, you enter the content into the Sheets cell , adjust the text to be opposite each other, use the line break shortcut in Google Sheets to enter the text. You click on the cell where you want to create a cross, then click Insert and then click Drawing in the displayed list.
Step 2:
Display the drawing interface, select the Line icon as shown below.
Now you need to draw a line and then click Save and Close .
Step 3:
At this point, the user will see the line displayed in the cell and you need to adjust it to create a diagonal line in the Google Sheets cell . If you are not satisfied, click to edit it again.
As a result, we get a crossed-out cell in Google Sheets as shown.
How to create fake diagonal lines in Google Sheets
We will use the text rotation function to create a fake diagonal line in a Google Sheets cell.
Step 1:
Type the first text in the cell and press ALT+Enter to create a new line. And type dashes to create a diagonal effect.
Step 2:
Click Format , then click Rotate and select the desired tilt angle .
Tired of Microsoft Edge Error 0x8004210b blocking your updates? Follow our expert, step-by-step guide with quick fixes to resolve it fast. No tech skills needed – get Edge running smoothly again!
Tired of Microsoft Edge draining your laptop battery fast? Get instant fixes with this step-by-step troubleshooting guide for Microsoft Edge laptop battery drain fix. Boost battery life now!
Tired of Microsoft Edge crashing with "Bad Image" after Windows Update? Discover quick, step-by-step fixes to restore your browser fast. No tech skills needed!
Master how to transfer Microsoft Edge bookmarks to a new computer with foolproof methods: sync via Microsoft account, export/import HTML, or cloud backups. Quick, safe steps for seamless migration.
Tired of annoying Microsoft Edge microphone background noise ruining your calls? Discover step-by-step solutions to solve Microsoft Edge microphone background noise for flawless video conferences and recordings in Edge.
Tired of Microsoft Edge extensions crashing? This step-by-step 2026 guide delivers quick, proven fixes to restore stability. Update, reset, and troubleshoot like a pro—no tech skills needed!
Stuck with Microsoft Edge Error 404 Page Not Found? Follow our proven step-by-step troubleshooting guide to fix it fast, clear cache, reset settings, and browse without interruptions. Get back online now!
Struggling with Microsoft Edge HTTP Error 500? Discover step-by-step fixes for Internal Server Problems, from cache clearing to advanced troubleshooting. Get back online fast!
Struggling with Microsoft Edge "DirectX Runtime" compatibility errors? Discover step-by-step fixes to resolve crashes, video glitches, and performance issues in Edge. Get back to smooth browsing today!
Struggling with ERR_SSL_PROTOCOL_ERROR in Microsoft Edge? Discover step-by-step fixes for SSL protocol errors, from clearing cache to advanced resets. Get back online fast with our ultimate guide.
