{"id":103075,"date":"2021-01-19T13:23:26","date_gmt":"2021-01-19T07:53:26","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=103075"},"modified":"2024-04-12T14:26:18","modified_gmt":"2024-04-12T08:56:18","slug":"manipulating-data","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/","title":{"rendered":"Manipulating Data"},"content":{"rendered":"\n<p>Excel allows you to move, copy, and paste cells and cell content through cutting and pasting and copying and pasting.<\/p>\n\n\n\n<p><strong>Select Data<\/strong><\/p>\n\n\n\n<p>To select a cell or data to be copied or cut:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Click the <strong>cell<\/strong><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image171.jpg\" alt=\"\" class=\"wp-image-94473\"\/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Click and drag the cursor to select many cells in a range<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image172.jpg\" alt=\"\" class=\"wp-image-94474\"\/><\/figure><\/div>\n\n\n\n<p><strong>Select a Row or Column<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>To select a row or column click on the <strong>row <\/strong>or <strong>column header<\/strong><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image173.jpg\" alt=\"\" class=\"wp-image-94475\"\/><\/figure><\/div>\n\n\n\n<p><strong>Copy and Paste<\/strong><\/p>\n\n\n\n<p>To copy and paste data:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Select the cells(s) that you wish to copy<\/li><li>One the <strong>Clipboard<\/strong> group of the <strong>Home<\/strong> tab, click <strong>Copy<\/strong><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image175.jpg\" alt=\"\" class=\"wp-image-94476\"\/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Select the cell(s) where you would like to copy the data<\/li><li>One the <strong>Clipboard <\/strong>group of the <strong>Home<\/strong> tab, click <strong>Cut<\/strong><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image175.jpg\" alt=\"\" class=\"wp-image-94476\"\/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Select the cell(s) that you wish to copy the data<\/li><li>On the <strong>Clipboard<\/strong> group of the <strong>Home<\/strong> tab, click <strong>Paste<\/strong><\/li><\/ul>\n\n\n\n<p><strong>Undo and Redo<\/strong><\/p>\n\n\n\n<p>To undo or re-do your most recent actions:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>On the <strong>Quick Access Toolbar<\/strong><\/li><li>Click <strong>Undo<\/strong> or <strong>Redo<\/strong><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image176.jpg\" alt=\"\" class=\"wp-image-94477\"\/><\/figure><\/div>\n\n\n\n<p><strong>Auto Fill<\/strong><\/p>\n\n\n\n<p>The Auto Fill feature fills cell data or series of data in a worksheet into a selected range of cells. If you want the same data copied into the other cells, you only need to complete one cell.&nbsp; If you want to have a series of data (for example, days of the week) fill in the first two cells in the series and then use the auto fill feature. To use the Auto Fill feature:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Click the <strong>Fill Handle<\/strong><\/li><li><strong>Drag<\/strong> the <strong>Fill Handle<\/strong> to complete the cells<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image177.jpg\" alt=\"\" class=\"wp-image-94478\"\/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Excel allows you to move, copy, and paste cells and cell content through cutting and pasting and copying and pasting. Select Data To select a cell or data to be copied or cut: Click the cell Click and drag the cursor to select many cells in a range Select a Row or Column To select&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-103075","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Manipulating Data - Tutorial<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Manipulating Data - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Excel allows you to move, copy, and paste cells and cell content through cutting and pasting and copying and pasting. Select Data To select a cell or data to be copied or cut: Click the cell Click and drag the cursor to select many cells in a range Select a Row or Column To select...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:56:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image171.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/\",\"name\":\"Manipulating Data - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image171.jpg\",\"datePublished\":\"2021-01-19T07:53:26+00:00\",\"dateModified\":\"2024-04-12T08:56:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/#primaryimage\",\"url\":\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image171.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image171.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Manipulating Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Manipulating Data - Tutorial","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:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/","og_locale":"en_US","og_type":"article","og_title":"Manipulating Data - Tutorial","og_description":"Excel allows you to move, copy, and paste cells and cell content through cutting and pasting and copying and pasting. Select Data To select a cell or data to be copied or cut: Click the cell Click and drag the cursor to select many cells in a range Select a Row or Column To select...","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:56:18+00:00","og_image":[{"url":"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image171.jpg","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/","name":"Manipulating Data - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image171.jpg","datePublished":"2021-01-19T07:53:26+00:00","dateModified":"2024-04-12T08:56:18+00:00","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/#primaryimage","url":"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image171.jpg","contentUrl":"https:\/\/www.vskills.in\/lms\/wp-content\/uploads\/2017\/08\/image171.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/manipulating-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Manipulating Data"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/103075","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=103075"}],"version-history":[{"count":1,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/103075\/revisions"}],"predecessor-version":[{"id":103076,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/103075\/revisions\/103076"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=103075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=103075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=103075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}