All Questions
Tagged with paste microsoft-excel
9
questions with no upvoted or accepted answers
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
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
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
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
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 '...
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
0
votes
1
answer
2k
views
Excel macro to look up data from a database and copy it to another Excel file or sheet
I have an excel file which looks up and calculates data for a given date. It works as follows:
You enter the date in a specific cell (input) and in the same sheet the required data appears (20 cells). ...
- 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