Cursor Movement to specific Cell in MS Excel 2007

**jacksonmathews** · 01-14-2009, 03:14 AM

Dear Friends,

I use MS Excel 2007. I am anxious about following solution -

I am punching in large database in an excel spreadsheet
I have set cursor movement to "right" direction (instead of default "down")
What I want is as the cursor moves with each return carriage and when
it reaches to the Cell say H2 and when I press enter after entiring data,
the cursor should come to B2 automatically.

How do I go about it ?

Many thanks in advance.

**ikuogs** · 01-14-2009, 03:34 AM

You can try highlighting the area you want to type, and then use TAB instead of ENTER to go to the next cell. It will go to B3 after you TAB at H2.

**jacksonmathews** · 01-14-2009, 04:48 AM

Originally Posted by ikuogs

You can try highlighting the area you want to type, and then use TAB instead of ENTER to go to the next cell. It will go to B3 after you TAB at H2.

Did'nt get you dear !!!
Am I not supposed to put any macro or command or options !!!

**ikuogs** · 01-14-2009, 04:51 AM

Originally Posted by jacksonmathews

Did'nt get you dear !!!
Am I not supposed to put any macro or command or options !!!

No macro or any other action needed! Just try highlighting the area B2 to H4 using your mouse. Then press TAB repeatedly. See the highlighted area moves from B2>C2>D2>E2>F2>G2>H2>B3>...

**jacksonmathews** · 01-19-2009, 08:12 AM

Originally Posted by ikuogs

No macro or any other action needed! Just try highlighting the area B2 to H4 using your mouse. Then press TAB repeatedly. See the highlighted area moves from B2>C2>D2>E2>F2>G2>H2>B3>...

Sorry for being DUMB

But what do you mean when you say HIGHLIGHT ???
How I do it in Office 2007 ?

My Regards.

**jacksonmathews** · 01-21-2009, 01:42 AM

Anybody to help me out please.....?

Thanks Jack.

**jacksonmathews** · 01-22-2009, 09:42 AM

Sorry for bumping....
but I am anxiously in need of this solution.
my regards.

**jacksonmathews** · 01-27-2009, 02:47 AM

I though this should not be a difficult one....may be it is too easy for anyone to reply

**jacksonmathews** · 01-29-2009, 05:30 AM

Dear Moderator,
Am I posting the topic at correct location ?
Pleae guide me if I am wrong.
Thanks - Jack

**themangoagent** · 02-23-2010, 03:05 PM

Highlighting in Excel is something akin to highlighting words in Microsoft Word. At the end of a word, you click and hold down the left mouse button, and move across the word or words. This produces a highlight. From this point your computer will be able to recognize what you have selected, and you may perform functions on it like copy and paste. Before highlight: Hello World.
After highlight: Hello World would appear with a blue rectangle surrounding it, and the text would have changed to white.

It is very similar to excel. You click your left mouse button, and drag it over the cells you would like to select.
ikuogs was suggesting highlighting, and using the Tab button on your keyboard to quickly move through each cell.

I hope that helped you understand the highlighting feature of any computer. Highlight is just another word for select.