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


vba code to open excel file from folderhlookup syntaxshortcut for format cellstesting interview questions for freshersvba guideexcel vba loop through rangevba print pdfexcel vbscript tutorialinsert comment in excelconstruction project management forms templatesvba adodb.connectionhow to remove duplicate items in excelscripting.filesystemobject opentextfilevba downloadremove excel worksheet passwordexcel calculate weeks between two datesexcel sample templatesvba excel chartsbuild macro in excelvb6 open text filegetopenfilename vba excelexcel pivot table example datavba instr functiondefine worksheet in excelcombine multiple spreadsheets into onecreate bar chart in excel 2010fso delete fileexcel macro tutorial with examplessum if exampleconsolidate data in excel from multiple worksheetsmicrosoft excel 2010 pivot table tutorialexcel eliminate empty rowshow to insert a pivot table in excel 2013how to protect excel workbookexcel hotkey insert rowaccess vba checkboxhow to remove cells in excelhiding a column in excelvba programming tutorialdata mining interview questions and answerssql query interview questions and answers pdfvlookup function in ms excelhow to add drop down list in excel 2007find duplicate values in excelvba sumifs exampleinstr vba functionhow to write an if statement in excelexcel macro row counthow to use a pivot table in excel 2010excel autofit cellshow to delete a column in excelbar of pie excelvisual basics in excelchanging row to column in excelremove duplicates excel vbashort cut keys excelexcel vba buttonhow to put a tick box in excelexcel templates project managementvba format stringformula for hlookupvba save excel fileadvanced excel 2007 formulas with examplesexcel unprotect sheet vbams excel lookup function exampleunprotect excel sheet without passwordvbs message boxrange properties vbaexcel project management template microsoftvlookup explained in simple terms100 most frequently asked interview questionsbusiness analyst interview questions for freshersexcel vba errorfso.movefile