All Questions
Tagged with paste microsoft-excel
19
questions
1
vote
1
answer
138
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 ...
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
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
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
-1
votes
1
answer
45
views
Getting paste from specific cell
i want to copy a range starting from cell B to Cell N in columms but in Rows it can go to even 1000 i want a macro that start pasting any data from B:10 and nowhere else.P.S. The data is dynamic which ...
- 1
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
332
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
0
votes
0
answers
2k
views
Office 2013 - Paste Special Shows 'Unformatted Unicode Text' only - Show Options Turned on in Advanced Options
About two weeks ago my "Paste Special" stopped working in Office 2013 products.
Before, I could paste and choose how I wanted it to work.
But, since, all I have in the Paste Special options is '...
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
67
votes
11
answers
262k
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
0
votes
1
answer
790
views
Can't find the paste function called 'Match Destination formation'
I cannot see the Paste Special option f 'Match Destination formating' in Exce l 2010. I use this when subtotalling and then copying out data to another worksheet.
- 1