Instructions for copying cell formats in Excel

Excel has a Format Painter tool that allows you to copy formatting from one cell or group of cells to another without copying their contents. Cell formatting includes everything from font size and color to borders, number formats, and Excel conditional formatting . This makes formatting cells in Excel much faster, instead of doing it manually again. Here's how to copy cell formatting in Excel.

How to copy cell format in Excel

Step 1:

You open the data table on Excel as usual, then click on the cell you want to copy the format . Next, we click on the Format Painter tool as shown below.

Instructions for copying cell formats in Excel

Step 2:

Excel will now place a dotted line around the selected cell or cells to let you know that something has been copied, and your cursor will change to a paintbrush icon.

Instructions for copying cell formats in Excel

Step 3:

Click the cell or range of data that you want to copy the previously selected cell format to. Once you paste the format into those new cells, the cursor will return to its original icon and the original cell format will no longer be copied.

Instructions for copying cell formats in Excel

If you need to copy formatting to multiple locations on the same worksheet, reselect the cell or cells with the formatting you want to copy, and double-click Format Painter. This way, every time you select the cell or cells where you want to paste the formatting, your cursor will remain the paintbrush icon, the copied cells will still be surrounded by a dotted line, and the Format Painter icon on the Home tab will still be selected.

To cancel the Format Painter tool, click Format Painter again or press Esc.

Leave a Comment

Enable SLES Live Patching and Verify a Kernel Fix

Enable SLES Live Patching and Verify a Kernel Fix

Set up the right Live Patching path for SLES 16.0 or 15 SP7, apply eligible kernel fixes, and confirm what is active without confusing it with a reboot-required kernel update.

Install and Sign Custom Kernel Modules on SLES 15 Secure Boot

Install and Sign Custom Kernel Modules on SLES 15 Secure Boot

Load a custom SLES 15 kernel module without disabling Secure Boot. Match the running kernel, sign the .ko file, enroll a MOK key, and verify loading.

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.