{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Fill Handle","Formula","Text and Numerical Values","Date","Time","Days","Months","Rank","AutoFill Formulas","Custom List","Repeating Values","Horizontal and Vertical","Multiple Rows or Columns","Skip Rows","Growth Trend","Series Option","Fill Series","Join Cell","Split Cell","Extract Data","VBA"],"not_rendered":{"charts":0,"images":0,"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":"Fill Handle","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AutoFill with Fill Handle",null,null,null,"Try Yourself"]
[]
[null,"Serial Number",null,null,null,"Serial Number"]
[null,1,null,null,null,1]
[null,2,null,null,null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"Formula","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Formula to AutoFill",null,null,null,"Try Yourself"]
[]
[null,"Serial Number",null,null,null,"Serial Number"]
[null,{"$f":"_xlfn.SEQUENCE(10)","v":1}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"Text and Numerical Values","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AutoFill Cells Containing Text and Numerical Values",null,null,null,"Try Yourself"]
[]
[null,"Week Number",null,null,null,"Week Number"]
[null,"Week 1",null,null,null,"Week 1"]
[null,"Week 2",null,null,null,"Week 2"]
[null,"Week 3"]
[null,"Week 4"]
[null,"Week 5"]
[null,"Week 6"]
[null,"Week 7"]
[null,"Week 8"]
[null,"Week 9"]
[null,"Week 10"]

{"sheet":"Date","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AutoFill Date",null,null,null,"Try Yourself"]
[]
[null,"Date",null,null,null,"Date"]
[null,"2023-07-21",null,null,null,"2023-07-21"]
[null,"2023-07-22"]
[null,"2023-07-23"]
[null,"2023-07-24"]
[null,"2023-07-25"]
[null,"2023-07-26"]
[null,"2023-07-27"]
[null,"2023-07-28"]
[null,"2023-07-29"]
[null,"2023-07-30"]

{"sheet":"Time","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AutoFill Time",null,null,null,"Try Yourself"]
[]
[null,"Time",null,null,null,"Time"]
[null,"11:55:00",null,null,null,"11:55:00"]
[null,"12:55:00"]
[null,"13:55:00"]
[null,"14:55:00"]
[null,"15:55:00"]
[null,"16:55:00"]
[null,"17:55:00"]
[null,"18:55:00"]
[null,"19:55:00"]
[null,"20:55:00"]

{"sheet":"Days","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AutoFill Days of a Week",null,null,null,"Try Yourself"]
[]
[null,"Days",null,null,null,"Days"]
[null,"Monday",null,null,null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]

{"sheet":"Months","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AutoFill Months of a Year",null,null,null,"Try Yourself"]
[]
[null,"Months",null,null,null,"Months"]
[null,"January",null,null,null,"January"]
[null,"February"]
[null,"March"]
[null,"April"]
[null,"May"]
[null,"June"]
[null,"July"]
[null,"August"]
[null,"September"]
[null,"October"]
[null,"November"]
[null,"December"]

{"sheet":"Rank","index":7,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AutoFill Rank",null,null,null,"Try Yourself"]
[]
[null,"Rank",null,null,null,"Rank"]
[null,"1st",null,null,null,"1st"]
[null,"2nd"]
[null,"3rd"]
[null,"4th"]
[null,"5th"]
[null,"6th"]
[null,"7th"]
[null,"8th"]
[null,"9th"]
[null,"10th"]

{"sheet":"AutoFill Formulas","index":8,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"AutoFill Formulas",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,"First Name","Last Name","Full Name"]
[null,"Ethan","Anderson",{"$f":"CONCATENATE(B5,\" \",C5)","v":"Ethan Anderson"},null,null,null,"Ethan","Anderson"]
[null,"Ava","Mitchell",{"$f":"CONCATENATE(B6,\" \",C6)","v":"Ava Mitchell"},null,null,null,"Ava","Mitchell"]
[null,"Lucas","Patel","Lucas Patel",null,null,null,"Lucas","Patel"]
[null,"Sophia","Rivera","Sophia Rivera",null,null,null,"Sophia","Rivera"]
[null,"Oliver","Thompson","Oliver Thompson",null,null,null,"Oliver","Thompson"]
[null,"Mia","Lewis","Mia Lewis",null,null,null,"Mia","Lewis"]
[null,"Noah","Collins","Noah Collins",null,null,null,"Noah","Collins"]
[null,"Isabella","Carter","Isabella Carter",null,null,null,"Isabella","Carter"]
[null,"Aiden","Wright","Aiden Wright",null,null,null,"Aiden","Wright"]
[null,"Emma","Wilson","Emma Wilson",null,null,null,"Emma","Wilson"]

{"sheet":"Custom List","index":9,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AutoFill from Custom List",null,null,null,"Try Yourself"]
[]
[null,"List",null,null,null,"List"]
[null,"Morning Shift"]
[null,"Evening Shift"]
[null,"Night Shift"]

{"sheet":"Repeating Values","index":10,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AutoFill to Get Repeating Values",null,null,null,"Try Yourself"]
[]
[null,"Repeating Values",null,null,null,"Repeating Values"]
[null,"YES",null,null,null,"YES"]
[null,"NO",null,null,null,"NO"]
[null,true,null,null,null,true]
[null,false,null,null,null,false]
[null,"YES"]
[null,"NO"]
[null,true]
[null,false]
[null,"YES"]
[null,"NO"]
[null,true]
[null,false]

{"sheet":"Horizontal and Vertical","index":11,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,8],[1,12,1,19]]}
[]
[null,"AutoFill Horizontally and Vertically",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Week No. with Day","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday",null,null,null,"Week No. with Day","Saturday"]
[null,"Week 1"]
[null,"Week 2"]
[null,"Week 3"]
[null,"Week 4"]
[null,"Week 5"]
[null,"Week 6"]
[null,"Week 7"]
[null,"Week 8"]
[null,"Week 9",null,null,null,null,null,null,null,null,null,null,"Week 9"]
[null,"Week 10",null,null,null,null,null,null,null,null,null,null,"Week 10"]

{"sheet":"Multiple Rows or Columns","index":12,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,1,3,8],[1,1,1,8],[1,12,1,19],[3,12,3,19]]}
[]
[null,"AutoFill Multiple Rows or Columns",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Week No. with Day",null,null,null,null,null,null,null,null,null,null,"Week No. with Day"]
[null,"Week 1","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday",null,null,null,"Week 1","Saturday","Sunday"]
[null,"Week 2","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday",null,null,null,"Week 2","Saturday","Sunday"]
[null,"Week 3","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday"]
[null,"Week 4","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday"]
[null,"Week 5","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday"]
[null,"Week 6","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday"]
[null,"Week 7","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday"]

{"sheet":"Skip Rows","index":13,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AutoFill while Skipping Rows",null,null,null,"Try Yourself"]
[]
[null,"Serial Number",null,null,null,"Serial Number"]
[null,1,null,null,null,1]
[]
[null,2]
[]
[null,3]
[]
[null,4]
[]
[null,5]

{"sheet":"Growth Trend","index":14,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Growth Trend",null,null,null,"Try Yourself"]
[]
[null,"Exponential Numbers",null,null,null,"Exponential Numbers"]
[null,1,null,null,null,1]
[null,2,null,null,null,2]
[null,4]
[null,8]
[null,16]
[null,32]
[null,64]
[null,128]
[null,256]
[null,512]

{"sheet":"Series Option","index":15,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Series Option",null,null,null,"Try Yourself"]
[]
[null,"Exponential Numbers",null,null,null,"Exponential Numbers"]
[null,1,null,null,null,1]
[null,2,null,null,null,2]
[null,4]
[null,8]
[null,16]
[null,32]
[null,64]
[null,128]
[null,256]
[null,512]

{"sheet":"Fill Series","index":16,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Fill Series Command",null,null,null,"Try Yourself"]
[]
[null,"Serial Number",null,null,null,"Serial Number"]
[null,1,null,null,null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"Join Cell","index":17,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using Flash Fill Join Cell Content",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,"First Name","Last Name","Full Name"]
[null,"Ethan","Anderson","Ethan Anderson",null,null,null,"Ethan","Anderson","Ethan Anderson"]
[null,"Ava","Mitchell","Ava Mitchell",null,null,null,"Ava","Mitchell"]
[null,"Lucas","Patel","Lucas Patel",null,null,null,"Lucas","Patel"]
[null,"Sophia","Rivera","Sophia Rivera",null,null,null,"Sophia","Rivera"]
[null,"Oliver","Thompson","Oliver Thompson",null,null,null,"Oliver","Thompson"]
[null,"Mia","Lewis","Mia Lewis",null,null,null,"Mia","Lewis"]
[null,"Noah","Collins","Noah Collins",null,null,null,"Noah","Collins"]
[null,"Isabella","Carter","Isabella Carter",null,null,null,"Isabella","Carter"]
[null,"Aiden","Wright","Aiden Wright",null,null,null,"Aiden","Wright"]
[null,"Emma","Wilson","Emma Wilson",null,null,null,"Emma","Wilson"]

{"sheet":"Split Cell","index":18,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using Flash Fill Split Cell Content",null,null,null,null,null,"Try Yourself"]
[]
[null,"Full Name","First Name","Last Name",null,null,null,"Full Name","First Name","Last Name"]
[null,"Ethan Anderson","Ethan","Anderson",null,null,null,"Ethan Anderson","Ethan","Anderson"]
[null,"Ava Mitchell","Ava","Mitchell",null,null,null,"Ava Mitchell"]
[null,"Lucas Patel","Lucas","Patel",null,null,null,"Lucas Patel"]
[null,"Sophia Rivera","Sophia","Rivera",null,null,null,"Sophia Rivera"]
[null,"Oliver Thompson","Oliver","Thompson",null,null,null,"Oliver Thompson"]
[null,"Mia Lewis","Mia","Lewis",null,null,null,"Mia Lewis"]
[null,"Noah Collins","Noah","Collins",null,null,null,"Noah Collins"]
[null,"Isabella Carter","Isabella","Carter",null,null,null,"Isabella Carter"]
[null,"Aiden Wright","Aiden","Wright",null,null,null,"Aiden Wright"]
[null,"Emma Wilson","Emma","Wilson",null,null,null,"Emma Wilson"]

{"sheet":"Extract Data","index":19,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using Flash Fill Extract Data",null,null,null,null,"Try Yourself"]
[]
[null,"Section, ID & Name","ID",null,null,null,"Section, ID & Name","ID"]
[null,"A-1612-Ethan",1612,null,null,null,"A-1612-Ethan",1612]
[null,"A-1614-Ava",1614,null,null,null,"A-1614-Ava"]
[null,"B-1618-Lucas",1618,null,null,null,"B-1618-Lucas"]
[null,"C-1617-Sophia",1617,null,null,null,"C-1617-Sophia"]
[null,"B-1623-Oliver",1623,null,null,null,"B-1623-Oliver"]
[null,"C-1604-Mia",1604,null,null,null,"C-1604-Mia"]
[null,"C-1607-Noah",1607,null,null,null,"C-1607-Noah"]
[null,"A-1618-Isabella",1618,null,null,null,"A-1618-Isabella"]
[null,"B-1611-Aiden",1611,null,null,null,"B-1611-Aiden"]
[null,"C-1630-Emma",1630,null,null,null,"C-1630-Emma"]

{"sheet":"VBA","index":20,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Applying VBA to AutoFill Data",null,null,null,"Try Yourself"]
[]
[null,"Week Number",null,null,null,"Week Number"]
[null,"Week 1",null,null,null,"Week 1"]
[null,"Week 2",null,null,null,"Week 2"]