Paste Without Format NOT ctrl+V
Our take
I looked everywhere but couldn't find a satisfactory answer (which probably means it doesn't exist). I am managing a shared excel file with people who will copy and paste information in and will be able to grab that information and do things with it.
The issue, is every time they paste something it breaks my conditional formatting which is the main way I am able to sort through and organize what they give me. Is there a way to have the default past as paste without formatting because I can not control how they paste the information in. (No asking them to do ctrl+Shift+v will not work, please don't even recommend it.)
If there are any other ideas on how to deal with this issue, please let me know.
EDIT: NO CTRL+SHIFT+V I am not the one pasting these values in, others are!
Conclusion: There isn't (currently) a way to do this, but the general consensus is to have them paste all the information into its own thing and then use power query to get the data I need. Thank you all for the advice!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- For Excel Web feature looking "paste value only as default"So my place using mostly excel as a main tool for maintaining inventory right now. and with everyone using normal copy paste. it pasting the format, condition everywhere. how can I make the past value only as the default one? It is so messy and mess up the whole management thing. submitted by /u/tgsoon2002 [link] [comments]
- Pasting from cells into Outlook NOT keeping source formattingI’m going to do my best to explain this in a way that makes sense: For work, I have an Excel spreadsheet containing all the templates of the emails I send most frequently. Normally, I double-click into the appropriate cell, CTRL-A, CTRL-C, and then go over to Outlook and CTRL-V into an email. Normally, this keeps the source formatting, but as of yesterday morning (March 26, 2026) it isn’t. Now I have to manually add all the bolded and underlined sections to every email and though it seems small, I can’t stress enough how much it’s thrown off my workflow. I CAN single-click the cell, CTRL-C, and CTRL-V the entire thing, border and all, into Outlook, but then I have to copy the contents, delete the border, and re-paste, and that’s stupid. I can also no longer copy part of the text within a cell; if I copy only a word, when I paste, it’s as though I copied everything. I’ve tried restarting my computer, shutting down my computer, checking for Windows and Microsoft updates, logging in and out of MS365, and extensively Googling the issue. I’ve checked all my paste setting in Outlook and they’re set to default to “keep source formatting”. I’m on Windows 11 and the latest versions of Excel and Outlook, and due to work I can’t revert to an earlier version. I’m going insane; please help me. submitted by /u/lubdubthrowaway [link] [comments]
- Pasting to Excel isn't working correctly - updating text to column makes it worseI've been copying and pasting data into excel the past few weeks just fine, but recently it takes every line break as a new cell. I've tried resetting the text to column fields like everyone suggests, but all it does is keep the top row of my text. The other rows just disappear. submitted by /u/xturvr [link] [comments]
- Is it possible to prevent conditional formatting ranges from breaking when you copy/cut data to and from the range?I currently have a conditional formatting rule set up for range $1:$1. However, this will break (and subsequently cause a lot of lag) if I copy a cell from a different row and paste it into row 1, or cut a cell from row 1 and paste it to a different row. I'm aware this is because I'm pasting the formatting and that's overriding the rule. Is there a way to make Excel not do that? I'm aware of pasting values not breaking the formatting; however sometimes there are things like borders which I want to copy over without having to mirror the formatting manually. submitted by /u/wishful_thonking [link] [comments]