{"id":1050,"date":"2012-11-06T14:51:57","date_gmt":"2012-11-06T14:51:57","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1050"},"modified":"2026-03-07T21:55:33","modified_gmt":"2026-03-07T21:55:33","slug":"five-ways-to-enter-data-in-excel","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/five-ways-to-enter-data-in-excel\/","title":{"rendered":"Five ways to enter Data in Excel"},"content":{"rendered":"

There is more than one way to enter data into an Excel worksheet. \u00a0Sometimes we stick to typing directly into cells, but there are different ways to enter data which can speed up your data entry work.<\/p>\n

    \n
  1. Type directly into a cell\u00a0<\/strong>and add your data. \u00a0You know a cell is active as it is highlighted with a darker border.\n

    \"active-cell-computer-excel-training\"<\/a>
    A2 is the active cell – it has a darker border so it stands out from the other cells<\/figcaption><\/figure><\/li>\n
  2. Use the formula bar. \u00a0<\/strong>This is located under the ribbon. \u00a0Type your data directly into the formula bar and press enter. \u00a0You can navigate around the worksheet by typing the cell number directly into the Name box (located above the Column\u00a0headings A – Z).\n

    \"enter-data-formula-bar-computer-excel-training\"<\/a>
    The Name Box shows that the active cell is A3.<\/figcaption><\/figure><\/li>\n
  3. Make the most of autocomplete. \u00a0<\/strong>Excel will try to help you speed up your data entry by guessing what you are typing based on what’s in your worksheet. \u00a0If the autocorrect option is right for you, just press enter.\n

    \"autocomplete-computer-excel-training\"<\/a>
    Autocomplete is guessing that I am typing Simon, and I’ve just typed “Si”, I can press enter and the full name is entered for me.<\/figcaption><\/figure><\/li>\n
  4. Copy and paste<\/strong> – you may have cells that you can copy and paste data within the same worksheet – it can save you time formatting a sheet, or you can copy data to another worksheet within the workbook.<\/li>\n
  5. Let Autofill<\/strong> do the work. Autofill options can complete series of data, whether it is text or numbers. \u00a0This saves lots of data entry when setting up worksheets, or entering data.<\/li>\n<\/ol>\n

    An\u00a0Excel course London can give you extra skills<\/a> so you can speed up entering the data, so you can concentrate on using the information you’ve gathered.<\/p>\n","protected":false},"excerpt":{"rendered":"

    There is more than one way to enter data into an Excel worksheet. \u00a0Sometimes we stick to typing directly into cells, but there are different ways to enter data which can speed up your data entry work. Type directly into a cell\u00a0and add your data. \u00a0You know a cell is active as it is highlighted […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"singular-low-link.php","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[105,167],"class_list":["post-1050","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-computer-excel-training","tag-enter-cell-data"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1050"}],"version-history":[{"count":2,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1050\/revisions"}],"predecessor-version":[{"id":7882,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1050\/revisions\/7882"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}