For years I have just typed in say 1/1/2011 in cell A1 of an Excel and clicked on that cell and copied it throughout the entire A column and then selected what I wanted. Such as copy days. But the other day someone said there has to be some formula. Say I entire in A1: Market and then in A2: Georgia and want to copy Georgia in cells A3:A5000 but do not want to click and drag. Is there a formula to copy all that without the click and drag?
Last edited by tmiller1; 09-14-2011 at 02:40 PM. Reason: [Solved]Copy cell help
Hello tmiller1,
Welcome to the Forum!
You can still do it all with keystrokes.
- Select cell A2
- Press CTRL+G
- Enter A5000
- Press ENTER or Click OK
- Press CTRL+SHIFT+UpArrow
- Press CTRL+D
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks