{"id":110020,"date":"2021-02-24T12:13:39","date_gmt":"2021-02-24T06:43:39","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=110020"},"modified":"2024-04-12T14:30:51","modified_gmt":"2024-04-12T09:00:51","slug":"selecting-cells-and-data-ranges-2","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/","title":{"rendered":"Selecting cells and data ranges"},"content":{"rendered":"\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>To select<\/strong><\/td><td><strong>Do this<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Text in a cell<\/td><td>If editing in a cell is turned on, select the cell, double-click in it, and then select the text in the cell. &nbsp; If editing in a cell is turned off, select the cell, and then select the text in the formula bar.<\/td><\/tr><tr><td>A single cell<\/td><td>Click the cell, or press the arrow keys to move to the cell.<\/td><\/tr><tr><td>A range of cells<\/td><td>Click the first cell of the range, and then drag to the last cell.<\/td><\/tr><tr><td>All cells on a worksheet<\/td><td>Click the Select All button.<\/td><\/tr><tr><td>Nonadjacent cells or cell ranges<\/td><td>Select the first cell or range of cells, and then hold down CTRL and select the other cells or ranges.<\/td><\/tr><tr><td>A large range of cells<\/td><td>Click first cell in range, and then hold down SHIFT and click the last cell in the range. Scroll to make the last cell visible.<\/td><\/tr><tr><td>An entire row<\/td><td>Click the row heading.<\/td><\/tr><tr><td>An entire column<\/td><td>Click the column heading.<\/td><\/tr><tr><td>Adjacent rows or columns<\/td><td>Drag across the row or column headings. Or select the first row or column; then hold down SHIFT and select the last row or column.<\/td><\/tr><tr><td>Nonadjacent rows or columns<\/td><td>Select the first row or column, and then hold down CTRL and select the other rows or columns.<\/td><\/tr><tr><td>More or fewer cells<\/td><td>Hold SHIFT and click last cell to include in the than the active selection new selection. The rectangular range between the active cell and the cell we click becomes the new selection.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>To select Do this Text in a cell If editing in a cell is turned on, select the cell, double-click in it, and then select the text in the cell. &nbsp; If editing in a cell is turned off, select the cell, and then select the text in the formula bar. A single cell Click&#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-110020","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>Selecting cells and data ranges - 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\/selecting-cells-and-data-ranges-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Selecting cells and data ranges - Tutorial\" \/>\n<meta property=\"og:description\" content=\"To select Do this Text in a cell If editing in a cell is turned on, select the cell, double-click in it, and then select the text in the cell. &nbsp; If editing in a cell is turned off, select the cell, and then select the text in the formula bar. A single cell Click...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/\" \/>\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-12T09:00:51+00:00\" \/>\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\/selecting-cells-and-data-ranges-2\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/\",\"name\":\"Selecting cells and data ranges - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2021-02-24T06:43:39+00:00\",\"dateModified\":\"2024-04-12T09:00:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Selecting cells and data ranges\"}]},{\"@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":"Selecting cells and data ranges - 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\/selecting-cells-and-data-ranges-2\/","og_locale":"en_US","og_type":"article","og_title":"Selecting cells and data ranges - Tutorial","og_description":"To select Do this Text in a cell If editing in a cell is turned on, select the cell, double-click in it, and then select the text in the cell. &nbsp; If editing in a cell is turned off, select the cell, and then select the text in the formula bar. A single cell Click...","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T09:00:51+00:00","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/","name":"Selecting cells and data ranges - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2021-02-24T06:43:39+00:00","dateModified":"2024-04-12T09:00:51+00:00","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/selecting-cells-and-data-ranges-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Selecting cells and data ranges"}]},{"@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\/110020","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=110020"}],"version-history":[{"count":1,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/110020\/revisions"}],"predecessor-version":[{"id":110021,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/110020\/revisions\/110021"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=110020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=110020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=110020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}