Entering Data and Moving in Excel Worksheet

Home/Excel/Entering Data and Moving in Excel Worksheet

Entering Data and Moving in Excel Worksheet is very easy and you find that it is the time saver for data entry. You can enter any numbers, text, dates in Excel and you can format as per your requirement.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


Entering Data

Active Cell is the place where we enter the data. When we open a new Excel Workbook, by default it activates A1 (top-left corner of a Worksheet) position of a Worksheet and we can start entering the data.

We can observe the A1 is activate and you can see the Address of the active Cell in the Address bar (rounded with red circle), you can also observe the sample text in A1.

We can also activate a Cell and enter the data in Formula bar.

So, we can activate any Cell and enter the data as per our requirement, below is the example data entered in a worksheet.

Editing Data

We can simply select any Cell and enter new data to edit the existing data in a Cell.
If you want to edit a particular part of existing data, then you need to activate (by pressing F2 or double clicking with the mouse), then goto the particular position and change the data. The other method is using Formula bar, it will give more flexibility to enter the data. To do this, select a Cell and go to Formula bar then start editing or entering the data.

Useful Shortcut Keys to Move in the Worksheet

The below short-cut keys helps us to move in a Worksheet:

To move Press this key
One cell right Right Arrow Or Tab
One cell left Left Arrow Or Shift + Tab
One cell up Up Arrow Or Shift + Enter
One cell down Down Arrow Or Enter
To top of worksheet (cell A1) Ctr + Home
To last cell containing data Ctr + End
To end of data in a column Ctr + Down Arrow
To beginning of data in a column Ctr + Up Arrow
To end of data in a row Ctr + Right Arrow
To beginning of data in a row Ctr + Left Arrow
Towards Right Ctr + Left Arrow

You can also use, Go To Command (You can enable the Go To Command by pressing the Ctr+G. For example, if you want to Activate A22, enter A22 in the Reference space of the Go To Command and then press OK button.

You can also use Address bar to move around the Worksheet and Activate a particular Cell. For example, if you want to Activate C12, enter C12 in the Adress Bar and then press Enter Key.

LIMITED TIME OFFER
By |May 15th, 2013|Excel|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment


Related pages


how to protect a excel sheethow to insert a blank row in excelsql beginnersms project 2010 templateshow to find out duplicates in excelforgotten password in excel to unprotect sheetexcel macros usesexcel vba language referencehow to add developer tab to ribbon in word 2010vba absolute valueunprotect excel sheetsdeveloper mode excel 2010vba inputbox cancelvb syntaxvba add hyperlinkhow to create a dashboard in excel 2007rca format in wordexcel if statement rangebasic vba tutorialvba insert multiple rowsexcel macro delete blank rowsinsert button in excel 2007use of vlookup function in excelvbscript filesystemobject methodscan you merge cells in excelopen excel file from access vbavba examples in exceltools in excel 2007 macro securitycreate bar chart in excel 2010vba excel textboxdeveloper menu in excelhow do you unprotect an excel spreadsheetvba macros for beginnersvba examvba selection autofiltermsgbox in macrohow to insert developer tab in excel 2010sumif function examplesexcel hide sheet with passwordaccess vba add record to tablefiledialog vbaplanner excel templateintroduction to vba for excelcan you delete duplicates in excelexcel vba best practiceshow to write excel macrosmeeting minutes template word 2010excel 2007 pivot table tutorialusing trim in excelunlock excel spreadsheet with passwordexcel vba interior.colorindexexcel vba matrixexcel vba userform code examplesoperator operandvba msgbox exampleiserror in excelvba unprotect workbookhow to use iferror in excel 2010how to use vlookup in excel 2003 step by stepvba passwordschedule excel templatesrunning a macro in excelsql objective type questions and answers pdfaccess vba msgboxformula to calculate range in excellearning vba in excelfree capacity planning template excelhow to delete duplicate data in excelrun vba in excelvba code to export access table to excelhow to remove all macros from excel filepivot chart excel 2013vba is emptyvba create folderexcel coding for dummies