Untuk mengunci rumus di excel

Untuk mengunci rumus di excel

  window['__wavt'] = 'AOuZoY44lWh4hhI0AtL_l3XHFrVPGqdQww:1665620631659';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d4480054309899695002','//www.sobat-tutorial.com/2021/11/cara-mengunci-rumus-di-excel.html','4480054309899695002'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '4480054309899695002', 'title': 'Sobat-Tutorial', 'url': 'https://www.sobat-tutorial.com/2021/11/cara-mengunci-rumus-di-excel.html', 'canonicalUrl': 'https://www.sobat-tutorial.com/2021/11/cara-mengunci-rumus-di-excel.html', 'homepageUrl': 'https://www.sobat-tutorial.com/', 'searchUrl': 'https://www.sobat-tutorial.com/search', 'canonicalHomepageUrl': 'https://www.sobat-tutorial.com/', 'blogspotFaviconUrl': 'https://www.sobat-tutorial.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-195699183-1', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Sobat-Tutorial - Atom\x22 href\x3d\x22https://www.sobat-tutorial.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Sobat-Tutorial - RSS\x22 href\x3d\x22https://www.sobat-tutorial.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Sobat-Tutorial - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/4480054309899695002/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Sobat-Tutorial - Atom\x22 href\x3d\x22https://www.sobat-tutorial.com/feeds/2390474738196231654/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-3012863392330552', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/6dda3217c907b8b6', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '2390474738196231654', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/a/AVvXsEg56z78WFEjtl7jpBfQSBRJ8VTxZbzwUOSVEpCVsx-SHoTGwuG_Fh5W6LRnOCrWywaQwmdquuLOg1aOXzf1UAWxUQIqrylyEsoW6EpZjbieE02drrR_D_71XjGgPRbJ2ct4NjKGuURlnUDOrK42_Qko2LMb_N1seg5EsDXqdesGytvwsau0GGK-jpyD\x3ds72-w320-c-h218', 'postImageUrl': 'https://blogger.googleusercontent.com/img/a/AVvXsEg56z78WFEjtl7jpBfQSBRJ8VTxZbzwUOSVEpCVsx-SHoTGwuG_Fh5W6LRnOCrWywaQwmdquuLOg1aOXzf1UAWxUQIqrylyEsoW6EpZjbieE02drrR_D_71XjGgPRbJ2ct4NjKGuURlnUDOrK42_Qko2LMb_N1seg5EsDXqdesGytvwsau0GGK-jpyD\x3dw320-h218', 'pageName': 'Cara Mengunci Rumus di Excel Agar Tidak Bergeser', 'pageTitle': 'Sobat-Tutorial: Cara Mengunci Rumus di Excel Agar Tidak Bergeser', 'metaDescription': 'Ada baiknya jika Anda mengunci rumus di excel agar rumus yang sudah dibuat tidak dapat bergeser dan berubah.'}}, {'name': 'features', 'data': {'sharing_get_link_dialog': 'true', 'sharing_native': 'false'}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Cara Mengunci Rumus di Excel Agar Tidak Bergeser', 'description': 'Ada baiknya jika Anda mengunci rumus di excel agar rumus yang sudah dibuat tidak dapat bergeser dan berubah.', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEg56z78WFEjtl7jpBfQSBRJ8VTxZbzwUOSVEpCVsx-SHoTGwuG_Fh5W6LRnOCrWywaQwmdquuLOg1aOXzf1UAWxUQIqrylyEsoW6EpZjbieE02drrR_D_71XjGgPRbJ2ct4NjKGuURlnUDOrK42_Qko2LMb_N1seg5EsDXqdesGytvwsau0GGK-jpyD\x3dw320-h218', 'url': 'https://www.sobat-tutorial.com/2021/11/cara-mengunci-rumus-di-excel.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 2390474738196231654}}, {'name': 'widgets', 'data': [{'title': 'Kode Pengaturan Template', 'type': 'HTML', 'sectionId': 'template-settings', 'id': 'HTML711'}, {'title': 'Custom CSS', 'type': 'HTML', 'sectionId': 'custom-css', 'id': 'HTML712'}, {'title': 'Sobat-Tutorial (Header)', 'type': 'Header', 'sectionId': 'header', 'id': 'Header1'}, {'title': 'Kode Menu Navigasi', 'type': 'HTML', 'sectionId': 'navmenu', 'id': 'HTML642'}, {'title': 'Widget HTML #1', 'type': 'HTML', 'sectionId': 'bellow-header-widget', 'id': 'HTML619'}, {'title': 'Widget HTML #2 (homepage)', 'type': 'HTML', 'sectionId': 'bellow-header-widget2', 'id': 'HTML616'}, {'title': 'Widget HTML #3 (homepage)', 'type': 'HTML', 'sectionId': 'above-post-widget', 'id': 'HTML421'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'main', 'id': 'Blog1', 'posts': [{'id': '2390474738196231654', 'title': 'Cara Mengunci Rumus di Excel Agar Tidak Bergeser', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEg56z78WFEjtl7jpBfQSBRJ8VTxZbzwUOSVEpCVsx-SHoTGwuG_Fh5W6LRnOCrWywaQwmdquuLOg1aOXzf1UAWxUQIqrylyEsoW6EpZjbieE02drrR_D_71XjGgPRbJ2ct4NjKGuURlnUDOrK42_Qko2LMb_N1seg5EsDXqdesGytvwsau0GGK-jpyD\x3dw320-h218', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': 'Oleh'}, {'name': 'timestamp', 'label': 'pada tanggal'}, {'name': 'comments', 'label': 'Comments'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Tags'}]}], 'allBylineItems': [{'name': 'author', 'label': 'Oleh'}, {'name': 'timestamp', 'label': 'pada tanggal'}, {'name': 'comments', 'label': 'Comments'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': 'Tags'}]}, {'title': 'Iklan Atas Artikel', 'type': 'HTML', 'sectionId': 'iklan-atas', 'id': 'HTML996'}, {'title': 'Iklan Tengah Artikel 1', 'type': 'HTML', 'sectionId': 'iklan-tengah2', 'id': 'HTML997'}, {'title': 'Iklan Tengah Artikel 2', 'type': 'HTML', 'sectionId': 'iklan-tengah2', 'id': 'HTML998'}, {'title': 'Iklan Bawah Artikel', 'type': 'HTML', 'sectionId': 'iklan-bawah', 'id': 'HTML999'}, {'title': 'Iklan Matched Content', 'type': 'HTML', 'sectionId': 'matched-content', 'id': 'HTML939'}, {'title': 'Iklan In-Feed (homepage)', 'type': 'HTML', 'sectionId': 'iklan-infeed', 'id': 'HTML952'}, {'title': '', 'type': 'HTML', 'sectionId': 'sidebar-sticky', 'id': 'HTML1'}, {'title': 'Kode Icon Media Sosial', 'type': 'HTML', 'sectionId': 'footer-widget-container', 'id': 'HTML637'}, {'title': 'Menu Halaman Statis', 'type': 'PageList', 'sectionId': 'footer-navmenu', 'id': 'PageList1'}, {'title': 'Teks Footer', 'type': 'HTML', 'sectionId': 'footer-container', 'id': 'HTML781'}, {'title': 'Custom JavaScript Footer', 'type': 'HTML', 'sectionId': 'custom-javascript-footer', 'id': 'HTML782'}]}]); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML711', 'template-settings', document.getElementById('HTML711'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML712', 'custom-css', document.getElementById('HTML712'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'header', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML642', 'navmenu', document.getElementById('HTML642'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML619', 'bellow-header-widget', document.getElementById('HTML619'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML616', 'bellow-header-widget2', document.getElementById('HTML616'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML421', 'above-post-widget', document.getElementById('HTML421'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'main', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2891629720-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/3523451998-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML996', 'iklan-atas', document.getElementById('HTML996'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML997', 'iklan-tengah2', document.getElementById('HTML997'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML998', 'iklan-tengah2', document.getElementById('HTML998'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML999', 'iklan-bawah', document.getElementById('HTML999'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML939', 'matched-content', document.getElementById('HTML939'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML952', 'iklan-infeed', document.getElementById('HTML952'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'sidebar-sticky', document.getElementById('HTML1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML637', 'footer-widget-container', document.getElementById('HTML637'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'footer-navmenu', document.getElementById('PageList1'), {'title': 'Menu Halaman Statis', 'links': [{'isCurrentPage': false, 'href': 'http://www.sobat-tutorial.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'https://www.sobat-tutorial.com/p/about.html', 'id': '3965008305155860960', 'title': 'About'}, {'isCurrentPage': false, 'href': 'https://www.sobat-tutorial.com/p/contact-from.html', 'id': '7329249319797838445', 'title': 'Contact From'}, {'isCurrentPage': false, 'href': 'https://www.sobat-tutorial.com/p/kebijakan-privasi.html', 'id': '1165300369733531422', 'title': 'Kebijakan Privasi'}, {'isCurrentPage': false, 'href': 'https://www.sobat-tutorial.com/p/disclamer.html', 'id': '210741168472217755', 'title': 'Disclaimer'}], 'mobile': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML781', 'footer-container', document.getElementById('HTML781'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML782', 'custom-javascript-footer', document.getElementById('HTML782'), {}, 'displayModeFull'));

