www.exceldemy.com
Open in
urlscan Pro
2606:4700:3033::6815:cba
Public Scan
URL:
https://www.exceldemy.com/freeze-rows-and-columns-at-the-same-time/
Submission: On June 13 via manual from BR — Scanned from DE
Submission: On June 13 via manual from BR — Scanned from DE
Form analysis 4 forms found in the DOM
GET https://www.exceldemy.com/
<form role="search" method="get" class="search-form" action="https://www.exceldemy.com/">
<input type="text" name="s" placeholder="Search" data-posttype="post">
<input type="hidden" name="post_type" value="post"> <button type="submit" class="btnsearch hideonmobile" aria-label="Search"><i class="rhicon rhi-search"></i></button>
</form>POST https://www.exceldemy.com/wp-comments-post.php
<form action="https://www.exceldemy.com/wp-comments-post.php" method="post" id="commentform" class="comment-form"><textarea id="comment" name="comment" cols="30" rows="10" aria-required="true" aria-label="comment"></textarea>
<div class="usr_re"><input id="author" type="text" value="" name="author" placeholder="Name"></div>
<div class="email_re"><input id="email" type="text" value="" name="email" placeholder="E-mail"></div>
<div class="site_re end"><input id="url" type="text" value="" name="url" placeholder="Website"></div>
<div class="clearfix"></div>
<p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Submit"> <input type="hidden" name="comment_post_ID" value="57244" id="comment_post_ID">
<input type="hidden" name="comment_parent" id="comment_parent" value="0">
</p>
<p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="49797db776"></p>
<p style="display: none !important;"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="98">
<script type="rocketlazyloadscript">document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() );</script>
</p>
</form>POST
<form class="cpro-form" method="post">
<input type="hidden" class="panel-settings" data-style_id="382411" data-section="configure"
value="{"enable_custom_cookies":"","enable_cookies_class":"","enable_adblock_detection":"","enable_visitors":"","visitor_type":"first-time","referrer_type":"hide-from","hide_custom_cookies":"","hide_cookies_class":"","show_for_logged_in":"1","hide_on_device":"","cookies_enabled":"1","conversion_cookie":"365","closed_cookie":"30","cookies_enabled_submit":"","enable_cookies_class_submit":"","conversion_cookie_submit":"90","cookies_enabled_closed":"","enable_cookies_class_closed":"","closed_cookie_new":"30"}"><input
type="hidden" class="panel-rulesets" data-style_id="382411" data-section="configure"
value="[{"name":"Ruleset 1","autoload_on_duration":"0","load_on_duration":1,"autoload_on_no_page_visit":false,"load_on_no_page_visit":1,"load_on_page_visit_type":"is-more-than","cp_show_note_page_view":"","modal_exit_intent":false,"autoload_on_scroll":"0","load_after_scroll":"35","inactivity":false,"inactivity_link":"","enable_after_post":false,"enable_custom_scroll":false,"enable_scroll_class":"","on_scroll_txt":"","show_cta_info":"","enable_custom_cookies":false,"enable_cookies_class":"","on_cookie_txt":"","hide_cta_link":"","enable_adblock_detection":false,"all_visitor_info":"","enable_visitors":"","visitor_type":"first-time","enable_referrer":"","referrer_type":"hide-from","display_to":"","hide_from":"","enable_scheduler":false,"enable_scheduler_txt":"","start_date":"","end_date":"","custom_cls_text_head":"","enable_custom_class":"1","copy_link_code_button":"Copy Link Code","copy_link_cls_code_button":"","custom_class":"sample101","custom_cls_text":""}]">
<style id="cp_popup_style_382411" type="text/css">
.cp_style_382411 .cp-popup-content {
font-family: Verdana;
font-style: Normal;
font-weight: Normal;
}
.cp_style_382411 .cp-popup-content {
border-style: none;
border-color: #e1e1e1;
border-width: 1px 1px 1px 1px;
border-radius: 3px 3px 3px 3px;
mobile-breakpoint: 767;
}
.cp_style_382411 #panel-1-382411 .cp-target:hover {}
.cp_style_382411 #panel-1-382411 {}
.cp_style_382411 .cpro-overlay {
background: rgba(0, 0, 0, 0.8);
}
.cp_style_382411 .cp-popup-wrapper .cpro-overlay {
height: 400px;
}
.cp_style_382411 .cp-popup-content {
width: 600px;
height: 400px;
background-color: #fff;
}
@media (max-width: 767px) {
.cp_style_382411 .cp-popup-content {
border-style: none;
border-color: #e1e1e1;
border-width: 1px 1px 1px 1px;
border-radius: 3px 3px 3px 3px;
mobile-breakpoint: 767;
}
.cp_style_382411 #panel-1-382411 .cp-target:hover {}
.cp_style_382411 #panel-1-382411 {}
.cp_style_382411 .cpro-overlay {
background: rgba(0, 0, 0, 0.8);
}
.cp_style_382411 .cp-popup-wrapper .cpro-overlay {
height: 280px;
}
.cp_style_382411 .cp-popup-content {
width: 320px;
height: 280px;
background-color: #fff;
}
}
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field {
font-family: inherit;
font-style: inherit;
font-weight: inherit;
text-transform: none;
font-size: 13px;
letter-spacing: 0;
text-align: left;
color: #666;
background-color: #fff;
border-style: solid;
border-width: 1px 1px 1px 1px;
border-radius: 1px 1px 1px 1px;
border-color: #bbb;
active-border-color: #666;
padding: 0px 10px 0px 10px;
}
.cp_style_382411 #form_field-382411 .cp-target:hover {}
.cp_style_382411 #form_field-382411 placeholder {
color: #666;
}
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field input[type='radio'],
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field input[type='checkbox'] {
color: #666;
background-color: #fff;
}
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field:focus {
border-color: #666;
}
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field::-webkit-input-placeholder {
color: #666;
}
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field::-moz-placeholder {
color: #666;
}
.cp_style_382411 .cp-popup .cpro-form .pika-lendar table tbody button:hover {
background: #666;
}
.cp_style_382411 .cp-popup .cpro-form .pika-lendar table tbody .is-selected .pika-button {
background: #666;
box-shadow: inset 0 1px 3px #666;
}
.cp_style_382411 #form_field-382411 {}
@media (max-width: 767px) {
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field {
font-family: inherit;
font-style: inherit;
font-weight: inherit;
text-transform: none;
font-size: 11px;
letter-spacing: 0;
text-align: left;
color: #666;
background-color: #fff;
border-style: solid;
border-width: 1px 1px 1px 1px;
border-radius: 1px 1px 1px 1px;
border-color: #bbb;
active-border-color: #666;
padding: 0px 10px 0px 10px;
}
.cp_style_382411 #form_field-382411 .cp-target:hover {}
.cp_style_382411 #form_field-382411 placeholder {
color: #666;
}
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field input[type='radio'],
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field input[type='checkbox'] {
color: #666;
background-color: #fff;
}
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field:focus {
border-color: #666;
}
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field::-webkit-input-placeholder {
color: #666;
}
.cp_style_382411 .cp-popup .cpro-form .cp-form-input-field::-moz-placeholder {
color: #666;
}
.cp_style_382411 .cp-popup .cpro-form .pika-lendar table tbody button:hover {
background: #666;
}
.cp_style_382411 .cp-popup .cpro-form .pika-lendar table tbody .is-selected .pika-button {
background: #666;
box-shadow: inset 0 1px 3px #666;
}
.cp_style_382411 #form_field-382411 {}
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {
width: 45px;
height: 45px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target:hover {}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {
border-style: none;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {
border-color: #757575;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {}
.cp_style_382411 #cp_close_image-2-382411 .cp-target~.cp-field-shadow {}
.cp_style_382411 #cp_close_image-2-382411 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target:hover {}
.cp_style_382411 #cp_close_image-2-382411 .cp-target:hover~.cp-field-shadow {}
.cp_style_382411 #cp_close_image-2-382411 {
left: 577px;
top: -22px;
z-index: 3;
}
@media (max-width: 767px) {
.cp_style_382411 #cp_close_image-2-382411 .cp-target {
width: 45px;
height: 45px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target:hover {}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {
border-style: none;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {
border-color: #757575;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target {}
.cp_style_382411 #cp_close_image-2-382411 .cp-target~.cp-field-shadow {}
.cp_style_382411 #cp_close_image-2-382411 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_382411 #cp_close_image-2-382411 .cp-target:hover {}
.cp_style_382411 #cp_close_image-2-382411 .cp-target:hover~.cp-field-shadow {}
.cp_style_382411 #cp_close_image-2-382411 {
left: 298px;
top: -22px;
z-index: 3;
}
}
.cp_style_382411 #cp_heading-2-382411 .cp-target {
font-family: Lato;
font-style: 700;
font-weight: 700;
font-size: 40px;
line-height: 1.13;
letter-spacing: 0px;
text-align: center;
color: #000000;
width: 322px;
height: 147px;
}
.cp_style_382411 #cp_heading-2-382411 .cp-target:hover {}
.cp_style_382411 #cp_heading-2-382411 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_382411 #cp_heading-2-382411 {
left: 255px;
top: 8px;
z-index: 4;
}
@media (max-width: 767px) {
.cp_style_382411 #cp_heading-2-382411 .cp-target {
font-family: Lato;
font-style: 700;
font-weight: 700;
font-size: 26px;
line-height: 1.13;
letter-spacing: 0px;
text-align: center;
color: #000000;
width: 203px;
height: 68px;
}
.cp_style_382411 #cp_heading-2-382411 .cp-target:hover {}
.cp_style_382411 #cp_heading-2-382411 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_382411 #cp_heading-2-382411 {
left: 58.5px;
top: 33px;
z-index: 4;
}
}
.cp_style_382411 #cp_email-3-382411 .cp-target {
width: 321px;
height: 45px;
}
.cp_style_382411 #cp_email-3-382411 .cp-target:hover {}
.cp_style_382411 #cp_email-3-382411 {
left: 255px;
top: 220px;
z-index: 7;
}
@media (max-width: 767px) {
.cp_style_382411 #cp_email-3-382411 .cp-target {
width: 277px;
height: 30px;
}
.cp_style_382411 #cp_email-3-382411 .cp-target:hover {}
.cp_style_382411 #cp_email-3-382411 {
left: 21px;
top: 191px;
z-index: 7;
}
}
.cp_style_382411 #cp_text-3-382411 .cp-target {
width: 322px;
height: 45px;
}
.cp_style_382411 #cp_text-3-382411 .cp-target:hover {}
.cp_style_382411 #cp_text-3-382411 {
left: 255px;
top: 160px;
z-index: 8;
}
@media (max-width: 767px) {
.cp_style_382411 #cp_text-3-382411 .cp-target {
width: 276px;
height: 30px;
}
.cp_style_382411 #cp_text-3-382411 .cp-target:hover {}
.cp_style_382411 #cp_text-3-382411 {
left: 21px;
top: 158px;
z-index: 8;
}
}
.cp_style_382411 #cp_button-3-382411 .cp-target {
font-family: Lato;
font-style: 700;
font-weight: 700;
font-size: 19px;
letter-spacing: 0px;
text-align: center;
color: #fff;
background: #3498DB;
width: 322px;
height: 57px;
padding: 0px 15px 0px 15px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target:hover {
color: #fff;
background: #2980B9;
}
.cp_style_382411 #cp_button-3-382411 .cp-target {
border-style: none;
}
.cp_style_382411 #cp_button-3-382411 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_382411 #cp_button-3-382411 .cp-target {
border-color: #757575;
}
.cp_style_382411 #cp_button-3-382411 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_382411 #cp_button-3-382411 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target {}
.cp_style_382411 #cp_button-3-382411 .cp-target~.cp-field-shadow {}
.cp_style_382411 #cp_button-3-382411 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_382411 #cp_button-3-382411 .cp-target:hover {}
.cp_style_382411 #cp_button-3-382411 .cp-target:hover~.cp-field-shadow {}
.cp_style_382411 #cp_button-3-382411 {
left: 255px;
top: 296px;
z-index: 10;
}
@media (max-width: 767px) {
.cp_style_382411 #cp_button-3-382411 .cp-target {
font-family: Lato;
font-style: 700;
font-weight: 700;
font-size: 16px;
letter-spacing: 0px;
text-align: center;
color: #fff;
background: #3498DB;
width: 278px;
height: 40px;
padding: 0px 15px 0px 15px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target:hover {
color: #fff;
background: #2980B9;
}
.cp_style_382411 #cp_button-3-382411 .cp-target {
border-style: none;
}
.cp_style_382411 #cp_button-3-382411 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_382411 #cp_button-3-382411 .cp-target {
border-color: #757575;
}
.cp_style_382411 #cp_button-3-382411 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_382411 #cp_button-3-382411 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_button-3-382411 .cp-target {}
.cp_style_382411 #cp_button-3-382411 .cp-target~.cp-field-shadow {}
.cp_style_382411 #cp_button-3-382411 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_382411 #cp_button-3-382411 .cp-target:hover {}
.cp_style_382411 #cp_button-3-382411 .cp-target:hover~.cp-field-shadow {}
.cp_style_382411 #cp_button-3-382411 {
left: 21px;
top: 226px;
z-index: 10;
}
}
.cp_style_382411 #cp_image-1-382411 .cp-target {
width: 175px;
height: 277px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target:hover {}
.cp_style_382411 #cp_image-1-382411 .cp-target {
border-style: none;
}
.cp_style_382411 #cp_image-1-382411 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_382411 #cp_image-1-382411 .cp-target {
border-color: #757575;
}
.cp_style_382411 #cp_image-1-382411 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_382411 #cp_image-1-382411 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target {}
.cp_style_382411 #cp_image-1-382411 .cp-target~.cp-field-shadow {}
.cp_style_382411 #cp_image-1-382411 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_382411 #cp_image-1-382411 .cp-target:hover {}
.cp_style_382411 #cp_image-1-382411 .cp-target:hover~.cp-field-shadow {}
.cp_style_382411 #cp_image-1-382411 {
left: 15px;
top: 61.5px;
z-index: 11;
}
@media (max-width: 767px) {
.cp_style_382411 #cp_image-1-382411 .cp-target {
width: 175px;
height: 277px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target:hover {}
.cp_style_382411 #cp_image-1-382411 .cp-target {
border-style: none;
}
.cp_style_382411 #cp_image-1-382411 .cp-target~.cp-field-shadow {
border-style: none;
}
.cp_style_382411 #cp_image-1-382411 .cp-target {
border-color: #757575;
}
.cp_style_382411 #cp_image-1-382411 .cp-target~.cp-field-shadow {
border-color: #757575;
}
.cp_style_382411 #cp_image-1-382411 .cp-target {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target~.cp-field-shadow {
border-width: 1px 1px 1px 1px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target~.cp-field-shadow {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target>.cp-close-link {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target>.cp-close-image {
border-radius: 0px 0px 0px 0px;
}
.cp_style_382411 #cp_image-1-382411 .cp-target {}
.cp_style_382411 #cp_image-1-382411 .cp-target~.cp-field-shadow {}
.cp_style_382411 #cp_image-1-382411 .cp-rotate-wrap {
transform: rotate(0deg);
}
.cp_style_382411 #cp_image-1-382411 .cp-target:hover {}
.cp_style_382411 #cp_image-1-382411 .cp-target:hover~.cp-field-shadow {}
.cp_style_382411 #cp_image-1-382411 {
left: 15px;
top: 61.5px;
z-index: 11;
}
}
@media (max-width: 767px) {
.cp_style_382411 .cp-invisible-on-mobile {
display: none !important;
}
}
</style>
<div class="cp-popup-content cpro-active-step cp-modal_popup cp-panel-1" data-entry-animation="cp-fadeIn" data-overlay-click="1" data-title="Advanced Excel Exercises with Solutions" data-module-type="modal_popup" data-step="1"
data-width="600" data-mobile-width="320" data-height="400" data-mobile-height="280" data-mobile-break-pt="767" data-mobile-responsive="yes">
<div class="cpro-form-container">
<div id="cp_close_image-2-382411" class="cp-field-html-data cp-none cp-image-ratio cp-close-field cp-close-image-wrap" data-type="cp_close_image" data-field-title="Close Image" data-action="close">
<div class="cp-rotate-wrap">
<div class="cp-image-main"><img width="45" height="45" data-cp-src="https://www.exceldemy.com/wp-content/plugins/convertpro/assets/admin/img/close2.png" class="cp-target cp-field-element cp-close-image cp-img-lazy" alt=""
name="cp_close_image-2" value="" src="">
<div class="cp-field-shadow"></div>
</div>
</div>
</div>
<div id="cp_heading-2-382411" class="cp-field-html-data cp-none cp_has_editor" data-type="cp_heading">
<div class="cp-rotate-wrap">
<div class="cp-target cp-field-element cp-heading tinymce" name="cp_heading-2">
<p>Advanced Excel Exercises with Solutions PDF</p>
<p> </p>
<p> </p>
</div>
</div>
</div>
<div id="cp_email-3-382411" class="cp-field-html-data cp-none" data-type="cp_email">
<input type="email" class="cp-target cp-field-element cp-form-input-field cp-form-field cp-email cp-form-field cp-email-field" aria-label="Email Address" placeholder="Email Address" name="param[email]" value="" required="required"
data-email-error-msg="{{email-error}}" autocomplete="on">
</div>
<div id="cp_text-3-382411" class="cp-field-html-data cp-none" data-type="cp_text" data-field-title="Text">
<input type="text" class="cp-target cp-field-element cp-text cp-form-field cp-form-input-field cp-text-field" aria-label="First Name" placeholder="First Name" name="param[textfield_2832]" value="" access_cp_pro="" autocomplete="on">
</div>
<div id="cp_button-3-382411" class="cp-field-html-data cp-none" data-type="cp_button" data-action="submit_n_close" data-step="1">
<div class="cp-rotate-wrap"><button type="submit" class=" cp-target cp-field-element cp-button cp-button-field" data-success-message="SUCCESS! Watch your inbox for free exercises with solutions." data-get-param="false">YES, I WANT
THIS</button>
<div class="cp-btn-tooltip"></div>
</div>
</div>
<div id="cp_image-1-382411" class="cp-field-html-data cp-none cp-image-ratio" data-type="cp_image" data-action="none" data-step="1">
<div class="cp-rotate-wrap">
<div class="cp-image-main"><img width="175" height="277" data-cp-src="https://www.exceldemy.com/wp-content/uploads/2023/05/book_cover.png" class="cp-img-lazy cp-target cp-field-element cp-image" name="cp_image-1" alt="" src="">
<div class="cp-field-shadow"></div>
</div>
</div>
</div>
</div>
</div>
<input type="hidden" name="param[date]" value="Jun 13, 2023">
<input type="text" class="cpro-hp-field" name="cpro_hp_field_382411" value="">
<input type="hidden" name="action" value="cp_v2_add_subscriber">
<input type="hidden" name="style_id" value="382411">
</form>GET https://www.exceldemy.com/
<form role="search" method="get" class="search-form" action="https://www.exceldemy.com/">
<input type="text" name="s" placeholder="Search" data-posttype="post">
<input type="hidden" name="post_type" value="post"> <button type="submit" class="btnsearch hideonmobile" aria-label="Search"><i class="rhicon rhi-search"></i></button>
</form>Text Content
Submit Excel Problem * Home * About Us * Excel Templates * Excel Pivot Table * Excel Books * Learn VBA * Excel Practice * Advanced Excel Exercises * Calculation with Excel Formulas * Excel Pivot Table Exercises * Excel Training & Courses * Interview Questions with Excel Topics * MCQ Questions on MS Excel * Practice Test & Quiz * Practice with VBA * Use of Excel Functions * Blog * Excel Basics * Excel Functions * Excel Formulas * Macros & Excel VBA * Advanced Excel * Excel Charts * Data Analysis with Excel * Excel Pivot Table * Excel Power Query * Excel Solver * Excel for Finance Home » Excel Basics » How to Freeze Rows and Columns at the Same Time in Excel HOW TO FREEZE ROWS AND COLUMNS AT THE SAME TIME IN EXCEL ASM Arman Apr 5, 2023 0 Get FREE Advanced Excel Exercises with Solutions! While working on a large excel worksheet, we often need to freeze rows and columns at the same time to easily navigate the worksheet. Freezing rows and columns at the same time will let us view the entire worksheet while keeping the necessary rows and columns always visible. In this article, I will explain to you how to freeze rows and columns at the same time in excel using 4 easy methods. -------------------------------------------------------------------------------- Table of Contents hide Download Practice Workbook 4 Methods to Freeze Rows and Columns at the Same Time in Excel 1. Use Freeze Panes to Freeze Rows and Columns Based on Columns 2. Use Freeze Panes to Freeze Rows and Columns Based on Rows 3. Magic Freeze Button to Freeze Columns and Rows at the Same Time 4. Splitting Panes to Freeze Rows and Columns Simultaneously Things to Remember Conclusion Further Readings DOWNLOAD PRACTICE WORKBOOK Download this practice workbook to exercise while you are reading this article. MY LATEST VIDEO Necessary-Excel-Skills-to-Get-Hired 0 seconds of 1 minute, 30 secondsVolume 0% Press shift question mark to access a list of keyboard shortcuts Keyboard ShortcutsEnabledDisabled Play/PauseSPACE Increase Volume↑ Decrease Volume↓ Seek Forward→ Seek Backward← Captions On/Offc Fullscreen/Exit Fullscreenf Mute/Unmutem Seek %0-9 Live 00:00 01:30 01:30 Freeze Rows and Columns at the Same Time in Excel.xlsx -------------------------------------------------------------------------------- 4 METHODS TO FREEZE ROWS AND COLUMNS AT THE SAME TIME IN EXCEL Imagine a case where we have an Excel worksheet with information about a company. As we have different information about a lot of employees, we have to slide horizontally to view the different information about an employee or scroll down to see the information about a specific employee whose information is very far down the worksheet. But as we are doing so, we need to keep the column header visible to see which type of information an employee we are looking at. We might sometimes need to keep the information of some employees (Rows) or specific information (Columns) in our view to compare them with others. We can do so by using Freeze Panes, Magic Freeze, and Splitting Panes. -------------------------------------------------------------------------------- 1. USE FREEZE PANES TO FREEZE ROWS AND COLUMNS BASED ON COLUMNS We might want to freeze the Serial and Employee Name columns of our worksheet So that we can keep seeing these two vertical columns as we are sliding horizontally. These can be done following these steps- Step 1: * First, we have to choose a column, cell, or all columns on the right side of the Serial and Employee Name In this worksheet Department and Joining, Date columns are on the right of these two columns we want to freeze. So, we will select these two columns or we can also select any cell on column D. Step 2: * Now we will select Freeze Panes from the View After selecting the Freeze Panes, a Drop-down list will appear. From the dropdown list, we will select Freeze Panes. * After selecting Freezing Panes, Serial and Employee Name columns will be frozen and two thin lines will appear above and on the right side of Serial and Employee Names We can now slide horizontally with these two columns always visible to us. Read More: How to Freeze Selected Panes in Excel (10 Ways) -------------------------------------------------------------------------------- 2. USE FREEZE PANES TO FREEZE ROWS AND COLUMNS BASED ON ROWS Sometimes we need to freeze some rows of our worksheet. In this worksheet, for instance, we might want to freeze the rows of the first 4 employees along with their information column so that we can compare them with others while scrolling down the worksheet. It is very similar to the first method where we freeze based on columns. This time instead of columns we will do a similar procedure on the rows of the first 4 employees. To do so- Step 1: * First, we have to choose a row, cell, or all the rows below the last row we want to freeze. In this worksheet, we want to freeze the rows containing the information of the first 4 employees (John, Devid, Tom, Augustin). So, the next row below these rows is the row containing the information of an employee named Ted (row 9). So, we will select this row or all the rows below it or any cell on row 9. Step 2: * Now we will select Freeze Panes from the View After selecting the Freeze Panes, a Drop-down list will appear. From the dropdown list to we will select Freeze Panes. * After selecting Freezing Panes, the first 4 rows will be frozen and two thin lines will appear below and on the left of 4 frozen rows. We can now scroll down vertically with these 4 rows always visible. -------------------------------------------------------------------------------- Similar Readings * How to Transpose Column to Multiple Rows in Excel (6 Methods) * Excel VBA: Get Row and Column Number from Cell Address (4 Methods) * How to Convert Multiple Rows to Columns in Excel (9 Ways) * Excel VBA: Set Range by Row and Column Number (3 Examples) * How to Hide Rows and Columns in Excel (10 Ways) -------------------------------------------------------------------------------- 3. MAGIC FREEZE BUTTON TO FREEZE COLUMNS AND ROWS AT THE SAME TIME We can also add the Magic Freeze button to the Quick Access Toolbar to freeze the rows, columns, or cells with a single click. To add the Magic Freeze, we have to follow the steps mentioned below- Step 1: * Click the down arrow from the top of the Excel file. * Click More Commands from the drop-down list. Step 2: * Under Choose commands from, select Commands Not in the Ribbon. Step 3: * Select Freeze Panes and click Add. * Click OK to add the command to Quick Access Toolbar. Step 4: * Now to freeze rows and columns, select the other rows and columns like the ways mentioned in the previous methods and click Freeze Panes. * After clicking the Freeze Panes button, the columns and rows will be frozen at the same time. -------------------------------------------------------------------------------- 4. SPLITTING PANES TO FREEZE ROWS AND COLUMNS SIMULTANEOUSLY Splitting panes is one of the types of freezing panes, when you use splitting panes, Excel will create either two or four separate worksheet areas that you can scroll, while the rows or the columns outside the freezing area will remain visible. To freeze the columns and rows using Splitting Panes we have to- Step 1: * Select below the last row which, or the column to the right of the last column you want to be frozen. Suppose we want to freeze the first two rows (information of the first two employees) of the worksheet. So, we will select row 7. Step 2: * On the View tab, in the Window group, click Split. The cells will be split and an intersection of two grey thin lines will indicate, where the split occurs. Step 3: * Following this step, we will select Freeze Panes from the View After selecting the Freeze Panes, a dropdown list will appear. From the dropdown list, we will select Freeze Panes. * After clicking on Freezing Panes, our desired rows and columns will be frozen concurrently. -------------------------------------------------------------------------------- THINGS TO REMEMBER * At the same time, you can not use Freeze panes and split panes. You can enable only one of the two. * You have to select the row(s) below the one you want to be frozen or the column right of the column(s) you need to be frozen. * If you want to freeze rows and columns at the same time based on a reference cell, then the reference cell must be below the row and right of the column you want to freeze. -------------------------------------------------------------------------------- CONCLUSION In this article, we have learned 4 easy ways on how to freeze rows and columns at the same time in excel. To freeze the rows and columns we have used Freeze Panes, Magic Freeze Panes, and Splitting Panes. I hope you now have a clear idea of how to freeze rows and columns simultaneously. If you have any queries or recommendations about this article, please do leave a comment below. Have a great day!!! -------------------------------------------------------------------------------- FURTHER READINGS * Excel Macro: Convert Multiple Rows to Columns (3 Examples) * How to Transpose Multiple Columns to Rows in Excel * Excel VBA to Set Range Using Row and Column Numbers (4 Examples) * How to Add Rows and Columns in Excel (3 Easy Methods) * Hide Rows and Columns in Excel: Shortcut & Other Techniques * How to Switch Rows and Columns in Excel (5 Methods) * Move Row/Column in Excel Without Replacing Existing Data (3 Best Ways) SaveSavedRemoved 0 Tags: Rows and Columns in Excel ASM ARMAN Hi there! I am ASM Arman. I Completed B.Sc. in Naval Architecture and Marine Engineering. I take a great interest in learning about new technologies and sharing my ideas and thoughts on them with others. Please do reach out to me if you have any queries or recommendations. Have a great day!!! Related Articles Added to wishlistRemoved from wishlist 0 HOW TO MAKE A ROSTER IN EXCEL (WITH DETAILED STEPS) Added to wishlistRemoved from wishlist 0 TYPES OF SPARKLINES IN EXCEL Added to wishlistRemoved from wishlist 0 HOW TO REMOVE SPARKLINES IN EXCEL (2 QUICK WAYS) Added to wishlistRemoved from wishlist 0 [FIXED!] EXCEL DATE FILTER IS NOT GROUPING BY MONTH (3 SOLUTIONS) We will be happy to hear your thoughts LEAVE A REPLY CANCEL REPLY Δ EXCLUSIVE EXCEL TUTORIALS Make a Pie Chart in Excel (5 Examples) -------------------------------------------------------------------------------- VLOOKUP from Another Sheet in Excel -------------------------------------------------------------------------------- Excel Advanced Filter (5 Applications) -------------------------------------------------------------------------------- Make a Gantt Chart in Excel -------------------------------------------------------------------------------- INDEX MATCH vs VLOOKUP Function -------------------------------------------------------------------------------- Find External Links in Excel -------------------------------------------------------------------------------- Goal Seek Analysis in Excel -------------------------------------------------------------------------------- Recover Corrupted Excel File -------------------------------------------------------------------------------- SUMIFS to SUM Values in Date Range in Excel -------------------------------------------------------------------------------- Formula for Number of Days Between Two Dates About ExcelDemy.com ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. Contact | Privacy Policy | TOS Affiliate Disclosure: ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. I earn a small commission if you buy any products using my affiliate links to Amazon. Follow Us Join ExcelDemy Forum Copyright © 2013-2022 ExcelDemy.com | All rights reserved. Advanced Excel Exercises with Solutions PDF YES, I WANT THIS Submit Excel Problem * Submit Excel Problem * Home * About Us * Excel Templates * Excel Pivot Table * Excel Books * Learn VBA * Excel Practice * back * Advanced Excel Exercises * Calculation with Excel Formulas * Excel Pivot Table Exercises * Excel Training & Courses * Interview Questions with Excel Topics * MCQ Questions on MS Excel * Practice Test & Quiz * Practice with VBA * Use of Excel Functions * Blog * back * Excel Basics * Excel Functions * Excel Formulas * Macros & Excel VBA * Advanced Excel * Excel Charts * Data Analysis with Excel * Excel Pivot Table * Excel Power Query * Excel Solver * Excel for Finance * Update Privacy Preferences A Raptive Partner Site