{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Home Page","VBA to Freeze Rows & Columns"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home Page","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Freeze Panes in Excel"]
[null,"Learn about Freeze Panes in Excel. Go through the article and practice the in practice section."]
[]
[null,"Prepared By","Nasir Muhammad Munim"]
[null,"Reviewed By","Seemanto Saha"]
[null,"Last Update"]
[null,"Article Link"]
[]
[null,"Contents"]
[null,"How to Apply VBA to Freeze Multiple Rows and Columns at Once"]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"VBA to Freeze Rows & Columns","index":1,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Freeze Panes in Excel"]
[]
["Apply VBA to Freeze Multiple Rows and Columns at Once"]
[]
["Property ID","Location","Size (sqft)","Number of Rooms","Price ($)","Year Built","Property Type","Garage","Pool","Basement","Garden"]
[1,"Los Angeles",1500,3,500000,1990,"Single Family","Yes","No","Yes","Yes"]
[2,"New York",2000,4,800000,1985,"Townhouse","No","No","Yes","No"]
[3,"San Francisco",1800,2,700000,2005,"Condo","Yes","Yes","No","No"]
[4,"Chicago",2200,3,600000,1998,"Single Family","Yes","Yes","Yes","Yes"]
[5,"Miami",1600,2,450000,2010,"Condo","No","Yes","No","Yes"]
[6,"Houston",1800,3,550000,2000,"Single Family","Yes","No","Yes","No"]
[7,"Seattle",2400,4,900000,2008,"Townhouse","Yes","No","No","Yes"]
[8,"Boston",1900,3,650000,1995,"Single Family","Yes","No","Yes","Yes"]
[9,"Atlanta",1700,2,400000,2015,"Condo","No","No","No","No"]
[10,"Denver",2100,4,750000,2003,"Single Family","Yes","Yes","Yes","Yes"]
[11,"Dallas",1800,3,500000,1992,"Single Family","Yes","No","Yes","No"]
[12,"Austin",1600,2,450000,2006,"Condo","No","Yes","No","Yes"]
[13,"San Diego",2000,3,700000,1999,"Single Family","Yes","Yes","Yes","Yes"]
[14,"Phoenix",1800,2,550000,2002,"Single Family","Yes","No","Yes","No"]
[15,"Portland",2200,4,800000,2007,"Townhouse","Yes","No","No","Yes"]
[16,"Charlotte",1900,3,600000,1996,"Single Family","Yes","No","Yes","Yes"]
[17,"San Francisco",1800,2,750000,2012,"Condo","Yes","Yes","No","No"]
[18,"Chicago",2000,3,550000,2001,"Single Family","Yes","No","Yes","Yes"]
[19,"Miami",1600,2,450000,2009,"Condo","No","Yes","No","Yes"]
[20,"Houston",1800,3,550000,2003,"Single Family","Yes","No","Yes","No"]
[21,"Seattle",2400,4,900000,2010,"Townhouse","Yes","No","No","Yes"]
[22,"Boston",1900,3,650000,1998,"Single Family","Yes","No","Yes","Yes"]
[23,"Atlanta",1700,2,400000,2018,"Condo","No","No","No","No"]
[24,"Denver",2100,4,750000,2005,"Single Family","Yes","Yes","Yes","Yes"]
[25,"Dallas",1800,3,500000,1995,"Single Family","Yes","No","Yes","No"]
[26,"Austin",1600,2,450000,2010,"Condo","No","Yes","No","Yes"]
[27,"San Diego",2000,3,700000,2001,"Single Family","Yes","Yes","Yes","Yes"]
[28,"Phoenix",1800,2,550000,2004,"Single Family","Yes","No","Yes","No"]
[29,"Portland",2200,4,800000,2009,"Townhouse","Yes","No","No","Yes"]
[30,"Charlotte",1900,3,600000,1998,"Single Family","Yes","No","Yes","Yes"]
[31,"Los Angeles",1500,3,500000,2005,"Single Family","Yes","No","Yes","Yes"]
[32,"San Francisco",1800,2,750000,2015,"Condo","Yes","Yes","No","No"]
[33,"Chicago",2000,3,550000,2002,"Single Family","Yes","No","Yes","Yes"]
[34,"Miami",1600,2,450000,2012,"Condo","No","Yes","No","Yes"]
[35,"Houston",1800,3,550000,2006,"Single Family","Yes","No","Yes","No"]
[36,"Seattle",2400,4,900000,2011,"Townhouse","Yes","No","No","Yes"]
[37,"Boston",1900,3,650000,1999,"Single Family","Yes","No","Yes","Yes"]
[38,"Atlanta",1700,2,400000,2020,"Condo","No","No","No","No"]
[39,"Denver",2100,4,750000,2007,"Single Family","Yes","Yes","Yes","Yes"]
[40,"Dallas",1800,3,500000,1997,"Single Family","Yes","No","Yes","No"]
[41,"Austin",1600,2,450000,2011,"Condo","No","Yes","No","Yes"]
[42,"San Diego",2000,3,700000,2003,"Single Family","Yes","Yes","Yes","Yes"]
[43,"Phoenix",1800,2,550000,2006,"Single Family","Yes","No","Yes","No"]
[44,"Portland",2200,4,800000,2010,"Townhouse","Yes","No","No","Yes"]
[45,"Charlotte",1900,3,600000,1999,"Single Family","Yes","No","Yes","Yes"]
[46,"Los Angeles",1500,3,500000,2006,"Single Family","Yes","No","Yes","Yes"]
[49,"San Francisco",1800,2,750000,2018,"Condo","Yes","Yes","No","No"]
[50,"Chicago",2000,3,550000,2005,"Single Family","Yes","No","Yes","Yes"]
[51,"Miami",1600,2,450000,2015,"Condo","No","Yes","No","Yes"]
[52,"Houston",1800,3,550000,2009,"Single Family","Yes","No","Yes","No"]
[53,"Seattle",2400,4,900000,2014,"Townhouse","Yes","No","No","Yes"]
[54,"Boston",1900,3,650000,2002,"Single Family","Yes","No","Yes","Yes"]
[55,"Atlanta",1700,2,400000,2022,"Condo","No","No","No","No"]
[56,"Denver",2100,4,750000,2008,"Single Family","Yes","Yes","Yes","Yes"]
[57,"Dallas",1800,3,500000,1998,"Single Family","Yes","No","Yes","No"]
[58,"Austin",1600,2,450000,2012,"Condo","No","Yes","No","Yes"]
[]
[]
[]
["Back to Home Page"]