I am having a problem, My copy will only go in one direction .. either down or across.
It may be a function that is stuck because when I stop the drag it gives me the sequential date from the first cell. I am trying to copy and excel thinks I want sequential.
Any help on this will be great appreciated.
Hi Crimescene and welcome to the forum,
This sounds like a problem with Absolute vs Relative addressing of your cells formulas.
Read
http://www.techonthenet.com/excel/qu...eferencing.php
and if my guess isn't close then attach a sample file showing what you have and what your answer should look like.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I never realized that excel did that with dates so I'm not sure of the best fix, but I do know that this will work in the meantime...
Right click the cell you want to copy
click copy
highlight ALL the cells you want to paste the date to
right click
click paste
Again, it may not be the best solution, it's just a "quick-fix"
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
I dont think that is the answer I am looking for.
What I am trying to do is highlight a section of excel so I can only print that part of it.
when I drag and release the drag instead of highlighting the area it changes to sequential numbers from the first cell.
OK, when you "drag" from the bottom right hand corner using the little square, it will do what you are describing. If you want to just highlight cells, click in the cell and then "drag".....without using the bottom right corner.
I am so sorry .. I feel like an idiot now ... thanks for the help
No worries at all. I know that it does that with numbers and I still do wrong occasion.
Last edited by gmr4evr1; 05-29-2016 at 12:54 PM.
Instead of selecting with the mouse, you can enter the range in the NAME field left of the formula bar and above the row numbers. If you enter E5:G16 and hit enter, that range on the worksheet will be selected.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Well son-of-a-gun.....didn't know you could do that. Thanks Ron.
@gmr4evr1
You're welcome.
That trick comes in handy when selecting very large ranges that may have spaces that prevent Ctrl + Shift + Arrow to work properly. In addition, it is very quick.
I believe the easiest way to do this is highlight the square you want move.
Hit ctl+c (copy)
Go to what will be upper left cell of our new position.
Hit ctl+v (paste)
Don Cole
Just to further what I suggested in msg#8, lets say that you want to copy the range B14:D25 to a range starting in H14. In the name box enter B14:D25 hit enter then Ctrl + C then enter H14 in the name box hit enter then Ctrl + V. That will copy the range to another location without moving the mouse.
@newdoverman
I'm going to try really hard to remember to do that in the cases of large ranges. I've learned so many tricks since I've joined this forum I've had to make a list of them.
And another shortcut trick to add to my list.
Using that method, if you know the ranges and the destination sure saves a lot of scrolling around the worksheet. If copying to a different worksheet, enter the worksheet name with cell reference, hit enter and Ctrl + V and the copy will be made on the referenced worksheet at the specified location.
Ahh, that one took me a few seconds to get it right....I forgot the ! after the sheet name.
Hmmmm....imam have to hire someone to make the list for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks