All Questions
9
questions
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 ...
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 ...
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 ...
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 ...