1
vote
2answers
5k 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
1answer
75 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.
0
votes
1answer
440 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
1answer
384 views

Need to paste a column from excel into powerpoint- how to paste so they are individual slides, not one

I have a column of 50 in excel 2003. I want to paste it into powerpoint but it continues to paste as 1 whole text box. I need 50 individual text boxes. Is this possible?
0
votes
1answer
527 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 ...
4
votes
3answers
6k views

Copy/paste filtered column in Excel - error message

In short, I have filtered a worksheet by column A, and I want to copy/paste from column B to column C. Obviously I don't wish to copy/paste values from rows that were filtered-out here. The above ...
0
votes
1answer
980 views

How can I copy cells in Excel 2007 and paste with formatting

I am wanting to be able to copy cells in a worksheet and paste them elsewhere in the same worksheet while maintaining the original formatting. I also want to be able to paste into Word and Outlook ...
0
votes
4answers
5k views

Copying a hyperlink so that it works with a series

OK, this should be a no-brainer, but I cannot find anyone to help me with this: Example A5-K5 On worksheet 1 contains info relating to one specific item. I want to have a hyperlink in L5 taking me to ...
1
vote
1answer
517 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 ...
5
votes
2answers
2k views

How to paste table from MS Excel to Wolfram Mathematica?

When I am pasting a region from MS Excel, which contains multiple numbers, to Mathematica, I am getting just a long plain sequence of digits, i.e. one integer number in Mathematica. How to have a ...
1
vote
1answer
788 views

Copy & paste a cell along with its name in Excel

Is there a way to copy a cell that also has a "name", and paste it somewhere else so that the new cell also has the same "name"?
1
vote
2answers
950 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 ...