Menu
MS Excel 2010 or 2007 or any version for that matter when you copy a cell(not selecting text from the cell) and pasting to any editor adds a line break and sends the cursor to next line. Its annoying to move up the cursor back to last line.
It doesnt look much work to get the cursor back to last line but if you have to keep doing this a lot of times as a programmer i feel really bad. Any suggestions if there is a setting in excel to stop this?
I tried looking online didnt find any thing and also looked up the options of excel, didnt find anything.
230
Active Member. Try Paste Special as unformatted text instead of Paste. Or in Excel, Press F2 and highlight the text then copy. When you paste, there will be no CRLF.
Microsoft Excel uses double quotation marks to signify text within formulas. When it sees these marks, it uses the text and discards the quotes. Typing quotation marks directly into a cell is not an issue because Excel automatically recognizes that you are entering text and therefore keeps the quotation marks.
To prevent a formula from changing when it is copied, you must change the formula in part or in whole to use an absolute cell reference. If you created an absolute cell reference in cell C2 that was "=$A$2" and copied the cell to C3 (or any other cell), it remains absolute and never change.
I was copy/pasting a large file of translations for our application between the Excel spreadsheet from the translation company and our code. Having to delete the newline each time was driving me up the wall.
In the end I copied the whole sheet and pasted it into a new Google Docs spreadsheet. Then I used that for my copying needs as it does not add the newline on copy that Excel does.
Hope that helps!
135
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
