Hello,
Is there a way to automatically move cells down after I entered data in it? This way I do not have to scroll all the way to the bottom of the list to add new data. It would be greatly appreciated if this is explained to me if this is possible!
Thanks in Advance.
Alternative solution,
Use 'CTRL & arrow down' to go to the bottom of the list.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
You would need to use VBA. Would you want the whole row moved down or only the contents of that column?
Alternately, there are these shortcuts
ALT Down Arrow will move you to the bottom of the column (if there are no blanks)
ALT + END will move you to lower right corner of your used region (bottom right of your data)
You can enter a specific cell into the name box and hit enter and it takes you to that cell
Unlike MS Word, Excel will open up to where you left the active cell so it should open up to the last cell you filled.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes I would like the whole row moved down. I would prefer to use a VBA instead of the shortcuts
Assuming the cell that you want to trigger this is cell B3
Right click on the tab and "View Code"
Paste this code into the large text box and close the window
Does that work for you?
Please Login or Register to view this content.
Yes this worked for me! Thank you greatly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks