1
vote
2answers
3k views

How can I stop Excel (2007) from copying hidden cells?

Let's say I have some rows or columns that are hidden, and drag a selection across where those hidden values would normally be. Is there a way to prevent Microsoft Excel from copying those hidden ...
4
votes
1answer
2k views

Issue in Excel: Copy a cell with formula - pastes value of the copied cell

I have the following copy and paste issue since yesterday. Probably it started when I was trying to edit a locked Excel-doc which i found on a shared server (that is - it was not created with my ...
0
votes
2answers
115 views

Excel 2007 suddenly does not paste with formatting anymore

A friend's Excel 2007 used to, when you'd copy cells and paste them within a document, paste the formatting along with it. Suddenly today it no longer does that. I found this question: How can I ...
2
votes
3answers
6k views

How do I copy part of an Excel worksheet to another Excel spreadsheet and retain the formulas rather than just the figures in the cells?

I hope someone can help me as I've wasted so much time searching for an answer to this problem! I have a large Excel 2007 spreadsheet (macro enabled) that I use as my main spreadsheet for ...
1
vote
1answer
3k views

Outlook Web App always pastes copied excel tables as an image

I'm using Outlook Web App - Version: 14.2.309.3 When I paste a table from Excel 2007 into a new message in OWA, it always pastes it as an image and not as a table. I have 5 colleagues who use the ...
3
votes
1answer
2k views

copy excel cell copies carriage return also

I am copying individual cells from excel and pasting it into SQL. Each time I do it, carriage return is automatically added to copy. Repro: Enter 123 in any cell in excel 2007.Click on another ...
0
votes
1answer
722 views

Pasting HTML table into Excel 2007 without modifying the format of each cell

I have a table in HTML having cells storing numbers like 123.0,123.00. When I use ctrl-A to copy the whole page into excel, 123.0 and 123.00 are all changed to 123, which is not something I want to ...
2
votes
4answers
6k views

Copy data with comma into single column in excel?

How can I copy and paste multiple rows of data that contains a comma, such as LastName, FirstName into a single column in Excel 2007? The default behavior seems to be to split the data into two ...
1
vote
1answer
318 views

Excel: Data subtotal copying problem

I have a huge data set consisting of 900,000 rows and 11 columns in Excel 2007 format. When I use the Data > Subtotals feature I get what I want: 162 rows grouped as I need. The problem is, when I ...
1
vote
1answer
6k views

“Paste special” stopped working properly in Excel 2007

I'm using Windows XP SP3 and am having some annoying problems with the "Paste Special" function in Excel 2007. Usually when I copy something from Excel to Excel and use Paste Special I get this ...
44
votes
3answers
23k views

Is it possible to paste CSV formatted data into Excel 2007?

I want to copy and paste CSV formatted text into Excel 2007. Is there a way of doing this without saving it to a temporary file first? I'm sure in previous versions of Excel there was a way to ...
2
votes
1answer
2k views

Is there a way to copy an Excel worksheet without copying all of the cell styles in the source workbook to the target workbook?

The title pretty much says it. I have an Excel document with tons of randomly named styles that I didn't create but that I want to copy a worksheet from. When I do, it drags all of those styles into ...
1
vote
3answers
126 views

Excel 2007 shortcut?

Is there a shortcut in Excel 2007 (or a simple way to define one) to paste all copied values, but without formatting ? I'm entering some data in tables, and it would really save my life, that one.