All Questions
Tagged with copy-paste microsoft-excel-2007
17
questions
0
votes
0
answers
761
views
Copy But Unable to Paste within a Excel Worksheet
I have two worksheets in an excel file in which I can't paste copied data within the worksheet. I click on the next cell after copy and the rotating dashes disappear or when I right-click the paste ...
0
votes
1
answer
746
views
How to copy a formula or value into another formula
I want to know how to copy a formula into another, while keeping the original values. For instance, I have in range A1:A5 five values (a mix of constants and/or formulas) and I need (in that same ...
9
votes
2
answers
98k
views
Restrict paste into dropdown cells in Excel
I have one Excel sheet which contains many drop-down columns.
Let's say one column has Test1, Test2, and Test3 as drop-down option values.
Cells under this column should not accept the values other ...
4
votes
6
answers
90k
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 ...
5
votes
2
answers
10k
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
2
answers
295
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
3
answers
50k
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 ...
2
votes
1
answer
12k
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 ...
5
votes
1
answer
5k
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
1
answer
2k
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 ...
11
votes
7
answers
42k
views
How to stop numbers converting to date format on copy paste in Excel?
When I copy data from a site and paste in Excel,
some numbers / numeric strings are converting to date format.
For example: "2-1" converting to "1-Feb".
How can I prevent this?
I have too many ...
5
votes
4
answers
43k
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
1
answer
562
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
1
answer
9k
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 dialog:...
158
votes
5
answers
117k
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 ...