Skip to main content

All Questions

Tagged with
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). ...
Bart's user avatar
  • 1
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 ...
adaslaw's user avatar
  • 103
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....
Nam G VU's user avatar
  • 12.4k
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 ...
David Oneill's user avatar
  • 2,658

15 30 50 per page
1
2