{"id":2095,"date":"2023-10-18T02:34:04","date_gmt":"2023-10-18T02:34:04","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/linea-2\/"},"modified":"2023-12-10T06:27:22","modified_gmt":"2023-12-10T06:27:22","slug":"linea-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/linea-2\/","title":{"rendered":"Cos&#39;\u00e8 una riga in excel?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-3634337623\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <h2 class=\"wp-block-heading\">Riga in Excel<\/h2><p> Una riga in Excel \u00e8 un allineamento orizzontale di celle e si estende da sinistra a destra nel foglio di lavoro. Ogni linea \u00e8 identificata dal numero univoco sul lato sinistro da dove \u00e8 iniziata. Il numero totale di righe presenti in un singolo foglio \u00e8 1.048.576. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78175\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"riga1 in Excel\" width=\"637\" height=\"269\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Seleziona una riga<\/h2><p> Per selezionare una riga, fai semplicemente clic sull&#8217;intestazione della riga in cui hai un valore numerico. Quindi selezioner\u00e0 l&#8217;intera riga dalla prima cella all&#8217;ultima. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78176\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionnez-la-ligne-de-len-tete.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-header-row\" width=\"608\" height=\"287\"><\/figure><\/div><p> Un altro modo per selezionare l&#8217;intera colonna \u00e8 utilizzare la scorciatoia da tastiera. Innanzitutto, seleziona una delle celle nella riga che desideri selezionare. Quindi, tieni premuto Maiusc e premi la barra spaziatrice. Ora questo selezioner\u00e0 l&#8217;intera riga.<\/p><h2 class=\"wp-block-heading\"> Fare riferimento a una riga in Excel<\/h2><p> Come puoi vedere nell&#8217;istantanea sopra, ogni riga ha il suo numero univoco, che inizia con 1. E, per fare riferimento a una riga, devi utilizzare il suo numero. Quindi se vuoi fare riferimento alla linea 1, dovresti usare questo indirizzo come 2:2. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78177\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-referents-simple-rangee.png\" sizes=\"auto, \" srcset=\"\" alt=\"riferito ad una sola riga\" width=\"440\" height=\"364\"><\/figure><\/div><p> Puoi vedere nell&#8217;esempio sopra che ci riferiamo alla riga 1 utilizzando il suo indirizzo nella funzione somma. Ora, se vuoi fare riferimento a pi\u00f9 righe, devi utilizzare un indirizzo che faccia riferimento a pi\u00f9 righe. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78178\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-se-referant-a-plusieurs-lignes-continues.png\" sizes=\"auto, \" srcset=\"\" alt=\"riferimento-pi\u00f9-linee-continue\" width=\"453\" height=\"392\"><\/figure><\/div><p> Nell&#8217;esempio sopra ci riferiamo alle tre linee da 2 a 4 e nell&#8217;indirizzo abbiamo utilizzato la funzione somma (2:4) che significa dalla linea 2 alla linea 4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78179\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-lignes-non-continues-referentes.png\" sizes=\"auto, \" srcset=\"\" alt=\"riferimento a linee non continue\" width=\"462\" height=\"403\"><\/figure><\/div><p> Infine, ci riferiamo a tre righe non continue e per riferirci a queste righe abbiamo utilizzato il loro indirizzo separatamente inserendo una virgola tra di loro.<\/p><h2 class=\"wp-block-heading\"> Qual \u00e8 l&#8217;ultima riga in Excel<\/h2><p> In un singolo foglio di calcolo sono presenti complessivamente 1.048.576 righe. E il numero dell&#8217;ultima riga in Excel \u00e8 1.048.576. Questo numero \u00e8 fisso e non puoi aggiungere pi\u00f9 righe a un foglio. Se vuoi aggiungere pi\u00f9 dati, devi inserire un nuovo foglio di lavoro che avr\u00e0 anch&#8217;esso lo stesso numero di righe. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78180\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-derniere-ligne-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"ultima riga nel foglio di calcolo Excel\" width=\"443\" height=\"191\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/it\/nozioni-di-base-su-excel\/\">Nozioni di base su Microsoft Excel (componenti, parti e note informative)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial correlati <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/it\/colonna-2\/\">Cos&#8217;\u00e8 una colonna in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/mostra-linee\/\">Mostra righe in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/allineare\/\">Intervallo in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/selezionare-lintervallo\/\">Seleziona l&#8217;intervallo in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/cellula-attiva\/\">Attiva la cella in Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2095","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cos&#039;\u00e8 una riga in Excel? \u2013 Consulente Excel<\/title>\n<meta name=\"description\" content=\"In questo tutorial impareremo cos&#039;\u00e8 una riga in Excel, cos&#039;\u00e8 e come fare riferimento a una riga in una funzione.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/it\/linea-2\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cos&#039;\u00e8 una riga in Excel? \u2013 Consulente Excel\" \/>\n<meta property=\"og:description\" content=\"In questo tutorial impareremo cos&#039;\u00e8 una riga in Excel, cos&#039;\u00e8 e come fare riferimento a una riga in una funzione.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/linea-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:27:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/linea-2\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/linea-2\/\",\"name\":\"Cos&#39;\u00e8 una riga in Excel? \u2013 Consulente Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/linea-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/linea-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png\",\"datePublished\":\"2023-10-18T02:34:04+00:00\",\"dateModified\":\"2023-12-10T06:27:22+00:00\",\"description\":\"In questo tutorial impareremo cos&#39;\u00e8 una riga in Excel, cos&#39;\u00e8 e come fare riferimento a una riga in una funzione.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/linea-2\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/linea-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/linea-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/linea-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cos&#39;\u00e8 una riga in excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cos&#39;\u00e8 una riga in Excel? \u2013 Consulente Excel","description":"In questo tutorial impareremo cos&#39;\u00e8 una riga in Excel, cos&#39;\u00e8 e come fare riferimento a una riga in una funzione.","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:\/\/exceladvisor.org\/it\/linea-2\/","og_locale":"it_IT","og_type":"article","og_title":"Cos&#39;\u00e8 una riga in Excel? \u2013 Consulente Excel","og_description":"In questo tutorial impareremo cos&#39;\u00e8 una riga in Excel, cos&#39;\u00e8 e come fare riferimento a una riga in una funzione.","og_url":"https:\/\/exceladvisor.org\/it\/linea-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:27:22+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/linea-2\/","url":"https:\/\/exceladvisor.org\/it\/linea-2\/","name":"Cos&#39;\u00e8 una riga in Excel? \u2013 Consulente Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/linea-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/linea-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png","datePublished":"2023-10-18T02:34:04+00:00","dateModified":"2023-12-10T06:27:22+00:00","description":"In questo tutorial impareremo cos&#39;\u00e8 una riga in Excel, cos&#39;\u00e8 e come fare riferimento a una riga in una funzione.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/linea-2\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/linea-2\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/linea-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ligne1-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/linea-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Cos&#39;\u00e8 una riga in excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=2095"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2095\/revisions"}],"predecessor-version":[{"id":2887,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2095\/revisions\/2887"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=2095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}