200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi,
I would like to create a short cut for "home" function on the key board. Since I need to go to the first column frequenty, to be efficient and less movement of my hand, I would like to know how I can create a short cut that would enable me to move the cursor from any cell in the spread sheet to the first column from the same row of the working cell of the excel sheet.
Your help is appreciated.
Mei-Lin Walter
To move the cursor from any cell to the first cell (column A) of that same row press the Home key.
Use Shift+Home to select the range of cells from the original location to column A.
Use Ctl+Home to move the cursor from anywhere to A1
Use Ctl+End to move the cursor from anywhere to the bottom right cell of the used range.
I figure out the answer myself. Thanks.
First move to any cell first. Then click on "use Relative References and then click on "record Macro" under developer in the ribbon. Then click on "home" on the key board. And then click on "stop recording". That's it.
