All Questions
Tagged with copy-paste microsoft-excel-2007
4
questions
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 ...
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 ...
3
votes
1
answer
13k
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 ...
0
votes
2
answers
296
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 ...