Pressing enter on last column that will return to first column, next row.
Let's say I'm entering numbers left to right from B2 to Q2.
After pressing Enter on the last column (Q2) is there a way for the cursor to go to the first column next row (B3)?
Then after pressing Enter again on last column (Q3) it will again go to first column,next row (B4) and so on.
I hope someone can help me on this issue.
Thanks in advance!
If you press TAB to get to the next cell then enter when you get to the last one it will take you one row down and back to the left to where you first started using TAB like:
Cell B2 enter something then hit TAB which will take you to C1, do it couple more times and you should be in Q2.
Press Enter and it should go straight to B3
Another way to accomplish this is to unlock the cells in the columns you want and protect the sheet with the option NOT to select unlocked cells.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Wow that's a nice trick!
I never use the tab key before since the right arrow key is adjacent to number keys.
Will also try the Not to select unlocked cells.
Thanks a lot for the the quick response.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks