All Questions
Tagged with paste microsoft-excel
19
questions
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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). ...
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 ...
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 ...
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
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 ...
-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 ...
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:
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&...