{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Home Page","Dataset","Merge Vs Combine","1.1 Merging Two Cells-V","1.1 Merging Two Cells-H","1.2 Merge Entire Column","1.3 Merging Without Losing Data","1.3.2 CONCAT Function","1.3.3 TEXTJOIN Function","1.3.4 Ampersand","1.3.5 Justify Feature","1.4 Merging Multiple Cells-V","1.4 Merge Multiple Cells-H","1.5 Merge Shortcut","1.6 Merge VBA","2. Merge in Table","6.1 Using Text Box","6.2 Using Alignment ","7. Unmerge Cells","8. Moving Merged Cells"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":19,"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":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[34,1,34,3],[35,1,35,2],[36,1,36,3],[37,1,37,2],[28,1,28,2],[29,1,29,2],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,3],[27,1,27,2],[16,1,16,2],[17,1,17,2],[18,1,18,3],[19,1,19,2],[20,1,20,2],[21,1,21,2]]}
[]
[]
[]
[]
[]
[]
[null,"Merge Cells in Excel"]
[]
[null,"Learn to merge cells in Excel with this free workbook. Read the article we provided and practice these in practice section."]
[]
[null,"Prepared By:","Musiha Mahfuza Mukta"]
[null,"Reviewed By:","Mursalin Ibne Salehin"]
[null,"Last Update:","2023-12-05"]
[null,"Article Link:","https://www.exceldemy.com/learn-excel/merge/cells/"]
[]
[null,"Main Content"]
[null,"Merge Cells vs Combine Cells"]
[null,"How to Merge Cells in Excel"]
[null," 1. Merge Cells Using Merge & Center Command"]
[null,"    1.1.1. Merging Two Cells Vertically"]
[null,"    1.1.2. Merging Two Cells Horizontally"]
[null,"    1.2. Merge and Centre Cells of a Column"]
[null,"    1.3. Merge Multiple Cells Vertically"]
[null,"   1.4 Merge Multiple Cells Toward a Row"]
[null," 2. Merge Cells Using Keyboard Shortcuts"]
[null," 3. Merge Cells with Excel VBA"]
[null," 4. Use of Alignment Feature to Merge Cells in Excel"]
[null,"How to Merge Cells in Excel Table"]
[null,"How to Move Merged Cells in Excel"]
[null,"How to Merge Cells Without Losing Data"]
[null," 1.1. Using CONCATENATE Function to Combine Two Cells"]
[null," 1.2. Using CONCAT Function to Combine Two Cells"]
[null," 1.3. Using Ampersand Operator to Combine Two Cells"]
[null," 2. Applying TEXTJOIN Function to Combine Multiple Cells"]
[null," 3. Combine Cells Within One Column Using Justify Feature"]
[null,"An Alternative to Merge Cells in Excel"]
[null," Use of Text Box as an Alternative of Merge Cells"]
[null,"How to Unmerge Cells in Excel"]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Dataset","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Merge Cells in Excel"]
[]
[null,"Sample Dataset"]
[]
[null,"Order ID","Product Name","Category","Brand","Price"]
[null,101,"Dress","Apparel","XYZ",49.99]
[null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,101,"Dress","Apparel","XYZ",76.22]
[null,102,"Sandals","Apparel","DAC",21.23]
[null,102,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,102,"Jacket","Apparel","XYZ",69.23]
[null,103,"Hiking Boots","Footwear","BEF",54.43]
[null,103,"Shoes","Footwear","BEF",56.98]
[null,103,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Merge Vs Combine","index":2,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,1,7,1],[8,1,10,1],[11,1,13,1]]}
[null,"Merge Cells in Excel"]
[]
[null,"Merging Cells Vs Combining Cells"]
[]
[null,"Order ID","Product Name","Brand","Price",null,"New ID"]
[null,101,"Dress","XYZ",49.99,null,{"$f":"C6&\"-\"&D6","v":"Dress-XYZ"},{"$f":"_xlfn.FORMULATEXT(G6)","v":"=C6&\"-\"&D6"}]
[null,null,"Polo Shirt","DAC",34.229999999999997,null,{"$f":"C7&\"-\"&D7","v":"Polo Shirt-DAC"},{"$f":"_xlfn.FORMULATEXT(G7)","v":"=C7&\"-\"&D7"}]
[null,null,"Dress","XYZ",76.22,null,"Dress-XYZ","=C8&\"-\"&D8"]
[null,102,"Sandals","DAC",21.23,null,"Sandals-DAC","=C9&\"-\"&D9"]
[null,null,"T-shirt","XYZ",32.979999999999997,null,"T-shirt-XYZ","=C10&\"-\"&D10"]
[null,null,"Jacket","XYZ",69.23,null,"Jacket-XYZ","=C11&\"-\"&D11"]
[null,103,"Hiking Boots","BEF",54.43,null,"Hiking Boots-BEF","=C12&\"-\"&D12"]
[null,null,"Shoes","BEF",56.98,null,"Shoes-BEF","=C13&\"-\"&D13"]
[null,null,"High Heels","DAC",79.989999999999995,null,"High Heels-DAC","=C14&\"-\"&D14"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.1 Merging Two Cells-V","index":3,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,1,6,1],[7,1,8,1],[9,1,10,1],[11,1,12,1]]}
[null,"Merge Cells in Excel"]
[]
[null,"Merging Two Cells Vertically",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,null,null,null,null,null,"Order ID","Product Name","Category","Brand","Price"]
[null,101,"Dress","Apparel","XYZ",49.99,null,null,null,null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,null,"Polo Shirt","Apparel","DAC",34.229999999999997,null,null,null,null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,102,"Dress","Apparel","XYZ",76.22,null,null,null,null,null,null,102,"Dress","Apparel","XYZ",76.22]
[null,null,"Sandals","Apparel","DAC",21.23,null,null,null,null,null,null,102,"Sandals","Apparel","DAC",21.23]
[null,103,"T-shirt","Apparel","XYZ",32.979999999999997,null,null,null,null,null,null,103,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,null,"Jacket","Apparel","XYZ",69.23,null,null,null,null,null,null,103,"Jacket","Apparel","XYZ",69.23]
[null,104,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,null,null,104,"Hiking Boots","Footwear","BEF",54.43]
[null,null,"Shoes","Footwear","BEF",56.98,null,null,null,null,null,null,104,"Shoes","Footwear","BEF",56.98]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.1 Merging Two Cells-H","index":4,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,1,5,2],[12,1,12,2]]}
[null,"Merge Cells in Excel"]
[]
[null,"Merging Two Cells Horizontally",null,null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Order ID","Product Name","Brand","Price",null,null,null,null,null,null,"Order ID","Product Name","Brand","Price"]
[null,"Apparel Details",null,null,null,null,null,null,null,null,null,"Apparel Details"]
[null,101,"Dress","DAC",49.99,null,null,null,null,null,null,101,"Dress","DAC",49.99]
[null,102,"Polo Shirt","DAC",34.229999999999997,null,null,null,null,null,null,102,"Polo Shirt","DAC",34.229999999999997]
[null,103,"Dress","XYZ",76.22,null,null,null,null,null,null,103,"Dress","XYZ",76.22]
[null,104,"Sandals","DAC",21.23,null,null,null,null,null,null,104,"Sandals","DAC",21.23]
[null,105,"T-shirt","XYZ",32.979999999999997,null,null,null,null,null,null,105,"T-shirt","XYZ",32.979999999999997]
[null,106,"Jacket","XYZ",69.23,null,null,null,null,null,null,106,"Jacket","XYZ",69.23]
[null,"Footwear Details",null,null,null,null,null,null,null,null,null,"Footwear Details"]
[null,107,"Hiking Boots","BEF",54.43,null,null,null,null,null,null,107,"Hiking Boots","BEF",54.43]
[null,108,"Shoes","BEF",56.98,null,null,null,null,null,null,108,"Shoes","BEF",56.98]
[null,109,"High Heels","DAC",79.989999999999995,null,null,null,null,null,null,109,"High Heels","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.2 Merge Entire Column","index":5,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,1,13,1]]}
[null,"Merge Cells in Excel"]
[]
[null,"Merge and Centre Cells of Entire Column",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,null,null,null,null,null,"Order ID","Product Name","Category","Brand","Price"]
[null,101,"Dress","Apparel","XYZ",49.99,null,null,null,null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,null,"Polo Shirt","Apparel","DAC",34.229999999999997,null,null,null,null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,null,"Dress","Apparel","XYZ",76.22,null,null,null,null,null,null,101,"Dress","Apparel","XYZ",76.22]
[null,null,"Sandals","Apparel","DAC",21.23,null,null,null,null,null,null,101,"Sandals","Apparel","DAC",21.23]
[null,null,"T-shirt","Apparel","XYZ",32.979999999999997,null,null,null,null,null,null,101,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,null,"Jacket","Apparel","XYZ",69.23,null,null,null,null,null,null,101,"Jacket","Apparel","XYZ",69.23]
[null,null,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,null,null,101,"Hiking Boots","Footwear","BEF",54.43]
[null,null,"Shoes","Footwear","BEF",56.98,null,null,null,null,null,null,101,"Shoes","Footwear","BEF",56.98]
[null,null,"High Heels","Footwear","DAC",79.989999999999995,null,null,null,null,null,null,101,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.3 Merging Without Losing Data","index":6,"n_rows":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Merge Cells in Excel"]
[]
[null,"Using CONCATENATE Function to Merge Cells Without Losing Data",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,"Order ID - Brand",null,null,null,null,null,"Order ID","Product Name","Category","Brand","Price",null,"Order ID - Brand"]
[null,101,"Dress","Apparel","XYZ",49.99,null,{"$f":"CONCATENATE(B6,\"-\",E6)","v":"101-XYZ"},{"$f":"_xlfn.FORMULATEXT(H6)","v":"=CONCATENATE(B6,\"-\",E6)"},null,null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,101,"Polo Shirt","Apparel","DAC",34.229999999999997,null,{"$f":"CONCATENATE(B7,\"-\",E7)","v":"101-DAC"},{"$f":"_xlfn.FORMULATEXT(H7)","v":"=CONCATENATE(B7,\"-\",E7)"},null,null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,101,"Dress","Apparel","XYZ",76.22,null,"101-XYZ","=CONCATENATE(B8,\"-\",E8)",null,null,null,null,101,"Dress","Apparel","XYZ",76.22]
[null,102,"Sandals","Apparel","DAC",21.23,null,"102-DAC","=CONCATENATE(B9,\"-\",E9)",null,null,null,null,102,"Sandals","Apparel","DAC",21.23]
[null,102,"T-shirt","Apparel","XYZ",32.979999999999997,null,"102-XYZ","=CONCATENATE(B10,\"-\",E10)",null,null,null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,102,"Jacket","Apparel","XYZ",69.23,null,"102-XYZ","=CONCATENATE(B11,\"-\",E11)",null,null,null,null,102,"Jacket","Apparel","XYZ",69.23]
[null,103,"Hiking Boots","Footwear","BEF",54.43,null,"103-BEF","=CONCATENATE(B12,\"-\",E12)",null,null,null,null,103,"Hiking Boots","Footwear","BEF",54.43]
[null,103,"Shoes","Footwear","BEF",56.98,null,"103-BEF","=CONCATENATE(B13,\"-\",E13)",null,null,null,null,103,"Shoes","Footwear","BEF",56.98]
[null,103,"High Heels","Footwear","DAC",79.989999999999995,null,"103-DAC","=CONCATENATE(B14,\"-\",E14)",null,null,null,null,103,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.3.2 CONCAT Function","index":7,"n_rows":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Merge Cells in Excel"]
[]
[null,"Using CONCAT Function to Merge Cells Without Losing Data",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,"Order ID - Brand",null,null,null,null,null,"Order ID","Product Name","Category","Brand","Price",null,"Order ID - Brand"]
[null,101,"Dress","Apparel","XYZ",49.99,null,{"$f":"_xlfn.CONCAT(B6,\"-\",E6)","v":"101-XYZ"},{"$f":"_xlfn.FORMULATEXT(H6)","v":"=CONCAT(B6,\"-\",E6)"},null,null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,101,"Polo Shirt","Apparel","DAC",34.229999999999997,null,"101-DAC",{"$f":"_xlfn.FORMULATEXT(H7)","v":"=CONCAT(B7,\"-\",E7)"},null,null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,101,"Dress","Apparel","XYZ",76.22,null,"101-XYZ","=CONCAT(B8,\"-\",E8)",null,null,null,null,101,"Dress","Apparel","XYZ",76.22]
[null,102,"Sandals","Apparel","DAC",21.23,null,"102-DAC","=CONCAT(B9,\"-\",E9)",null,null,null,null,102,"Sandals","Apparel","DAC",21.23]
[null,102,"T-shirt","Apparel","XYZ",32.979999999999997,null,"102-XYZ","=CONCAT(B10,\"-\",E10)",null,null,null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,102,"Jacket","Apparel","XYZ",69.23,null,"102-XYZ","=CONCAT(B11,\"-\",E11)",null,null,null,null,102,"Jacket","Apparel","XYZ",69.23]
[null,103,"Hiking Boots","Footwear","BEF",54.43,null,"103-BEF","=CONCAT(B12,\"-\",E12)",null,null,null,null,103,"Hiking Boots","Footwear","BEF",54.43]
[null,103,"Shoes","Footwear","BEF",56.98,null,"103-BEF","=CONCAT(B13,\"-\",E13)",null,null,null,null,103,"Shoes","Footwear","BEF",56.98]
[null,103,"High Heels","Footwear","DAC",79.989999999999995,null,"103-DAC","=CONCAT(B14,\"-\",E14)",null,null,null,null,103,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.3.3 TEXTJOIN Function","index":8,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Merge Cells in Excel"]
[]
[null,"Applying TEXTJOIN Function to Combine Multiple Cells",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Brand","Price",null,"Combined Cells",null,null,null,null,"Order ID","Product Name","Category","Brand","Price",null,"Combined Cells"]
[null,101,"Dress","XYZ",49.99,null,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B6:E6)","v":"101,Dress,XYZ,49.99"},{"$f":"_xlfn.FORMULATEXT(G6)","v":"=TEXTJOIN(\",\",TRUE,B6:E6)"},null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,101,"Polo Shirt","DAC",34.229999999999997,null,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B7:E7)","v":"101,Polo Shirt,DAC,34.23"},{"$f":"_xlfn.FORMULATEXT(G7)","v":"=TEXTJOIN(\",\",TRUE,B7:E7)"},null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,101,"Dress","XYZ",76.22,null,"101,Dress,XYZ,76.22","=TEXTJOIN(\",\",TRUE,B8:E8)",null,null,null,101,"Dress","Apparel","XYZ",76.22]
[null,102,"Sandals","DAC",21.23,null,"102,Sandals,DAC,21.23","=TEXTJOIN(\",\",TRUE,B9:E9)",null,null,null,102,"Sandals","Apparel","DAC",21.23]
[null,102,"T-shirt","XYZ",32.979999999999997,null,"102,T-shirt,XYZ,32.98","=TEXTJOIN(\",\",TRUE,B10:E10)",null,null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,102,"Jacket","XYZ",69.23,null,"102,Jacket,XYZ,69.23","=TEXTJOIN(\",\",TRUE,B11:E11)",null,null,null,102,"Jacket","Apparel","XYZ",69.23]
[null,103,"Hiking Boots","BEF",54.43,null,"103,Hiking Boots,BEF,54.43","=TEXTJOIN(\",\",TRUE,B12:E12)",null,null,null,103,"Hiking Boots","Footwear","BEF",54.43]
[null,103,"Shoes","BEF",56.98,null,"103,Shoes,BEF,56.98","=TEXTJOIN(\",\",TRUE,B13:E13)",null,null,null,103,"Shoes","Footwear","BEF",56.98]
[null,103,"High Heels","DAC",79.989999999999995,null,"103,High Heels,DAC,79.99","=TEXTJOIN(\",\",TRUE,B14:E14)",null,null,null,103,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.3.4 Ampersand","index":9,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Merge Cells in Excel"]
[]
[null,"Using Ampersand Operator to Merge Cells Without Losing Data",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,"New ID",null,null,null,null,"Order ID","Product Name","Category","Brand","Price",null,"New ID"]
[null,101,"Dress","Apparel","XYZ",49.99,null,{"$f":"B6&E6","v":"101XYZ"},{"$f":"_xlfn.FORMULATEXT(H6)","v":"=B6&E6"},null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,101,"Polo Shirt","Apparel","DAC",34.229999999999997,null,{"$f":"B7&E7","v":"101DAC"},{"$f":"_xlfn.FORMULATEXT(H7)","v":"=B7&E7"},null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,101,"Dress","Apparel","XYZ",76.22,null,"101XYZ","=B8&E8",null,null,null,101,"Dress","Apparel","XYZ",76.22]
[null,102,"Sandals","Apparel","DAC",21.23,null,"102DAC","=B9&E9",null,null,null,102,"Sandals","Apparel","DAC",21.23]
[null,102,"T-shirt","Apparel","XYZ",32.979999999999997,null,"102XYZ","=B10&E10",null,null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,102,"Jacket","Apparel","XYZ",69.23,null,"102XYZ","=B11&E11",null,null,null,102,"Jacket","Apparel","XYZ",69.23]
[null,103,"Hiking Boots","Footwear","BEF",54.43,null,"103BEF","=B12&E12",null,null,null,103,"Hiking Boots","Footwear","BEF",54.43]
[null,103,"Shoes","Footwear","BEF",56.98,null,"103BEF","=B13&E13",null,null,null,103,"Shoes","Footwear","BEF",56.98]
[null,103,"High Heels","Footwear","DAC",79.989999999999995,null,"103DAC","=B14&E14",null,null,null,103,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.3.5 Justify Feature","index":10,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Merge Cells in Excel"]
[]
[null,"Using Justify Feature to Merge Cell Values in One Column",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Product Name",null,null,null,null,null,null,null,null,null,null,"Product Name"]
[null,"Dress Polo Shirt Sandals T-shirt Jacket Hiking Boots Shoes",null,null,null,null,null,null,null,null,null,null,"Dress"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Polo Shirt "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sandals"]
[null,null,null,null,null,null,null,null,null,null,null,null,"T-shirt"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jacket"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hiking Boots"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shoes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.4 Merging Multiple Cells-V","index":11,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,1,13,1]]}
[null,"Merge Cells in Excel"]
[]
[null,"Merging Multiple Cells Vertically",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Caution","Order ID","Product Name","Category","Brand","Price",null,null,null,null,null,null,"Caution","Product Name","Category","Brand","Price"]
[null,"Be Mindful of Online Security and Privacy",101,"Dress","Apparel","XYZ",49.99,null,null,null,null,null,null,"Be Mindful of Online Security and Privacy","Dress","Apparel","XYZ",49.99]
[null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997,null,null,null,null,null,null,null,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,null,101,"Dress","Apparel","XYZ",76.22,null,null,null,null,null,null,null,"Dress","Apparel","XYZ",76.22]
[null,null,101,"Sandals","Apparel","DAC",21.23,null,null,null,null,null,null,null,"Sandals","Apparel","DAC",21.23]
[null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997,null,null,null,null,null,null,null,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,null,102,"Jacket","Apparel","XYZ",69.23,null,null,null,null,null,null,null,"Jacket","Apparel","XYZ",69.23]
[null,null,102,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,null,null,null,"Hiking Boots","Footwear","BEF",54.43]
[null,null,102,"Shoes","Footwear","BEF",56.98,null,null,null,null,null,null,null,"Shoes","Footwear","BEF",56.98]
[null,null,102,"High Heels","Footwear","DAC",79.989999999999995,null,null,null,null,null,null,null,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.4 Merge Multiple Cells-H","index":12,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,1,5,5],[12,1,12,5]]}
[null,"Merge Cells in Excel"]
[]
[null,"Merging Multiple Cells Horizontally",null,null,null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,null,null,null,null,null,"Order ID","Product Name","Category","Brand","Price"]
[null,"Apparel Details for Customer",null,null,null,null,null,null,null,null,null,null,"Apparel Details for Customer"]
[null,101,"Dress","Apparel","DAC",49.99,null,null,null,null,null,null,101,"Dress","Apparel","DAC",49.99]
[null,102,"Polo Shirt","Apparel","DAC",34.229999999999997,null,null,null,null,null,null,102,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,103,"Dress","Apparel","XYZ",76.22,null,null,null,null,null,null,103,"Dress","Apparel","XYZ",76.22]
[null,104,"Sandals","Apparel","DAC",21.23,null,null,null,null,null,null,104,"Sandals","Apparel","DAC",21.23]
[null,105,"T-shirt","Apparel","XYZ",32.979999999999997,null,null,null,null,null,null,105,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,106,"Jacket","Apparel","XYZ",69.23,null,null,null,null,null,null,106,"Jacket","Apparel","XYZ",69.23]
[null,"Footwear Details for Customer",null,null,null,null,null,null,null,null,null,null,"Footwear Details for Customer"]
[null,107,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,null,null,107,"Hiking Boots","Footwear","BEF",54.43]
[null,108,"Shoes","Footwear","BEF",56.98,null,null,null,null,null,null,108,"Shoes","Footwear","BEF",56.98]
[null,109,"High Heels","Footwear","DAC",79.989999999999995,null,null,null,null,null,null,109,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.5 Merge Shortcut","index":13,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,1,13,1],[5,2,5,4]]}
[null,"Merge Cells in Excel"]
[]
[null,"Merging Cells Using Keyboard Shortcuts",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,null,null,null,null,null,"Order ID","Product Name","Category","Brand","Price"]
[null,101,"Dress",null,null,49.99,null,null,null,null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,null,"Polo Shirt","Apparel","DAC",34.229999999999997,null,null,null,null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,null,"Dress","Apparel","XYZ",76.22,null,null,null,null,null,null,101,"Dress","Apparel","XYZ",76.22]
[null,null,"Sandals","Apparel","DAC",21.23,null,null,null,null,null,null,101,"Sandals","Apparel","DAC",21.23]
[null,null,"T-shirt","Apparel","XYZ",32.979999999999997,null,null,null,null,null,null,101,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,null,"Jacket","Apparel","XYZ",69.23,null,null,null,null,null,null,101,"Jacket","Apparel","XYZ",69.23]
[null,null,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,null,null,101,"Hiking Boots","Footwear","BEF",54.43]
[null,null,"Shoes","Footwear","BEF",56.98,null,null,null,null,null,null,101,"Shoes","Footwear","BEF",56.98]
[null,null,"High Heels","Footwear","DAC",79.989999999999995,null,null,null,null,null,null,101,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.6 Merge VBA","index":14,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,1,7,1],[8,1,10,1],[11,1,13,1],[5,3,10,3],[11,3,13,3]]}
[null,"Merge Cells in Excel"]
[]
[null,"Merging Cells Using VBA Code",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,null,null,null,null,null,"Order ID","Product Name","Category","Brand","Price"]
[null,101,"Dress","Apparel","XYZ",49.99,null,null,null,null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,null,"Polo Shirt",null,"DAC",34.229999999999997,null,null,null,null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,null,"Dress",null,"XYZ",76.22,null,null,null,null,null,null,101,"Dress","Apparel","XYZ",76.22]
[null,102,"Sandals",null,"DAC",21.23,null,null,null,null,null,null,102,"Sandals","Apparel","DAC",21.23]
[null,null,"T-shirt",null,"XYZ",32.979999999999997,null,null,null,null,null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,null,"Jacket",null,"XYZ",69.23,null,null,null,null,null,null,102,"Jacket","Apparel","XYZ",69.23]
[null,103,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,null,null,103,"Hiking Boots","Footwear","BEF",54.43]
[null,null,"Shoes",null,"BEF",56.98,null,null,null,null,null,null,103,"Shoes","Footwear","BEF",56.98]
[null,null,"High Heels",null,"DAC",79.989999999999995,null,null,null,null,null,null,103,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"2. Merge in Table","index":15,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,1,7,1],[8,1,10,1],[11,1,13,1]]}
[null,"Merge Cells in Excel"]
[]
[null,"Merge Cells in Excel Table",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,null,null,null,"Order ID","Product Name","Category","Brand","Price"]
[null,101,"Dress","Apparel","XYZ",49.99,null,null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,null,"Polo Shirt","Apparel","DAC",34.229999999999997,null,null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,null,"Dress","Apparel","XYZ",76.22,null,null,null,null,101,"Dress","Apparel","XYZ",76.22]
[null,102,"Sandals","Apparel","DAC",21.23,null,null,null,null,102,"Sandals","Apparel","DAC",21.23]
[null,null,"T-shirt","Apparel","XYZ",32.979999999999997,null,null,null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,null,"Jacket","Apparel","XYZ",69.23,null,null,null,null,102,"Jacket","Apparel","XYZ",69.23]
[null,103,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,103,"Hiking Boots","Footwear","BEF",54.43]
[null,null,"Shoes","Footwear","BEF",56.98,null,null,null,null,103,"Shoes","Footwear","BEF",56.98]
[null,null,"High Heels","Footwear","DAC",79.989999999999995,null,null,null,null,103,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"6.1 Using Text Box","index":16,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"Merge Cells in Excel"]
[]
[null,"Using Text Box to Merge Cells",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,null,null,null,"Order ID","Product Name","Category","Brand","Price"]
[null,101,"Dress","Apparel","XYZ",49.99,null,null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,101,"Polo Shirt","Apparel","DAC",34.229999999999997,null,null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,101,"Dress","Apparel","XYZ",76.22,null,null,null,null,101,"Dress","Apparel","XYZ",76.22]
[null,102,"Sandals","Apparel","DAC",21.23,null,null,null,null,102,"Sandals","Apparel","DAC",21.23]
[null,102,"T-shirt","Apparel","XYZ",32.979999999999997,null,null,null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,102,"Jacket","Apparel","XYZ",69.23,null,null,null,null,102,"Jacket","Apparel","XYZ",69.23]
[null,103,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,103,"Hiking Boots","Footwear","BEF",54.43]
[null,103,"Shoes","Footwear","BEF",56.98,null,null,null,null,103,"Shoes","Footwear","BEF",56.98]
[null,103,"High Heels","Footwear","DAC",79.989999999999995,null,null,null,null,103,"High Heels","Footwear","DAC",79.989999999999995]
[]
[null,"Caution","Be Mindful of Online Security and Privacy","Policy","We offer refund and/or exchange within the first 30 days of your purchase","  "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"6.2 Using Alignment ","index":17,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,1,13,1]]}
[null,"Merge Cells in Excel"]
[]
[null,"Using Alignment Feature to Merge Cells",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Caution","Order ID","Product Name","Category","Brand","Price",null,null,null,null,"Caution","Order ID","Product Name","Category","Brand","Price"]
[null,"Be Mindful of Online Security and Privacy",101,"Dress","Apparel","XYZ",49.99,null,null,null,null,"Be Mindful of Online Security and Privacy",101,"Dress","Apparel","XYZ",49.99]
[null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997,null,null,null,null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,null,101,"Dress","Apparel","XYZ",76.22,null,null,null,null,null,101,"Dress","Apparel","XYZ",76.22]
[null,null,102,"Sandals","Apparel","DAC",21.23,null,null,null,null,null,102,"Sandals","Apparel","DAC",21.23]
[null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997,null,null,null,null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,null,102,"Jacket","Apparel","XYZ",69.23,null,null,null,null,null,102,"Jacket","Apparel","XYZ",69.23]
[null,null,103,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,null,103,"Hiking Boots","Footwear","BEF",54.43]
[null,null,103,"Shoes","Footwear","BEF",56.98,null,null,null,null,null,103,"Shoes","Footwear","BEF",56.98]
[null,null,103,"High Heels","Footwear","DAC",79.989999999999995,null,null,null,null,null,103,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"7. Unmerge Cells","index":18,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,10,7,10],[8,10,10,10],[11,10,13,10]]}
[null,"Merge Cells in Excel"]
[]
[null,"Unmerging Cells",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Order ID","Product Name","Category","Brand","Price",null,null,null,null,"Order ID","Product Name","Category","Brand","Price"]
[null,101,"Dress","Apparel","XYZ",49.99,null,null,null,null,101,"Dress","Apparel","XYZ",49.99]
[null,null,"Polo Shirt","Apparel","DAC",34.229999999999997,null,null,null,null,null,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,null,"Dress","Apparel","XYZ",76.22,null,null,null,null,null,"Dress","Apparel","XYZ",76.22]
[null,102,"Sandals","Apparel","DAC",21.23,null,null,null,null,102,"Sandals","Apparel","DAC",21.23]
[null,null,"T-shirt","Apparel","XYZ",32.979999999999997,null,null,null,null,null,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,null,"Jacket","Apparel","XYZ",69.23,null,null,null,null,null,"Jacket","Apparel","XYZ",69.23]
[null,103,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,103,"Hiking Boots","Footwear","BEF",54.43]
[null,null,"Shoes","Footwear","BEF",56.98,null,null,null,null,null,"Shoes","Footwear","BEF",56.98]
[null,null,"High Heels","Footwear","DAC",79.989999999999995,null,null,null,null,null,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"8. Moving Merged Cells","index":19,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[5,7,13,7]]}
[null,"Merge Cells in Excel"]
[]
[null,"Using VBA to Move Merged Cells",null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,null,"Order ID","Product Name","Category","Brand","Price","Caution",null,null,null,null,null,null,"Caution","Product Name","Category","Brand","Price"]
[null,null,101,"Dress","Apparel","XYZ",49.99,"Be Mindful of Online Security and Privacy",null,null,null,null,null,null,"Be Mindful of Online Security and Privacy","Dress","Apparel","XYZ",49.99]
[null,null,101,"Polo Shirt","Apparel","DAC",34.229999999999997,null,null,null,null,null,null,null,null,"Polo Shirt","Apparel","DAC",34.229999999999997]
[null,null,101,"Dress","Apparel","XYZ",76.22,null,null,null,null,null,null,null,null,"Dress","Apparel","XYZ",76.22]
[null,null,101,"Sandals","Apparel","DAC",21.23,null,null,null,null,null,null,null,null,"Sandals","Apparel","DAC",21.23]
[null,null,102,"T-shirt","Apparel","XYZ",32.979999999999997,null,null,null,null,null,null,null,null,"T-shirt","Apparel","XYZ",32.979999999999997]
[null,null,102,"Jacket","Apparel","XYZ",69.23,null,null,null,null,null,null,null,null,"Jacket","Apparel","XYZ",69.23]
[null,null,102,"Hiking Boots","Footwear","BEF",54.43,null,null,null,null,null,null,null,null,"Hiking Boots","Footwear","BEF",54.43]
[null,null,102,"Shoes","Footwear","BEF",56.98,null,null,null,null,null,null,null,null,"Shoes","Footwear","BEF",56.98]
[null,null,102,"High Heels","Footwear","DAC",79.989999999999995,null,null,null,null,null,null,null,null,"High Heels","Footwear","DAC",79.989999999999995]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]