{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Dataset","InsertColumnWithRightClick","Using SHIFT + CTRL + Equal (=)","Using Shortcut ALT + I, C","InsertMultipleAdjacentColumns","MultipleNon-AdjacentColumns","Insert a Column from Home Tab","InsertColumnWithClick&Drag","InsertColumUsingFillHandle","InsertColumnWithHSTACKfunction","InsertingColumnWithPowerPivot","InsertingColumnWithPowerQuery","Sales","InsertSingleColumnWithVBA","InsertMultipleColumnsWithVBA","InsertEveryOtherColumnWithVBA","InsertColumnInTheMiddleOfATable","InsertColumnAtTheEndOfATable"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales Report"]
[]
[null,"ID","Name","Sales"]
[null,"M-1","Jack",5798]
[null,"A-1","John",8087]
[null,"A-3","Alex",5083]
[null,"A-4","Bob",6848]
[null,"O-1","Elice",9009]
[null,"P-1","Troy",11170]
[null,"W-2","Yeats",13331]

{"sheet":"InsertColumnWithRightClick","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Inserting Column with Right Click"]
[]
[null,"ID",null,"Name","Sales"]
[null,"M-1",null,"Jack",5798]
[null,"A-1",null,"John",8087]
[null,"A-3",null,"Alex",5083]
[null,"A-4",null,"Bob",6848]
[null,"O-1",null,"Elice",9009]
[null,"P-1",null,"Troy",11170]
[null,"W-2",null,"Yeats",13331]

{"sheet":"Using SHIFT + CTRL + Equal (=)","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using SHIFT + CTRL + Equal (=) Keys"]
[]
[null,"ID",null,"Name","Sales"]
[null,"M-1",null,"Jack",5798]
[null,"A-1",null,"John",8087]
[null,"A-3",null,"Alex",5083]
[null,"A-4",null,"Bob",6848]
[null,"O-1",null,"Elice",9009]
[null,"P-1",null,"Troy",11170]
[null,"W-2",null,"Yeats",13331]

{"sheet":"Using Shortcut ALT + I, C","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using ALT + I, C Keys"]
[]
[null,"ID",null,"Name","Sales"]
[null,"M-1",null,"Jack",5798]
[null,"A-1",null,"John",8087]
[null,"A-3",null,"Alex",5083]
[null,"A-4",null,"Bob",6848]
[null,"O-1",null,"Elice",9009]
[null,"P-1",null,"Troy",11170]
[null,"W-2",null,"Yeats",13331]

{"sheet":"InsertMultipleAdjacentColumns","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Inserting Multiple Adjacent Columns"]
[]
[null,"ID",null,null,"Name","Sales"]
[null,"M-1",null,null,"Jack",5798]
[null,"A-1",null,null,"John",8087]
[null,"A-3",null,null,"Alex",5083]
[null,"A-4",null,null,"Bob",6848]
[null,"O-1",null,null,"Elice",9009]
[null,"P-1",null,null,"Troy",11170]
[null,"W-2",null,null,"Yeats",13331]

{"sheet":"MultipleNon-AdjacentColumns","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Inserting Multiple Non-Adjacent Columns"]
[]
[null,"ID",null,"Name",null,"Sales"]
[null,"M-1",null,"Jack",null,5798]
[null,"A-1",null,"John",null,8087]
[null,"A-3",null,"Alex",null,5083]
[null,"A-4",null,"Bob",null,6848]
[null,"O-1",null,"Elice",null,9009]
[null,"P-1",null,"Troy",null,11170]
[null,"W-2",null,"Yeats",null,13331]

{"sheet":"Insert a Column from Home Tab","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Inserting a Column from Home Tab"]
[]
[null,"ID",null,"Name","Sales"]
[null,"M-1",null,"Jack",5798]
[null,"A-1",null,"John",8087]
[null,"A-3",null,"Alex",5083]
[null,"A-4",null,"Bob",6848]
[null,"O-1",null,"Elice",9009]
[null,"P-1",null,"Troy",11170]
[null,"W-2",null,"Yeats",13331]

{"sheet":"InsertColumnWithClick&Drag","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Inserting Column with Click and Drag"]
[]
[null,"ID",null,"Name","Sales"]
[null,"M-1",null,"Jack",5798]
[null,"A-1",null,"John",8087]
[null,"A-3",null,"Alex",5083]
[null,"A-4",null,"Bob",6848]
[null,"O-1",null,"Elice",9009]
[null,"P-1",null,"Troy",11170]
[null,"W-2",null,"Yeats",13331]

