{"id":144,"date":"2025-11-02T09:05:31","date_gmt":"2025-11-02T07:05:31","guid":{"rendered":"https:\/\/darkparrot.joton.dev\/?page_id=144"},"modified":"2025-11-02T09:08:10","modified_gmt":"2025-11-02T07:08:10","slug":"excel-adres-wzgledny-i-bezwgledny","status":"publish","type":"page","link":"https:\/\/darkparrot.joton.dev\/?page_id=144","title":{"rendered":"Excel &#8211; adres wzgl\u0119dny i bezwgl\u0119dny"},"content":{"rendered":"\n<h5 class=\"wp-block-heading\">\ud83d\udcb2 Co oznacza znak dolara w Excelu?<\/h5>\n\n\n\n<p>W Excelu adres kom\u00f3rki ma posta\u0107:<br><code>Litera kolumny + numer wiersza<\/code><br>np. <code>A1<\/code>, <code>B2<\/code>, <code>C10<\/code>.<\/p>\n\n\n\n<p>Dodaj\u0105c <strong>$<\/strong> przed kolumn\u0105 i\/lub wierszem, <strong>blokujesz<\/strong> t\u0119 cz\u0119\u015b\u0107 adresu.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h6 class=\"wp-block-heading\">\ud83d\udd39 1. <code>$A$1<\/code> \u2013 adres bezwzgl\u0119dny (pe\u0142na blokada)<\/h6>\n\n\n\n<p>\u27a1\ufe0f Kolumna <strong>A<\/strong> i wiersz <strong>1<\/strong> s\u0105 zablokowane.<br>Niezale\u017cnie, gdzie skopiujesz formu\u0142\u0119, zawsze b\u0119dzie odwo\u0142ywa\u0107 si\u0119 do kom\u00f3rki <strong>A1<\/strong>.<\/p>\n\n\n\n<p><strong>Przyk\u0142ad:<\/strong><br>Formu\u0142a w <code>B2<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=$A$1*2\n<\/code><\/pre>\n\n\n\n<p>Skopiowana do <code>C5<\/code> nadal odwo\u0142uje si\u0119 do <code>A1<\/code>.<\/p>\n\n\n\n<p>\ud83d\udcd8 U\u017cycie: sta\u0142a warto\u015b\u0107, np. kurs waluty, stawka VAT, sta\u0142y wsp\u00f3\u0142czynnik.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h6 class=\"wp-block-heading\">\ud83d\udd39 2. <code>$A1<\/code> \u2013 blokada kolumny, wiersz zmienny<\/h6>\n\n\n\n<p>\u27a1\ufe0f Kolumna <strong>A<\/strong> jest zablokowana, ale wiersz zmienia si\u0119 przy kopiowaniu w d\u00f3\u0142.<\/p>\n\n\n\n<p><strong>Przyk\u0142ad:<\/strong><br>Formu\u0142a w <code>B2<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=$A1*2\n<\/code><\/pre>\n\n\n\n<p>Skopiowana do <code>B3<\/code> zmieni si\u0119 na:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=$A2*2\n<\/code><\/pre>\n\n\n\n<p>\ud83d\udcd8 U\u017cycie: gdy chcesz, \u017ceby formu\u0142a zawsze bra\u0142a dane z kolumny A, ale z innego wiersza.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h6 class=\"wp-block-heading\">\ud83d\udd39 3. <code>A$1<\/code> \u2013 blokada wiersza, kolumna zmienna<\/h6>\n\n\n\n<p>\u27a1\ufe0f Wiersz <strong>1<\/strong> zablokowany, kolumna zmienia si\u0119 przy kopiowaniu w prawo.<\/p>\n\n\n\n<p><strong>Przyk\u0142ad:<\/strong><br>Formu\u0142a w <code>B2<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=A$1*2\n<\/code><\/pre>\n\n\n\n<p>Skopiowana do <code>C2<\/code> zmieni si\u0119 na:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=B$1*2\n<\/code><\/pre>\n\n\n\n<p>\ud83d\udcd8 U\u017cycie: np. gdy pierwszy wiersz zawiera nag\u0142\u00f3wki lub wsp\u00f3\u0142czynniki.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h6 class=\"wp-block-heading\">\ud83d\udd39 4. <code>A1<\/code> \u2013 adres wzgl\u0119dny (bez dolar\u00f3w)<\/h6>\n\n\n\n<p>\u27a1\ufe0f Zmienia si\u0119 przy ka\u017cdym kopiowaniu \u2014 zar\u00f3wno kolumna, jak i wiersz.<\/p>\n\n\n\n<p><strong>Przyk\u0142ad:<\/strong><br>Formu\u0142a w <code>B2<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=A1*2\n<\/code><\/pre>\n\n\n\n<p>Skopiowana do <code>C3<\/code> zmieni si\u0119 automatycznie na:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=B2*2\n<\/code><\/pre>\n\n\n\n<p>\ud83d\udcd8 U\u017cycie: najcz\u0119stsze \u2013 w obliczeniach w tabelach.<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">\ud83c\udfaf Podsumowanie<\/h6>\n\n\n<table class=\"has-fixed-layout\">\n<thead>\n<tr>\n<th class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki nag\u0142\u00f3wka\">Zapis<\/div>\n<\/th>\n<th class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki nag\u0142\u00f3wka\">Typ adresu<\/div>\n<\/th>\n<th class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki nag\u0142\u00f3wka\">Co jest zablokowane?<\/div>\n<\/th>\n<th class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki nag\u0142\u00f3wka\">Przyk\u0142ad zastosowania<\/div>\n<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\"><code>A1<\/code><\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">wzgl\u0119dny<\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">nic<\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">typowe obliczenia<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\"><code>$A$1<\/code><\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">bezwzgl\u0119dny<\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">kolumna i wiersz<\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">sta\u0142a warto\u015b\u0107 (np. VAT)<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\"><code>$A1<\/code><\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">mieszany<\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">kolumna<\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">por\u00f3wnania w pionie<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\"><code>A$1<\/code><\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">mieszany<\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">wiersz<\/div>\n<\/td>\n<td class=\"wp-block-table__cell-content\">\n<div class=\"block-editor-rich-text__editable rich-text\" role=\"textbox\" contenteditable=\"true\" aria-multiline=\"true\" aria-label=\"Tre\u015b\u0107 kom\u00f3rki\">por\u00f3wnania w poziomie<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h6 class=\"wp-block-heading\">\ud83d\udcd7 <strong>Wskaz\u00f3wka<\/strong><\/h6>\n\n\n\n<p>W Excelu mo\u017cesz <strong>szybko zmienia\u0107 typ adresu<\/strong> po zaznaczeniu kom\u00f3rki w formule i naci\u015bni\u0119ciu <strong>klawisza F4<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pierwsze naci\u015bni\u0119cie \u2192 <code>$A$1<\/code><\/li>\n\n\n\n<li>Drugie \u2192 <code>A$1<\/code><\/li>\n\n\n\n<li>Trzecie \u2192 <code>$A1<\/code><\/li>\n\n\n\n<li>Czwarte \u2192 <code>A1<\/code><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\ud83d\udcb2 Co oznacza znak dolara w Excelu? W Excelu adres kom\u00f3rki ma posta\u0107:Litera kolumny + numer wierszanp. A1, B2, C10. Dodaj\u0105c $ przed kolumn\u0105 i\/lub wierszem, blokujesz t\u0119 cz\u0119\u015b\u0107 adresu. \ud83d\udd39 1. $A$1 \u2013 adres bezwzgl\u0119dny (pe\u0142na blokada) \u27a1\ufe0f Kolumna A i wiersz 1 s\u0105 zablokowane.Niezale\u017cnie, gdzie skopiujesz formu\u0142\u0119, zawsze b\u0119dzie odwo\u0142ywa\u0107 si\u0119 do kom\u00f3rki [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_frontis_meta_header_display":false,"_frontis_meta_footer_display":false,"_frontis_meta_site_title_display":false,"_frontis_meta_sticky_header":false,"_frontis_meta_transparent_header":false,"_frontis_meta_lazy_load":false,"_frontis_meta_transparent_bg_color":"","_frontis_meta_sticky_bg_color":"","footnotes":""},"class_list":["post-144","page","type-page","status-publish","hentry"],"fb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false},"fb_author_info":{"name":"znowiec","avatar":"https:\/\/secure.gravatar.com\/avatar\/6f04bafbb8dfaa33c54fa3b62770e50118d815bd85307845bc3577fff518179b?s=96&d=mm&r=g","bio":"","archive_url":"https:\/\/darkparrot.joton.dev\/?author=1","email":"znowiec@gmail.com","latest_post_date":"14 maj 2025"},"fb_category_info":[],"fb_post_tag_info":[],"fb_post_excerpt":"\ud83d\udcb2 Co oznacza znak dolara w Excelu? W Excelu adres kom\u00f3rki ma posta\u0107:Litera kolumny + numer wierszanp. A1, B2, C10. Dodaj\u0105c $ przed kolumn\u0105 i\/lub wierszem, blokujesz t\u0119 cz\u0119\u015b\u0107 adresu. \ud83d\udd39 1. $A$1 \u2013 adres bezwzgl\u0119dny (pe\u0142na blokada) \u27a1\ufe0f Kolumna A i wiersz 1 s\u0105 zablokowane.Niezale\u017cnie, gdzie skopiujesz formu\u0142\u0119, zawsze b\u0119dzie odwo\u0142ywa\u0107 si\u0119 do kom\u00f3rki&hellip;","_links":{"self":[{"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/pages\/144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=144"}],"version-history":[{"count":2,"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/pages\/144\/revisions"}],"predecessor-version":[{"id":148,"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/pages\/144\/revisions\/148"}],"wp:attachment":[{"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}