All Questions
Tagged with paste microsoft-excel
19
questions
67
votes
11
answers
263k
views
Excel copy-paste: always match destination formatting
I use Excel to crunch numbers, so I usually don't want to copy the formatting along with the text. But this is the default. Is there a way to default to always match destination formatting when ...
- 9,267
3
votes
3
answers
6k
views
Can I paste rich text and preserve formatting?
I have an Excel sheet and I paste text into a text box. I'm trying to copy+paste a source code from Eclipse and to preserve syntax highlighting and preserve tabs (code formatting).
Syntax ...
- 103
2
votes
1
answer
5k
views
MS office 2016 excel paste values with transpose
Is it possible to make this paste option (paste only values with transpose at the same time). As it shown on the schreenshot:
and having one button for this option in drop-down menu here:
- 346
2
votes
1
answer
333
views
Paste special text leaves trailing spaces in Excel
I wrote a script that creates an HTML table like this for a coworker:
<table>
<tr>
<td>06/21/2014</td>
<td>AAA</td>
</tr>
<tr&...
- 357
1
vote
2
answers
2k
views
Excel transpose via paste
I want to transpose data in Excel. Normally, I cut the cells I need, and use paste special -> transpose. However, sometimes when I do paste special, a box comes up asking me if I want to use unicode ...
- 2,658
1
vote
1
answer
1k
views
The fastest way to paste copied Excel cells with paste option `value & keep original format`
When copying cells, I often need to keep value & formation of the cell but NOT the original formulas.
Copying large range of cells, I couldn't see the paste icon to choose the associative options....
- 12.4k
1
vote
1
answer
151
views
Copying to Microsoft Excel with specs of text
When I copy text from another program to Excel, it does not preserve the properties of the text, such as being bold or italic. It pastes it as a plain text. Is there any way to save the text to Excel ...
1
vote
1
answer
94
views
LC_date like option for excel sheet (possible in libre office)
Windows 8.1, office 2013, english interface - danish region.
When working in excel I often paste dates from another application. These dates are in the form Januar 2013. When pasting, it seems excel ...
- 123
0
votes
2
answers
1k
views
Copy & Paste format from Excel into Word or Outlook
Recently, when I copy seven digit numbers from Excel and paste them into Outlook or Word, it pastes them as scientific notation and not as the seven digit numbers that I see them in Excel. I have ...
0
votes
1
answer
96
views
How to paste sparse columns so they line up with existing data?
So, I have a spreadsheet with about 5000 rows.
Each of these rows has a unique number in column A, followed by some data in column B:
| A | B |
|-------|------------|
| 5142 | Test ...
- 208
0
votes
2
answers
60
views
Cut entire cell, based on specific text in cell, and paste to new cell
I have a six-column table in excel that I am using with a barcode scanner. We are scanning custom QR codes that display text into each cell. The scan starts with scanning the employee's QR code on ...
- 1
0
votes
0
answers
28
views
Is it possible in excel to output value into blank cell without using paste special?
Is there any function or other way that takes result of formula and pastes value to given blank cell without formula?
It's quite annoying to use copy paste special->value or it's derivates.
For ...
- 1
0
votes
3
answers
8k
views
Error Excel data being pasted is not the same size as the selection
How can the following text be pasted in a 3*3 grid in Excel? When I try to do so, I get an error message stating that the data being pasted is not the same size as the selection.
12000 0 10
24524 ...
- 139
0
votes
1
answer
2k
views
Excel apply complicated formula to existing cells value without copy/paste
I want to apply the formula
=TEXT(A1,IF(A1-INT(A1)=0,"0","#.####"))
to existing cells with numbers without doing copy and paste.
The existing spreadsheet is already big and ...
- 115
0
votes
1
answer
99
views
Excel chart into Word - losing underlines
I am trying to copy an Excel chart into Word as a picture but I am losing the underlines under certain cells. I am copying as a picture (alt+H, C, P, P, Enter), and pasting into word as a picture (Alt+...
- 1