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