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
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
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?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks