{"id":17123,"date":"2023-05-08T12:25:25","date_gmt":"2023-05-08T17:25:25","guid":{"rendered":"https:\/\/www.perucontable.com\/excelcontable\/?p=17123"},"modified":"2023-11-13T21:51:29","modified_gmt":"2023-11-14T02:51:29","slug":"como-inmovilizar-columnas-en-excel","status":"publish","type":"post","link":"https:\/\/www.perucontable.com\/excelcontable\/como-inmovilizar-columnas-en-excel\/","title":{"rendered":"Como inmovilizar columnas en excel"},"content":{"rendered":"\n<p>La opci\u00f3n de inmovilizar paneles, mantiene visibles las filas y columnas, mientras el resto de la hoja de c\u00e1lculo se desplaza (a partir de la selecci\u00f3n actual). <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Para empezar, inmovilizaremos una columna de excel, con estos datos que usamos para el ejemplo:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"766\" height=\"251\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-3.png\" alt=\"\" class=\"wp-image-17127\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-3.png 766w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-3-300x98.png 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-3-696x228.png 696w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/figure>\n\n\n\n<p>Lo que queremos hacer, es que se fije la columna de \u00abGastos mensuales\u00bb.<\/p>\n\n\n\n<p><strong>Para ello, realizamos los siguientes pasos:<\/strong><\/p>\n\n\n\n<p>Seleccionamos la columna C:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"776\" height=\"246\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-9.png\" alt=\"\" class=\"wp-image-17133\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-9.png 776w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-9-300x95.png 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-9-768x243.png 768w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-9-696x221.png 696w\" sizes=\"(max-width: 776px) 100vw, 776px\" \/><\/figure>\n\n\n\n<p>Una vez realizado ello, nos dirigimos a la pesta\u00f1a \u00abVista\u00bb, enfocandonos en la opci\u00f3n de \u00abinmovilizar\u00bb. Luego de ello, saldrpan 3 opciones, de las cuales, debes elegir la de \u00abinmovilizar paneles\u00bb. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"1023\" height=\"416\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-10.png\" alt=\"\" class=\"wp-image-17134\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-10.png 1023w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-10-300x122.png 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-10-768x312.png 768w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-10-696x283.png 696w\" sizes=\"(max-width: 1023px) 100vw, 1023px\" \/><\/figure>\n\n\n\n<p>Y como vemos, ya est\u00e1 aplicada la fijaci\u00f3n de inmovilizaci\u00f3n de paneles, la cual separa la columna B y C, permitiendo que se puedan observar los meses de la derecha, paralelamente con la columna B.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"771\" height=\"268\" src=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-11.png\" alt=\"\" class=\"wp-image-17135\" srcset=\"https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-11.png 771w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-11-300x104.png 300w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-11-768x267.png 768w, https:\/\/www.perucontable.com\/excelcontable\/wp-content\/uploads\/2023\/04\/image-11-696x242.png 696w\" sizes=\"(max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u00bfTe gust\u00f3 este articulo? Te leemos. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>La opci\u00f3n de inmovilizar paneles, mantiene visibles las filas y columnas, mientras el resto de la hoja de c\u00e1lculo se desplaza (a partir de la selecci\u00f3n actual). Para empezar, inmovilizaremos una columna de excel, con estos datos que usamos para el ejemplo: Lo que queremos hacer, es que se fije la columna de \u00abGastos mensuales\u00bb. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17136,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[45,67,25],"tags":[478,9,476,475,477],"yst_prominent_words":[189],"_links":{"self":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/17123"}],"collection":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/comments?post=17123"}],"version-history":[{"count":3,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/17123\/revisions"}],"predecessor-version":[{"id":17415,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/posts\/17123\/revisions\/17415"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media\/17136"}],"wp:attachment":[{"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/media?parent=17123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/categories?post=17123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/tags?post=17123"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.perucontable.com\/excelcontable\/wp-json\/wp\/v2\/yst_prominent_words?post=17123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}