jol11235813213455
New Member
- Joined
- Apr 13, 2012
- Messages
- 3
I am really hoping to have a face palm moment when some wizened member of the community sets be straight.
I am using the version of Excel which came with Office 2010 Student Edition. I am on windows 7 64-bit. In my experience, "ctrl+c" and "ctrl+v" should clone one cell to the next perfectly; any reference not prefixed with "$" should remain relative, yada yada ya - I'm sure everyone here knows how to copy and paste.
However, when I try to copy and paste I seem to only be able to paste values; no formulae, no formats, et cetera. When I paste onto more than one cell, I get:
In my experience, the formula should just be copied to each cell with no issues. When I select OK, it only pastes to the upper-left-most cell in the range. Even then, still only values. So I go to 'Paste Special,' and there are some missing options:
When I click 'Paste Special,' instead of the usual menu of values, formats, et cetera, I get:
So, I check my settings, and cannot find a thing that would affect this. I do not claim omnipotence, please humble me; the closest setting I can find to augment are:
So, that's where I'm at. Like I said, I am using 2010 home and student. Most of my other experience is with Excel 2010 Professional. Both are 32-bit instances on 64-bit windows 7 machines. I don't know if this would affect anything, but just throwing those details in.
P.S. - I can select the "fill" tab up in the ribbon, but that almost makes the program useless in my opinion. It's like non-alcoholic beer or those "snakes" people burn on the fourth of July.
Please, someone hand my rear end to me with a ridiculously simple solution/explanation, or at least commiserate if you've experienced the same.
Thank you!
- Jason
I am using the version of Excel which came with Office 2010 Student Edition. I am on windows 7 64-bit. In my experience, "ctrl+c" and "ctrl+v" should clone one cell to the next perfectly; any reference not prefixed with "$" should remain relative, yada yada ya - I'm sure everyone here knows how to copy and paste.
However, when I try to copy and paste I seem to only be able to paste values; no formulae, no formats, et cetera. When I paste onto more than one cell, I get:
In my experience, the formula should just be copied to each cell with no issues. When I select OK, it only pastes to the upper-left-most cell in the range. Even then, still only values. So I go to 'Paste Special,' and there are some missing options:
When I click 'Paste Special,' instead of the usual menu of values, formats, et cetera, I get:
So, I check my settings, and cannot find a thing that would affect this. I do not claim omnipotence, please humble me; the closest setting I can find to augment are:
So, that's where I'm at. Like I said, I am using 2010 home and student. Most of my other experience is with Excel 2010 Professional. Both are 32-bit instances on 64-bit windows 7 machines. I don't know if this would affect anything, but just throwing those details in.
P.S. - I can select the "fill" tab up in the ribbon, but that almost makes the program useless in my opinion. It's like non-alcoholic beer or those "snakes" people burn on the fourth of July.
Please, someone hand my rear end to me with a ridiculously simple solution/explanation, or at least commiserate if you've experienced the same.
Thank you!
- Jason