Bagaimana mengunci rumus di Excel?

Untuk mengunci sel.
Pilih sel yang ingin dikunci..
Pada menu Format, klik Sel, atau tekan. ... .
Klik tab Proteksi, lalu pastikan kotak centang Terkunci telah dipilih. ... .
Jika ada sel yang tidak terkunci, pilih sel tersebut. ... .
Pada tab Tinjau, klik Proteksi Lembar atau Proteksi Buku Kerja..

Bagaimana mengunci rumus?

Cara Mengunci, Menyembunyikan, dan Memasang Password pada Rumus excel.
Buka File Excel yang ingin kamu kunci..
Tekan Ctrl+A, lalu klik kanan dan kemudian pilih Format Cells..
Pada tab berjudul Protection, hilangkan tanda centang dari Locked..
Klik OK..

Apa fungsi tombol F4 dalam ms Excel?

Secara umum fungsi dari F4 pada Excel adalah untuk mengubah cell dari Relatif menjadi Absolut atau Semi Absolut.

Kenapa rumus Excel harus dikunci?

Dengan menguncinya, formula tidak akan berubah karena sudah berbentuk absolut. Selain itu, sebaiknya rumus excel juga diberi password agar orang lain yang membuka file anda tidak dengan seenaknya, atau secara tidak sengaja merubah rumus anda.