FG
💻 Software

In Excel, how do I prevent the cell's formatting to be dragged along?

Fresh5 days ago
Mar 15, 202633253 views
Confidence Score0%
0%

Problem

When working with data, drag-and-drop can dramatically speed up the workflow. Sometimes we work on files which already have their formatting in place, such as borders and colors. When I want to move data around, drag-and-drop is the most intuitive thing to do. BUT, it totally wrecks the formatting.…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: In Excel, how do I prevent the cell's formatting to be dragged along?

Low Risk

on a filled cell, you will see a little square block in the lower right corner. Place you pointer over the block and it becomes a plus sign. drag your info the destination box and when you release your mouse button, you will see a box with a plus si…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment