Instructions for crossing out cells in Google Sheets

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.

Instructions for crossing out cells in Google Sheets

Step 2:

Display the drawing interface, select the Line icon as shown below.

Instructions for crossing out cells in Google Sheets

Now you need to draw a line and then click Save and Close .

Instructions for crossing out cells in Google Sheets

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.

Instructions for crossing out cells in Google Sheets

As a result, we get a crossed-out cell in Google Sheets as shown.

Instructions for crossing out cells in Google Sheets

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 .

Instructions for crossing out cells in Google Sheets

Leave a Comment

Keep Services Available During a SLES 15 SP5 to SP6 Upgrade

Keep Services Available During a SLES 15 SP5 to SP6 Upgrade

SLES 15 SP5 can migrate online to SP6, but each node must reboot. Use a tested rolling upgrade or blue-green cutover to keep workloads reachable.

Apply the SLES 15 STIG Safely with OpenSCAP

Apply the SLES 15 STIG Safely with OpenSCAP

Use SUSE’s supported STIG profile to scan SLES 15, test remediation, review remaining findings, and retain assessment evidence.

Restore Cockpit Access to SUSE Linux Enterprise Server

Restore Cockpit Access to SUSE Linux Enterprise Server

Trace a failed Cockpit connection through DNS, port 9090, the systemd socket, firewalld, TLS, and login settings using current SUSE guidance.

Configure Reliable Ethernet Failover with SLES 15 Bonding

Configure Reliable Ethernet Failover with SLES 15 Bonding

Create a redundant Ethernet connection on SLES 15 with YaST and Wicked, configure active-backup bonding, and verify both ports and failover.

Build a Reusable AutoYaST Profile for SLES 15 Installs

Build a Reusable AutoYaST Profile for SLES 15 Installs

Turn an existing SLES 15 system into a reviewed AutoYaST profile, validate it, and use it to deploy a test server with fewer manual steps.

SLES 15 KVM Setup: Make Selected VMs Start at Boot

SLES 15 KVM Setup: Make Selected VMs Start at Boot

Install the SLES 15 KVM and libvirt tools, enable the right host service, and configure selected virtual machines to start after a reboot.

Diagnose a SUSE Server That Hangs at the systemd Shutdown Screen

Diagnose a SUSE Server That Hangs at the systemd Shutdown Screen

Use systemd jobs and the previous boot journal to locate a slow service, mount, or storage dependency, then correct it without masking the cause.

Open Only the Web Traffic Your SLES 15 Server Needs

Open Only the Web Traffic Your SLES 15 Server Needs

Use firewall-cmd to inspect the active zone, allow HTTP safely, preserve SSH access, and verify that the rule survives a reload on SLES 15.

Diagnose SLES PAM Login Failures Without Locking Yourself Out

Diagnose SLES PAM Login Failures Without Locking Yourself Out

Trace a PAM failure to its service, account policy, or identity provider, then repair the right SLES configuration while preserving a working admin session.

SLES Boot Module Load Failure: Find the Driver and Fix It

SLES Boot Module Load Failure: Find the Driver and Fix It

Trace a failed kernel module at SLES startup, correct an obsolete boot entry or repair the required driver, and verify the next boot.