{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Dataset","1. Single Cell","2. Range","4. Column","3. Row","5. Multiple Ranges","Worksheet-1","Worksheet-2","Workbook","8. Paste Special","9. Copy Links","10. Copy as Picture","11. Formula ","12. Copy Selection"],"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":"Dataset","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Excel VBA Copy Paste"]
[]
[null,"Name","Town","Job"]
[null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher"]

{"sheet":"1. Single Cell","index":1,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Copy and Paste a Single Cell",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Town","Job",null,"Copied Value",null,null,null,"Name","Town","Job",null,"Copied Value"]
[null,"Mike Walter","Albuquerque","Car Mechanic",null,"Car Mechanic",null,null,null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman",null,null,null,null,null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner",null,null,null,null,null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver",null,null,null,null,null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer",null,null,null,null,null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher",null,null,null,null,null,"Walter Watson","Roswell","School Teacher"]

{"sheet":"2. Range","index":2,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,5,3,6],[1,1,1,6],[1,10,1,15],[3,14,3,15]]}
[]
[null,"Excel VBA Copy Paste",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Town","Job",null,"Copied Range",null,null,null,null,"Name","Town","Job",null,"Copied Range"]
[null,"Mike Walter","Albuquerque","Car Mechanic",null,"Mike Walter","Albuquerque",null,null,null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman",null,"Jessy Fring","Santa Fe",null,null,null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner",null,"Gustabo White","Roswell",null,null,null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver",null,null,null,null,null,null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer",null,null,null,null,null,null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher",null,null,null,null,null,null,"Walter Watson","Roswell","School Teacher"]

{"sheet":"4. Column","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Copy and Paste an Entire Column",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Town","Job",null,null,null,null,null,"Name","Town","Job"]
[null,"Mike Walter","Albuquerque","Car Mechanic",null,"Car Mechanic",null,null,null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman",null,"Businessman",null,null,null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner",null,"Restaurant Owner",null,null,null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver",null,"Car Driver",null,null,null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer",null,"Laywer",null,null,null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher",null,"School Teacher",null,null,null,"Walter Watson","Roswell","School Teacher"]

{"sheet":"3. Row","index":4,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Copy and Paste an Entire Row",null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Town","Job",null,null,null,"Name","Town","Job"]
[null,"Mike Walter","Albuquerque","Car Mechanic",null,null,null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman",null,null,null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner",null,null,null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver",null,null,null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer",null,null,null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher",null,null,null,"Walter Watson","Roswell","School Teacher"]
[]
[null,"Walter Watson","Roswell","School Teacher"]

{"sheet":"5. Multiple Ranges","index":5,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,10,2],[1,9,1,13],[10,9,10,10]]}
[]
[null,"Copy and Paste Multiple Ranges",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee ID","Name","Age","City","Salary",null,null,null,"Employee ID","Name","Age","City","Salary"]
[null,1000357,"Laura",19,"Barcelona",30000,null,null,null,1000357,"Laura",19,"Barcelona",30000]
[null,1000963,"Feix",19,"Paris",38500,null,null,null,1000963,"Feix",19,"Paris",38500]
[null,1000159,"Alexis",22,"Amadora",33000,null,null,null,1000159,"Alexis",22,"Amadora",33000]
[null,1000369,"Isabella",22,"Berlin",30000,null,null,null,1000369,"Isabella",22,"Berlin",30000]
[null,1000749,"Maxime",22,"Leipzig",32000,null,null,null,1000749,"Maxime",22,"Leipzig",32000]
[]
[null,"Copied Ranges",null,null,null,null,null,null,null,"Copied Ranges"]
[null,"Employee ID","City"]
[null,1000357,"Barcelona"]
[null,1000963,"Paris"]
[null,1000159,"Amadora"]
[null,1000369,"Berlin"]
[null,1000749,"Leipzig"]

{"sheet":"Worksheet-1","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copy from This Worksheet"]
[]
[null,"Name","Town","Job"]
[null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher"]

{"sheet":"Worksheet-2","index":7,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Paste in This Worksheet",null,null,null,null,null,"Try Yourself Pasting Here"]
[]
[null,"Name","Town","Job"]
[null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher"]

{"sheet":"Workbook","index":8,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copy and Paste from One Workbook to Another"]
[]
[null,"Name","Town","Job"]
[null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher"]

{"sheet":"8. Paste Special","index":9,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copy and Paste Using Paste Special"]
[]
[null,"Name","Town","Job"]
[null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher"]

{"sheet":"9. Copy Links","index":10,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Copy and Paste Links",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Company","Website",null,"Copied Links",null,null,null,"Company","Website",null,"Copied Links"]
[null,"Brittish American Tobacco","https://www.bat.com/",null,"https://www.bat.com/",null,null,null,"Brittish American Tobacco","https://www.bat.com/"]
[null,"Nike","https://www.nike.com/ ",null,"https://www.nike.com/ ",null,null,null,"Nike","https://www.nike.com/ "]
[null,"Adidas","https://www.adidas.com/us ",null,"https://www.adidas.com/us ",null,null,null,"Adidas","https://www.adidas.com/us "]

{"sheet":"10. Copy as Picture","index":11,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[" "]
[null,"Copy and Paste as Picture",null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Town","Job",null,null,null,"Name","Town","Job"]
[null,"Mike Walter","Albuquerque","Car Mechanic",null,null,null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman",null,null,null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner",null,null,null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver",null,null,null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer",null,null,null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher",null,null,null,"Walter Watson","Roswell","School Teacher"]

{"sheet":"11. Formula ","index":12,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Copy and Paste Formula",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Roll","Maths","Physics","Average",null,"Average",null,null,null,"Roll","Maths","Physics","Average",null,"Average"]
[null,1,85,83,{"$f":"AVERAGE(C5:D5)","v":84},null,{"$f":"AVERAGE(C5:D5)","v":84},null,null,null,1,85,83,{"$f":"AVERAGE(L5:M5)","v":84}]
[null,2,92,94,{"$f":"AVERAGE(C6:D6)","v":93},null,{"$f":"AVERAGE(C6:D6)","v":93},null,null,null,2,92,94,{"$f":"AVERAGE(L6:M6)","v":93}]
[null,3,79,89,84,null,{"$f":"AVERAGE(C7:D7)","v":84},null,null,null,3,79,89,84]
[null,4,83,79,81,null,{"$f":"AVERAGE(C8:D8)","v":81},null,null,null,4,83,79,81]
[null,5,95,69,82,null,{"$f":"AVERAGE(C9:D9)","v":82},null,null,null,5,95,69,82]

{"sheet":"12. Copy Selection","index":13,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,5,3,6],[1,1,1,6],[1,10,1,15],[3,14,3,15]]}
[]
[null,"Copy Selected Cell then Paste",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Town","Job",null,"Paste Here",null,null,null,null,"Name","Town","Job",null,"Paste Here"]
[null,"Mike Walter","Albuquerque","Car Mechanic",null,null,null,null,null,null,"Mike Walter","Albuquerque","Car Mechanic"]
[null,"Jessy Fring","Santa Fe","Businessman",null,null,null,null,null,null,"Jessy Fring","Santa Fe","Businessman"]
[null,"Gustabo White","Roswell","Restaurant Owner",null,null,null,null,null,null,"Gustabo White","Roswell","Restaurant Owner"]
[null,"Nacho Varga","Santa Fe","Car Driver",null,null,null,null,null,null,"Nacho Varga","Santa Fe","Car Driver"]
[null,"Saul Paulman","Albuquerque","Laywer",null,null,null,null,null,null,"Saul Paulman","Albuquerque","Laywer"]
[null,"Walter Watson","Roswell","School Teacher",null,null,null,null,null,null,"Walter Watson","Roswell","School Teacher"]