{"id":1365,"date":"2019-10-11T18:11:13","date_gmt":"2019-10-11T16:11:13","guid":{"rendered":"http:\/\/www.edukey.pl\/blog\/?p=1365"},"modified":"2019-10-11T18:22:04","modified_gmt":"2019-10-11T16:22:04","slug":"skroty-klawiaturowe-excel-f4-adresowanie-wzgledne-i-bezwzgledne","status":"publish","type":"post","link":"https:\/\/www.edukey.pl\/blog\/skroty-klawiaturowe-excel-f4-adresowanie-wzgledne-i-bezwzgledne\/","title":{"rendered":"Skr\u00f3ty klawiaturowe Excel: F4 (adresowanie wzgl\u0119dne i bezwzgl\u0119dne)"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\"  style='background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;'><div class=\"fusion-builder-row fusion-row \"><div  class=\"fusion-layout-column fusion_builder_column fusion_builder_column_1_1 fusion-builder-column-1 fusion-one-full fusion-column-first fusion-column-last 1_1\"  style='margin-top:0px;margin-bottom:20px;'>\n\t\t\t\t\t<div class=\"fusion-column-wrapper\" style=\"padding: 0px 0px 0px 0px;background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;\"   data-bg-url=\"\">\n\t\t\t\t\t\t<div class=\"fusion-text\"><blockquote>\n<p><em>Skr\u00f3ty klawiszowe w excelu pozwalaj\u0105 na usprawnienie naszej pracy i zaoszcz\u0119dzenie cennego czasu.<\/em><\/p>\n<\/blockquote>\n<\/div><div class=\"fusion-text\"><p>Adresowanie w Excelu polega na odwo\u0142ywaniu si\u0119 do konkretnych kom\u00f3rek w arkuszu. Dzielimy je na:<\/p>\n<ul>\n<li>wzgl\u0119dne<\/li>\n<li>bezwzgl\u0119dne.<\/li>\n<\/ul>\n<p><strong>Adresowanie wzgl\u0119dne<\/strong> wykorzystuje po\u0142o\u017cenie kom\u00f3rek wzgl\u0119dem siebie, a nie ich adresy. Przy przeci\u0105ganiu formu\u0142y lub kopiowaniu kom\u00f3rki adres w nowych kom\u00f3rkach b\u0119dzie odnosi\u0142 si\u0119 do kom\u00f3rek po\u0142o\u017conych w podobnym miejscu wzgl\u0119dem nowej kom\u00f3rki jak wcze\u015bniej dla kopiowanej kom\u00f3rki (np. kom\u00f3rka po lewej).<\/p>\n<p>W <strong>adresowaniu bezwzgl\u0119dnym<\/strong> istotne s\u0105 konkretne adresy kom\u00f3rek (np. A3). Kom\u00f3rk\u0119 oznaczamy adresowaniem bezwzgl\u0119dnym wprowadzaj\u0105c znak dolara <strong>$<\/strong>.<\/p>\n<\/div><style type=\"text\/css\">@media only screen and (max-width:800px) {.fusion-title.fusion-title-1{margin-top:20px!important;margin-bottom:10px!important;}}<\/style><div class=\"fusion-title title fusion-title-1 fusion-title-size-two\" style=\"margin-top:30px;margin-bottom:10px;\"><h2 class=\"title-heading-left\" style=\"margin:0;\"><span style=\"font-weight: 400;\">Funkcja wywo\u0142ywana u\u017cyciem klawisza <\/span><b>F4<\/b><\/h2><div class=\"title-sep-container\"><div class=\"title-sep sep-single sep-solid\" style=\"border-color:#eaeaea;\"><\/div><\/div><\/div><div class=\"fusion-text\"><p><span style=\"font-weight: 400;\">Powoduje ona dopisanie $ do adresu kom\u00f3rki, co pozwala na szybkie prze\u0142\u0105czanie pomi\u0119dzy adresowaniem wzgl\u0119dnym i bezwgl\u0119dnym. Pierwsze wci\u015bni\u0119cie <\/span><b>F4 <\/b><span style=\"font-weight: 400;\">dopisuje $ do wiersza i kolumny, kolejne wci\u015bni\u0119cie tylko wiersza, kolejne tylko do kolumny, a ostatnie powoduje przywr\u00f3cenie oryginalnego adresu.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Adres kom\u00f3rki:<\/span><\/p>\n<\/div><span style=\"border:1px solid #eaeaea;\" class=\"fusion-imageframe imageframe-none imageframe-1 hover-type-none\"><a href=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n..jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[c4cddbf0bf6769f3427]\" data-title=\"Excel\" title=\"Excel\"><img decoding=\"async\" src=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n..jpg\" width=\"\" height=\"\" alt=\"Excel\" class=\"img-responsive wp-image-1384\" srcset=\"https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n.-200x138.jpg 200w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n.-400x275.jpg 400w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n.-600x413.jpg 600w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n..jpg 653w\" sizes=\"(max-width: 800px) 100vw, 653px\" \/><\/a><\/span><div class=\"fusion-text\"><p><span style=\"font-weight: 400; margin-top: 20px; display: block;\">Po pierwszym u\u017cyciu <b>F4:<\/b><\/span><\/p>\n<\/div><span style=\"border:1px solid #eaeaea;\" class=\"fusion-imageframe imageframe-none imageframe-2 hover-type-none\"><a href=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-2.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[0eaa3b6d5ff1e11285f]\" data-title=\"Skr\u00f3ty komputerowe\" title=\"Skr\u00f3ty komputerowe\"><img decoding=\"async\" src=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-2.jpg\" width=\"\" height=\"\" alt=\"Excel\" class=\"img-responsive wp-image-1387\" srcset=\"https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-2-200x149.jpg 200w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-2-400x298.jpg 400w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-2-600x447.jpg 600w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-2.jpg 777w\" sizes=\"(max-width: 800px) 100vw, 777px\" \/><\/a><\/span><div class=\"fusion-text\"><p><span style=\"font-weight: 400; margin-top: 20px; display: block;\">Kolejne wci\u015bni\u0119cie <b>F4:<\/b><\/span><\/p>\n<\/div><span style=\"border:1px solid #eaeaea;\" class=\"fusion-imageframe imageframe-none imageframe-3 hover-type-none\"><a href=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-3.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[e4ccf8424421cbfb9b0]\" data-title=\"Skr\u00f3ty klawiszowe\" title=\"Skr\u00f3ty klawiszowe\"><img decoding=\"async\" src=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-3.jpg\" width=\"\" height=\"\" alt=\"Excel\" class=\"img-responsive wp-image-1390\" srcset=\"https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-3-200x142.jpg 200w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-3-400x285.jpg 400w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-3-600x427.jpg 600w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-3.jpg 761w\" sizes=\"(max-width: 800px) 100vw, 761px\" \/><\/a><\/span><div class=\"fusion-text\"><p><span style=\"font-weight: 400; margin-top: 20px; display: block;\">Trzecie u\u017cycie:<\/span><\/p>\n<\/div><span style=\"border:1px solid #eaeaea;\" class=\"fusion-imageframe imageframe-none imageframe-4 hover-type-none\"><a href=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-4.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[558410234eb5e161b1b]\" data-title=\"Skr\u00f3ty klawiszowe\" title=\"Skr\u00f3ty klawiszowe\"><img decoding=\"async\" src=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-4.jpg\" width=\"\" height=\"\" alt=\"Excel\" class=\"img-responsive wp-image-1392\" srcset=\"https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-4-200x137.jpg 200w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-4-400x273.jpg 400w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-4-600x410.jpg 600w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-4.jpg 770w\" sizes=\"(max-width: 800px) 100vw, 770px\" \/><\/a><\/span><div class=\"fusion-text\"><p><span style=\"font-weight: 400; margin-top: 20px; display: block;\">Powr\u00f3t do stanu pierwotnego:<\/span><\/p>\n<\/div><span style=\"border:1px solid #eaeaea;\" class=\"fusion-imageframe imageframe-none imageframe-5 hover-type-none\"><a href=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n..jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[c4cddbf0bf6769f3427]\" data-title=\"Excel\" title=\"Excel\"><img decoding=\"async\" src=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n..jpg\" width=\"\" height=\"\" alt=\"Excel\" class=\"img-responsive wp-image-1384\" srcset=\"https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n.-200x138.jpg 200w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n.-400x275.jpg 400w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n.-600x413.jpg 600w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/Blog-n..jpg 653w\" sizes=\"(max-width: 800px) 100vw, 653px\" \/><\/a><\/span><style type=\"text\/css\">@media only screen and (max-width:800px) {.fusion-title.fusion-title-2{margin-top:20px!important;margin-bottom:10px!important;}}<\/style><div class=\"fusion-title title fusion-title-2 fusion-title-size-two\" style=\"margin-top:15px;margin-bottom:5px;\"><h2 class=\"title-heading-left\" style=\"margin:0;\">PS. a wiecie jak pokaza\u0107 w kom\u00f3rce tre\u015b\u0107 formu\u0142y? \ud83d\ude42<\/h2><div class=\"title-sep-container\"><div class=\"title-sep sep-single sep-solid\" style=\"border-color:#eaeaea;\"><\/div><\/div><\/div><div class=\"fusion-text\"><p>Mo\u017cecie to osi\u0105gn\u0105\u0107 dzi\u0119ki u\u017cyciu symbolu: <strong>&rsquo;<\/strong> (pojedynczy apostrof)\u00a0<span style=\"font-weight: 400;\">dodanym na pocz\u0105tku zawarto\u015bci kom\u00f3rki. Pozwala on na zapisanie formu\u0142y lub warto\u015bci matematycznej kom\u00f3rki (np. &#8222;+4&#8221; albo &#8222;=A2*1.23&#8221;) bez ich wykonywania. Przyk\u0142ad:<\/span><\/p>\n<\/div><span style=\"border:1px solid #eaeaea;\" class=\"fusion-imageframe imageframe-none imageframe-6 hover-type-none\"><a href=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-5-o.jpg\" class=\"fusion-lightbox\" data-rel=\"iLightbox[c4860211f540a35500c]\" data-title=\"Skr\u00f3ty klawiszowe\" title=\"Skr\u00f3ty klawiszowe\"><img decoding=\"async\" src=\"http:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-5-o.jpg\" width=\"\" height=\"\" alt=\"Excel\" class=\"img-responsive wp-image-1400\" srcset=\"https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-5-o-200x147.jpg 200w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-5-o-400x295.jpg 400w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-5-o-600x442.jpg 600w, https:\/\/www.edukey.pl\/blog\/wp-content\/uploads\/2019\/09\/blok-n-5-o.jpg 630w\" sizes=\"(max-width: 800px) 100vw, 630px\" \/><\/a><\/span><div class=\"fusion-text\"><p>Po zatwierdzeniu formu\u0142y enterem apostrof zniknie i w kom\u00f3rce b\u0119dzie widoczna sama formu\u0142a jako &#8222;wynik&#8221; formu\u0142y.<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div>\n\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":10,"featured_media":1367,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52],"tags":[137,119],"_links":{"self":[{"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/posts\/1365"}],"collection":[{"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/comments?post=1365"}],"version-history":[{"count":27,"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/posts\/1365\/revisions"}],"predecessor-version":[{"id":1423,"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/posts\/1365\/revisions\/1423"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/media\/1367"}],"wp:attachment":[{"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/media?parent=1365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/categories?post=1365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.edukey.pl\/blog\/wp-json\/wp\/v2\/tags?post=1365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}