LinkBack URL
About LinkBacks
I have screwed up my copy/paste and I don't know what I have done. How do I restore the default settings for excel? I tried going into the options menu and changing it from there but nothing is working.
I have screwed up my copy/paste and I don't know what I have done. How do I restore the default settings for excel? I tried going into the options menu and changing it from there but nothing is working.
What is screwed up? Can you describe the symptoms?
I copy the formula from the cell and when I paste it does not adjust for the new cell. What I mean is that it is pasting the exact same forumla into the new cell. This is happening after I use conditional formating, I have figured out.
Do you copy the cell or do you copy the formula from the formula bar? The formula will only adjust if you copy the cell.
Also check that calculation is not set to manual: Tools - Options - Calculation - tick Automatic.
Have you used any VBA that might affect this?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
teylyn, I did not copy the formula from the formula bar.
royUK , I don't think I used VBA. I did find that this happened after used conditional formating if that means anything.
What formula are you copying?
Do you mean the formula in the cell is not adjusting or the CF formula is not adjusting?
Remember what the dormouse said
Feed your head
It is hard to explain, but when you copy from inside the cell and then paste into another cell it always pastes the exact same formula. Usually when I copy the entire cell(don't click inside the cell) and paste into another cell it will adjust for the column or row. Eg. a formula like this, =SUM(A1+B2) in cell A1 ,when copied and pasted into cell D1 it should adjust to =SUM(C1+C2), except in instances when you copy from the formula bar.Originally Posted by romperstomper
I hope that makes it easier to understand.
So the cell references don't adjust when you copy a formula.
Again, do you have automatic calculation enabled or is calculation set to manual?
Are the cell references absolute or relative? If you copy a cell reference $A$1, it will always stay $A$1, because it is an absolute reference.
Can you post a data sample of the cells you are copying?
Hey Teylyn,
Sorry I missed your question. I do have automatic enabled(I went into options and checked, it has the automatic box ticked in the formula tab)
No the cells don't have the $ sign , eg like this A1.
I am a little stumped by this.
Last edited by teylyn; 03-25-2010 at 09:04 PM. Reason: removed spurious quote
post a file.
-- and don't quote whole posts, please. It's just clutter.
So you copy a whole cell, not just its contents, and paste it elsewhere on the sheet, and the formulas don't adjust at all, but this only happens if you have applied conditional formatting of some sort? Is the cell part of a table or just a normal range?
I applied condition formating to the sheet "staff 2" and this problem is only seeming to happen in this sheet. Eg, When I copy cell B4 to cell AM4 it does not adjust. I tried for about 4 hours to post a file yesterday but it was not allowing me to post attachments , sorry.
Teylyn, sorry about the quote, it is a habbit.
Last edited by JapanDave; 03-26-2010 at 09:09 PM.
B4 references to =グ＋小!C4
AM4 references to =グ＋小!C8
When I copy B4 into AM4 it will then result in
=グ＋小!AN4
That is the expected result and that's what I see. Do you see something different? (By the way, next time you post such a big file, could you please zip it? Thanks)
Get rid of the merged cells. Why span three columns, when you could just make the column wider? Avoid merged cells like the plague. Use "center across selection" instead or draw borders, format white fill and let the text roll across the columns.
Last edited by teylyn; 03-26-2010 at 08:57 PM.
When I copy B4 =グ＋小!C4, it copys to AM4 the exact same =グ＋小!C4 into the new cell. But it is only happening on this sheet and no other, that is why I am stumped.
I will remember the Zip file.
can you verify that automatic calculation is enabled in this worksheet?
How would I do that on excel 2007? Thanks.
Formulas ribbon - calculation options dropdown (towards the right) - automatic
It is on auto matic. I am really stumped.
I have the same problem as the original post: Whenever I paste a formula, it pastes the Value, which is not what I want to do. I want it to paste the formula, adjusted for the new cell location. Responders with irrelevant questions don't get it. Here's the core of the problem. Excel doesn't behave like I'm used to. Some obscure setting has apparently changed. Annoying! I don't want to waste time troubleshooting. I just want Excel to behave like it did the first day it was installed. Don't ask me any questions about what I'm trying to do. Just point me to the magic "reset all settings to default" button if by God's loving grace it exists.
Please be a hero and compensate for Microsoft's epic fail in making this thread necessary. Anybody?
cn2zv5oe,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks