{"id":491,"date":"2018-06-28T11:25:03","date_gmt":"2018-06-28T11:25:03","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=491"},"modified":"2024-03-30T00:38:46","modified_gmt":"2024-03-30T00:38:46","slug":"methods-for-entering-and-editing-data","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/","title":{"rendered":"Entering and Editing Data"},"content":{"rendered":"\n<p>If you want to enter information inside a cell, first you need to click the cell to make it active.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"346\" height=\"167\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png\" alt=\"\" class=\"wp-image-492\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png 346w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell-300x145.png 300w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/figure>\n\n\n\n<p>You can use either of the following methods:<\/p>\n\n\n\n<ul>\n<li><strong>Start Typing<\/strong>: Begin typing, and the text will automatically appear inside the cell.<\/li>\n\n\n\n<li><strong>Formula Bar<\/strong>: Click the Formula Bar, start typing, and the data will appear both in the Formula Bar and the active cell.<\/li>\n<\/ul>\n\n\n\n<ol>\n<li><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"346\" height=\"167\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/formula-bar-1.png\" alt=\"\" class=\"wp-image-493\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/formula-bar-1.png 346w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/formula-bar-1-300x145.png 300w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading format\">Different ways to confirm the input<\/h2>\n\n\n\n<p>You can confirm the data you typed in four different ways, depending on where you want the next active cell to be.<\/p>\n\n\n\n<ol>\n<li>The most common method to confirm entry is by pressing the&nbsp;<strong><span class=\"shortcut\">Enter<\/span><\/strong>&nbsp;key. In this case, the next active cell will be the cell below,<\/li>\n\n\n\n<li>If you want the next active cell to be on the right side of the actual one, use the&nbsp;<strong><span class=\"shortcut\">Tab<\/span><\/strong>&nbsp;key,<\/li>\n\n\n\n<li>Use&nbsp;<strong><span class=\"shortcut\">Shift + Enter<\/span><\/strong>&nbsp;to activate the cell above,<\/li>\n\n\n\n<li>Use&nbsp;<strong><span class=\"shortcut\">Shift + Tab<\/span><\/strong>&nbsp;to activate the cell which is located to the left of the current one.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading format\">Editing the contents of a cell<\/h2>\n\n\n\n<p>There are two ways to edit the contents of a cell:<\/p>\n\n\n\n<ul>\n<li><strong>Double-Click<\/strong>: Double-click the cell you want to edit. The cursor will appear where you clicked. If you single-click, the existing content will clear as you start typing.<\/li>\n\n\n\n<li><strong>Formula Bar<\/strong>: Click the cell with content, and place the cursor in the Formula Bar where you want to edit data.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<p>If you want to exit the edit mode without confirming the changes, press the&nbsp;ESC&nbsp;key.<\/p>\n<cite>TIP<\/cite><\/blockquote>\n\n\n\n<p>By incorporating this additional information, your article will provide a more comprehensive understanding of entering, editing, and managing data in Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel 365 Update<\/h2>\n\n\n\n<ul>\n<li><strong>AutoSave:<\/strong>&nbsp;Excel 365 offers continuous saving by default, eliminating the risk of losing work due to unexpected shutdowns.&nbsp;<a target=\"_blank\" rel=\"noreferrer noopener\" href=\"https:\/\/support.microsoft.com\/en-gb\/office\/how-do-i-turn-on-autosave-dbd19b49-ff3a-48f5-8294-671e33a6712c\">https:\/\/support.microsoft.com\/en-gb\/office\/how-do-i-turn-on-autosave-dbd19b49-ff3a-48f5-8294-671e33a6712c<\/a><\/li>\n\n\n\n<li><strong>Real-time Collaboration:<\/strong>&nbsp;Multiple users can now edit the same Excel workbook simultaneously, allowing for collaborative data entry and updates.&nbsp;<a target=\"_blank\" rel=\"noreferrer noopener\" href=\"https:\/\/support.microsoft.com\/en-gb\/office\/co-author-a-workbook-66ad7ca3-3818-46ac-be5b-6c8dbea8a93e\">https:\/\/support.microsoft.com\/en-gb\/office\/co-author-a-workbook-66ad7ca3-3818-46ac-be5b-6c8dbea8a93e<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>If you want to enter information inside a cell, first you need to click the cell to make it active. You can use&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Entering and Editing Data<\/title>\n<meta name=\"description\" content=\"Learn how to enter and edit data in Excel cells. Click on the cell to make it active, then start typing, or use the Formula Bar. Confirm input in four different ways.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Entering and Editing Data\" \/>\n<meta property=\"og:description\" content=\"Learn how to enter and edit data in Excel cells. Click on the cell to make it active, then start typing, or use the Formula Bar. Confirm input in four different ways.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-28T11:25:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-30T00:38:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Entering and Editing Data\",\"datePublished\":\"2018-06-28T11:25:03+00:00\",\"dateModified\":\"2024-03-30T00:38:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/\"},\"wordCount\":354,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/\",\"url\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/\",\"name\":\"Entering and Editing Data\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png\",\"datePublished\":\"2018-06-28T11:25:03+00:00\",\"dateModified\":\"2024-03-30T00:38:46+00:00\",\"description\":\"Learn how to enter and edit data in Excel cells. Click on the cell to make it active, then start typing, or use the Formula Bar. Confirm input in four different ways.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Entering and Editing Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Entering and Editing Data","description":"Learn how to enter and edit data in Excel cells. Click on the cell to make it active, then start typing, or use the Formula Bar. Confirm input in four different ways.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/","og_locale":"en_US","og_type":"article","og_title":"Entering and Editing Data","og_description":"Learn how to enter and edit data in Excel cells. Click on the cell to make it active, then start typing, or use the Formula Bar. Confirm input in four different ways.","og_url":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/","article_published_time":"2018-06-28T11:25:03+00:00","article_modified_time":"2024-03-30T00:38:46+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Entering and Editing Data","datePublished":"2018-06-28T11:25:03+00:00","dateModified":"2024-03-30T00:38:46+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/"},"wordCount":354,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png","keywords":["pinterest"],"articleSection":["training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/","url":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/","name":"Entering and Editing Data","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png","datePublished":"2018-06-28T11:25:03+00:00","dateModified":"2024-03-30T00:38:46+00:00","description":"Learn how to enter and edit data in Excel cells. Click on the cell to make it active, then start typing, or use the Formula Bar. Confirm input in four different ways.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/active-cell.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/training\/methods-for-entering-and-editing-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Entering and Editing Data"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/491"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=491"}],"version-history":[{"count":7,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/491\/revisions"}],"predecessor-version":[{"id":17241,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/491\/revisions\/17241"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}