{"sheet":"InsertColumUsingFillHandle","index":8,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Inserting a Column Using Fill Handle"]
[]
[null,"ID","Name",null,"Sales"]
[null,"M-1","Jack",null,5798]
[null,"A-1","John",null,8087]
[null,"A-3","Alex",null,5083]
[null,"A-4","Bob",null,6848]
[null,"O-1","Elice",null,9009]
[null,"P-1","Troy",null,11170]
[null,"W-2","Yeats",null,13331]

{"sheet":"InsertColumnWithHSTACKfunction","index":9,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Inserting Column Using HSTACK Function"]
[]
[null,"ID","Name","Sales",null,"Age",null,{"$f":" _xlfn.HSTACK( C4:C11,F4:F11,D4:D11)","v":"Name"},"Age","Sales"]
[null,"M-1","Jack",5798,null,45,null,"Jack",45,5798]
[null,"A-1","John",8087,null,55,null,"John",55,8087]
[null,"A-3","Alex",5083,null,38,null,"Alex",38,5083]
[null,"A-4","Bob",6848,null,30,null,"Bob",30,6848]
[null,"O-1","Elice",9009,null,44,null,"Elice",44,9009]
[null,"P-1","Troy",11170,null,39,null,"Troy",39,11170]
[null,"W-2","Yeats",13331,null,51,null,"Yeats",51,13331]

{"sheet":"InsertingColumnWithPowerPivot","index":10,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Inserting a Column with Power Pivot"]
[]
[null,"ID","Name","Sales"]
[null,"M-1","Jack",5798]
[null,"A-1","John",8087]
[null,"A-3","Alex",5083]
[null,"A-4","Bob",6848]
[null,"O-1","Elice",9009]
[null,"P-1","Troy",11170]
[null,"W-2","Yeats",13331]

{"sheet":"InsertingColumnWithPowerQuery","index":11,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Inserting a Column with Power Query"]
[]
[null,"ID","Name","Sales"]
[null,"M-1","Jack",5798]
[null,"A-1","John",8087]
[null,"A-3","Alex",5083]
[null,"A-4","Bob",6848]
[null,"O-1","Elice",9009]
[null,"P-1","Troy",11170]
[null,"W-2","Yeats",13331]

{"sheet":"Sales","index":12,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Inserting a Column with Power Query"]
[]
[null,"ID","Name","Sales","Region"]
[null,"M-1","Jack",5798,"North"]
[null,"A-1","John",8087,"South"]
[null,"A-3","Alex",5083,"North"]
[null,"A-4","Bob",6848,"West"]
[null,"O-1","Elice",9009,"East"]
[null,"P-1","Troy",11170,"East"]
[null,"W-2","Yeats",13331,"South"]

{"sheet":"InsertSingleColumnWithVBA","index":13,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Inserting Single Column with VBA"]
[]
[null,"ID",null,"Name","Sales"]
[null,"M-1",null,"Jack",5798]
[null,"A-1",null,"John",8087]
[null,"A-3",null,"Alex",5083]
[null,"A-4",null,"Bob",6848]
[null,"O-1",null,"Elice",9009]
[null,"P-1",null,"Troy",11170]
[null,"W-2",null,"Yeats",13331]

{"sheet":"InsertMultipleColumnsWithVBA","index":14,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Inserting Multiple Columns with VBA"]
[]
[null,"ID",null,null,"Name","Sales"]
[null,"M-1",null,null,"Jack",5798]
[null,"A-1",null,null,"John",8087]
[null,"A-3",null,null,"Alex",5083]
[null,"A-4",null,null,"Bob",6848]
[null,"O-1",null,null,"Elice",9009]
[null,"P-1",null,null,"Troy",11170]
[null,"W-2",null,null,"Yeats",13331]

{"sheet":"InsertEveryOtherColumnWithVBA","index":15,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Insert Between Every Other Column with VBA"]
[]
[null,"ID",null,"Name",null,"Sales"]
[null,"M-1",null,"Jack",null,5798]
[null,"A-1",null,"John",null,8087]
[null,"A-3",null,"Alex",null,5083]
[null,"A-4",null,"Bob",null,6848]
[null,"O-1",null,"Elice",null,9009]
[null,"P-1",null,"Troy",null,11170]
[null,"W-2",null,"Yeats",null,13331]

{"sheet":"InsertColumnInTheMiddleOfATable","index":16,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Inserting a Column in the Middle of a Table"]
[]
[null,"ID","Column1","Name","Sales"]
[null,"M-1",null,"Jack",5798]
[null,"A-1",null,"John",8087]
[null,"A-3",null,"Alex",5083]
[null,"A-4",null,"Bob",6848]
[null,"O-1",null,"Elice",9009]
[null,"P-1",null,"Troy",11170]
[null,"W-2",null,"Yeats",13331]

{"sheet":"InsertColumnAtTheEndOfATable","index":17,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Inserting a Column at the End of a Table"]
[]
[null,"ID","Name","Sales","Region"]
[null,"M-1","Jack",5798]
[null,"A-1","John",8087]
[null,"A-3","Alex",5083]
[null,"A-4","Bob",6848]
[null,"O-1","Elice",9009]
[null,"P-1","Troy",11170]
[null,"W-2","Yeats",13331]