{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Home Page","1. AutoFill","2. Copy-Paste Command","3.1 Ctrl + Enter","3.2 Ctrl + D","3.3 Ctrl + R","4. Dynamic Arrays","5. Convert into table","6. VBA"," Without Changing Cell Ref","Change Formulas Multiple Cells","Blank Cell","Non-Adjacent Cells"],"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":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"How to Apply Same Formula to Multiple Cells in Excel"]
[]
[null,"Learn the methods to apply same formula to multiple cells in Excel. Read the article we provided and practice these in practice section."]
[]
[null,"Prepared By","Osman Goni Ridwan"]
[null,"Reviewed By","Masum Mahdy"]
[null,"Last Update","31/22/2023"]
[null,"Article Link","How to Apply Same Formula to Multiple Cells in Excel"]
[]
[null,"Contents"]
[null,"How to Apply Same Formula to Multiple Cells in Excel"]
[null,"1. Use the Fill Handle Tool (AutoFill Feature)"]
[null,"2. Using Copy-Paste Commands"]
[null,"3.1 Apply Formula to a Range of Cells with Ctrl + Enter"]
[null,"3.2 Apply Formula to Cells of a Column with Ctrl + D"]
[null,"3.3 Apply Formula to Cells Along a Row with Ctrl + R"]
[null,"4. Using Dynamic Arrays to Apply Same Formula to Multiple Cells"]
[null,"5. Convert Data to Excel Table to Apply Same Formula to Entire Column"]
[null,"6. Applying VBA to Apply Same Formula to Multiple Cells"]
[null,"How to Apply Same Formula to Multiple Non-Adjacent Cells in Excel"]
[null,"How to Apply Same Formula to Multiple Cells in Excel Based on Selection"]
[null,"How to Copy a Range of Formulas Without Changing Cell References and Apply"]
[null,"How Can We Change Formulas in Multiple Cells at Once"]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"1. AutoFill","index":1,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"How to Apply Same Formula to Multiple Cells in Excel"]
[]
[null,"Use AutoFill Feature to Copy a Formula to Multiple Cells",null,null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue",null,null,null,null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue"]
[null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"E6*0.1","v":99.9},{"$f":"E6-F6","v":899.1},null,null,null,null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"O6*0.1","v":99.9},{"$f":"O6-P6","v":899.1}]
[null,"ID-22002","Clinton","MacBook Air",1499,{"$f":"E7*0.1","v":149.9},{"$f":"E7-F7","v":1349.1},null,null,null,null,"ID-22002","Clinton","MacBook Air",1499]
[null,"ID-22003","Chester","Dell XPS 13",999,99.9,899.1,null,null,null,null,"ID-22003","Chester","Dell XPS 13",999]
[null,"ID-22004","Rodney","Dell XPS 13",999,99.9,899.1,null,null,null,null,"ID-22004","Rodney","Dell XPS 13",999]
[null,"ID-22006","Pittman","HP  x360",1199,119.9,1079.0999999999999,null,null,null,null,"ID-22006","Pittman","HP  x360",1199]
[null,"ID-22007","Pittman","Dell XPS 13",999,99.9,899.1,null,null,null,null,"ID-22007","Pittman","Dell XPS 13",999]
[null,"ID-22008","Clinton","HP  x360",1199,119.9,1079.0999999999999,null,null,null,null,"ID-22008","Clinton","HP  x360",1199]
[null,"ID-22009","Chester","Asus Zephyrus",1299,129.9,1169.0999999999999,null,null,null,null,"ID-22009","Chester","Asus Zephyrus",1299]
[null,"ID-22010","Pittman","MacBook Air",1599,159.9,1439.1,null,null,null,null,"ID-22010","Pittman","MacBook Air",1599]
[null,"ID-22011","Clinton","MacBook Air",1599,159.9,1439.1,null,null,null,null,"ID-22011","Clinton","MacBook Air",1599]
[null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006,719.1,null,null,null,null,"ID-22012","Chester","Lenovo  X1",799]
[null,"ID-22014","Chester","Dell XPS 13",1199,119.9,1079.0999999999999,null,null,null,null,"ID-22014","Chester","Dell XPS 13",1199]
[null,"ID-22015","Pittman","MacBook Air",1599,159.9,1439.1,null,null,null,null,"ID-22015","Pittman","MacBook Air",1599]
[null,null,null,"Total =",{"$f":"SUM(E6:E18)","v":15987},{"$f":"SUM(F6:F18)","v":1598.7000000000003},14388.300000000003,null,null,null,null,null,null,"Total =",{"$f":"SUM(O6:O18)","v":15987}]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"2. Copy-Paste Command","index":2,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"How to Apply Same Formula to Multiple Cells in Excel"]
[]
[null,"Use of Copy-Paste Command",null,null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue",null,null,null,null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue"]
[null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"E6*0.1","v":99.9},{"$f":"E6-F6","v":899.1},null,null,null,null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"O6*0.1","v":99.9},{"$f":"O6-P6","v":899.1}]
[null,"ID-22002","Clinton","MacBook Air",1499,{"$f":"E7*0.1","v":149.9},{"$f":"E7-F7","v":1349.1},null,null,null,null,"ID-22002","Clinton","MacBook Air",1499]
[null,"ID-22003","Chester","Dell XPS 13",999,99.9,899.1,null,null,null,null,"ID-22003","Chester","Dell XPS 13",999]
[null,"ID-22004","Rodney","Dell XPS 13",999,99.9,899.1,null,null,null,null,"ID-22004","Rodney","Dell XPS 13",999]
[null,"ID-22006","Pittman","HP  x360",1199,119.9,1079.0999999999999,null,null,null,null,"ID-22006","Pittman","HP  x360",1199]
[null,"ID-22007","Pittman","Dell XPS 13",999,99.9,899.1,null,null,null,null,"ID-22007","Pittman","Dell XPS 13",999]
[null,"ID-22008","Clinton","HP  x360",1199,119.9,1079.0999999999999,null,null,null,null,"ID-22008","Clinton","HP  x360",1199]
[null,"ID-22009","Chester","Asus Zephyrus",1299,129.9,1169.0999999999999,null,null,null,null,"ID-22009","Chester","Asus Zephyrus",1299]
[null,"ID-22010","Pittman","MacBook Air",1599,159.9,1439.1,null,null,null,null,"ID-22010","Pittman","MacBook Air",1599]
[null,"ID-22011","Clinton","MacBook Air",1599,159.9,1439.1,null,null,null,null,"ID-22011","Clinton","MacBook Air",1599]
[null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006,719.1,null,null,null,null,"ID-22012","Chester","Lenovo  X1",799]
[null,"ID-22014","Chester","Dell XPS 13",1199,119.9,1079.0999999999999,null,null,null,null,"ID-22014","Chester","Dell XPS 13",1199]
[null,"ID-22015","Pittman","MacBook Air",1599,159.9,1439.1,null,null,null,null,"ID-22015","Pittman","MacBook Air",1599]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"3.1 Ctrl + Enter","index":3,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"How to Apply Same Formula to Multiple Cells "]
[]
[null,"Apply Formula to a Range of Cells with Ctrl + Enter",null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)",null,null,null,null,"Order ID","Seller","Product","Price","Commission (10%)"]
[null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"E6*0.1","v":99.9},null,null,null,null,"ID-22001","Pittman","Dell XPS 13",999]
[null,"ID-22002","Clinton","MacBook Air",1499,149.9,null,null,null,null,"ID-22002","Clinton","MacBook Air",1499]
[null,"ID-22003","Chester","Dell XPS 13",999,99.9,null,null,null,null,"ID-22003","Chester","Dell XPS 13",999]
[null,"ID-22004","Rodney","Dell XPS 13",999,99.9,null,null,null,null,"ID-22004","Rodney","Dell XPS 13",999]
[null,"ID-22006","Pittman","HP  x360",1199,119.9,null,null,null,null,"ID-22006","Pittman","HP  x360",1199]
[null,"ID-22007","Pittman","Dell XPS 13",999,99.9,null,null,null,null,"ID-22007","Pittman","Dell XPS 13",999]
[null,"ID-22008","Clinton","HP  x360",1199,119.9,null,null,null,null,"ID-22008","Clinton","HP  x360",1199]
[null,"ID-22009","Chester","Asus Zephyrus",1299,129.9,null,null,null,null,"ID-22009","Chester","Asus Zephyrus",1299]
[null,"ID-22010","Pittman","MacBook Air",1599,159.9,null,null,null,null,"ID-22010","Pittman","MacBook Air",1599]
[null,"ID-22011","Clinton","MacBook Air",1599,159.9,null,null,null,null,"ID-22011","Clinton","MacBook Air",1599]
[null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006,null,null,null,null,"ID-22012","Chester","Lenovo  X1",799]
[null,"ID-22014","Chester","Dell XPS 13",1199,119.9,null,null,null,null,"ID-22014","Chester","Dell XPS 13",1199]
[null,"ID-22015","Pittman","MacBook Air",1599,159.9,null,null,null,null,"ID-22015","Pittman","MacBook Air",1599]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"3.2 Ctrl + D","index":4,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,"How to Apply Same Formula to Multiple Cells in Excel"]
[]
[null,"Apply Formula to Cells of a Column with Ctrl + D",null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue",null,null,null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue"]
[null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"E6*0.1","v":99.9},{"$f":"E6-F6","v":899.1},null,null,null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"N6*0.1","v":99.9}]
[null,"ID-22002","Clinton","MacBook Air",1499,{"$f":"E7*0.1","v":149.9},{"$f":"E7-F7","v":1349.1},null,null,null,"ID-22002","Clinton","MacBook Air",1499,{"$f":"N7*0.1","v":149.9}]
[null,"ID-22003","Chester","Dell XPS 13",999,{"$f":"E8*0.1","v":99.9},899.1,null,null,null,"ID-22003","Chester","Dell XPS 13",999,{"$f":"N8*0.1","v":99.9}]
[null,"ID-22004","Rodney","Dell XPS 13",999,99.9,899.1,null,null,null,"ID-22004","Rodney","Dell XPS 13",999,99.9]
[null,"ID-22006","Pittman","HP  x360",1199,119.9,1079.0999999999999,null,null,null,"ID-22006","Pittman","HP  x360",1199,119.9]
[null,"ID-22007","Pittman","Dell XPS 13",999,99.9,899.1,null,null,null,"ID-22007","Pittman","Dell XPS 13",999,99.9]
[null,"ID-22008","Clinton","HP  x360",1199,119.9,1079.0999999999999,null,null,null,"ID-22008","Clinton","HP  x360",1199,119.9]
[null,"ID-22009","Chester","Asus Zephyrus",1299,129.9,1169.0999999999999,null,null,null,"ID-22009","Chester","Asus Zephyrus",1299,129.9]
[null,"ID-22010","Pittman","MacBook Air",1599,159.9,1439.1,null,null,null,"ID-22010","Pittman","MacBook Air",1599,159.9]
[null,"ID-22011","Clinton","MacBook Air",1599,159.9,1439.1,null,null,null,"ID-22011","Clinton","MacBook Air",1599,159.9]
[null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006,719.1,null,null,null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006]
[null,"ID-22014","Chester","Dell XPS 13",1199,119.9,1079.0999999999999,null,null,null,"ID-22014","Chester","Dell XPS 13",1199,119.9]
[null,"ID-22015","Pittman","MacBook Air",1599,159.9,1439.1,null,null,null,"ID-22015","Pittman","MacBook Air",1599,159.9]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"3.3 Ctrl + R","index":5,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"How to Apply Same Formula to Multiple Cells in Excel"]
[]
[null,"Apply Formula to Cells Along a Row with Ctrl + R",null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue",null,null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue"]
[null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"E6*0.1","v":99.9},{"$f":"E6-F6","v":899.1},null,null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"M6*0.1","v":99.9},{"$f":"M6-N6","v":899.1}]
[null,"ID-22002","Clinton","MacBook Air",1499,149.9,{"$f":"E7-F7","v":1349.1},null,null,"ID-22002","Clinton","MacBook Air",1499,149.9,{"$f":"M7-N7","v":1349.1}]
[null,"ID-22003","Chester","Dell XPS 13",999,99.9,899.1,null,null,"ID-22003","Chester","Dell XPS 13",999,99.9,899.1]
[null,"ID-22004","Rodney","Dell XPS 13",999,99.9,899.1,null,null,"ID-22004","Rodney","Dell XPS 13",999,99.9,899.1]
[null,"ID-22006","Pittman","HP  x360",1199,119.9,1079.0999999999999,null,null,"ID-22006","Pittman","HP  x360",1199,119.9,1079.0999999999999]
[null,"ID-22007","Pittman","Dell XPS 13",999,99.9,899.1,null,null,"ID-22007","Pittman","Dell XPS 13",999,99.9,899.1]
[null,"ID-22008","Clinton","HP  x360",1199,119.9,1079.0999999999999,null,null,"ID-22008","Clinton","HP  x360",1199,119.9,1079.0999999999999]
[null,"ID-22009","Chester","Asus Zephyrus",1299,129.9,1169.0999999999999,null,null,"ID-22009","Chester","Asus Zephyrus",1299,129.9,1169.0999999999999]
[null,"ID-22010","Pittman","MacBook Air",1599,159.9,1439.1,null,null,"ID-22010","Pittman","MacBook Air",1599,159.9,1439.1]
[null,"ID-22011","Clinton","MacBook Air",1599,159.9,1439.1,null,null,"ID-22011","Clinton","MacBook Air",1599,159.9,1439.1]
[null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006,719.1,null,null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006,719.1]
[null,"ID-22014","Chester","Dell XPS 13",1199,119.9,1079.0999999999999,null,null,"ID-22014","Chester","Dell XPS 13",1199,119.9,1079.0999999999999]
[null,"ID-22015","Pittman","MacBook Air",1599,159.9,1439.1,null,null,"ID-22015","Pittman","MacBook Air",1599,159.9,1439.1]
[null,null,null,"Total =",{"$f":"SUM(E6:E18)","v":15987},{"$f":"SUM(F6:F18)","v":1598.7000000000003},14388.300000000003,null,null,null,null,"Total ="]

{"sheet":"4. Dynamic Arrays","index":6,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"How to Apply Same Formula to Multiple Cells in Excel"]
[]
[null,"Use Dynamic Arrays",null,null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue",null,null,null,null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue"]
[null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"E6:E18*0.1","v":99.9},{"$f":"E6:E18-_xlfn.ANCHORARRAY(F6)","v":899.1},null,null,null,null,"ID-22001","Pittman","Dell XPS 13",999]
[null,"ID-22002","Clinton","MacBook Air",1499,149.9,1349.1,null,null,null,null,"ID-22002","Clinton","MacBook Air",1499]
[null,"ID-22003","Chester","Dell XPS 13",999,99.9,899.1,null,null,null,null,"ID-22003","Chester","Dell XPS 13",999]
[null,"ID-22004","Rodney","Dell XPS 13",999,99.9,899.1,null,null,null,null,"ID-22004","Rodney","Dell XPS 13",999]
[null,"ID-22006","Pittman","HP  x360",1199,119.9,1079.0999999999999,null,null,null,null,"ID-22006","Pittman","HP  x360",1199]
[null,"ID-22007","Pittman","Dell XPS 13",999,99.9,899.1,null,null,null,null,"ID-22007","Pittman","Dell XPS 13",999]
[null,"ID-22008","Clinton","HP  x360",1199,119.9,1079.0999999999999,null,null,null,null,"ID-22008","Clinton","HP  x360",1199]
[null,"ID-22009","Chester","Asus Zephyrus",1299,129.9,1169.0999999999999,null,null,null,null,"ID-22009","Chester","Asus Zephyrus",1299]
[null,"ID-22010","Pittman","MacBook Air",1599,159.9,1439.1,null,null,null,null,"ID-22010","Pittman","MacBook Air",1599]
[null,"ID-22011","Clinton","MacBook Air",1599,159.9,1439.1,null,null,null,null,"ID-22011","Clinton","MacBook Air",1599]
[null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006,719.1,null,null,null,null,"ID-22012","Chester","Lenovo  X1",799]
[null,"ID-22014","Chester","Dell XPS 13",1199,119.9,1079.0999999999999,null,null,null,null,"ID-22014","Chester","Dell XPS 13",1199]
[null,"ID-22015","Pittman","MacBook Air",1599,159.9,1439.1,null,null,null,null,"ID-22015","Pittman","MacBook Air",1599]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"5. Convert into table","index":7,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"How to Apply Same Formula to Multiple Cells in Excel"]
[]
[null,"Convert Data to Excel Table to Apply Same Formula to Entire Column",null,null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue",null,null,null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue"]
[null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"E6*0.1","v":99.9},{"$f":"E6-F6","v":899.1},null,null,null,"ID-22001","Pittman","Dell XPS 13",999]
[null,"ID-22002","Clinton","MacBook Air",1499,149.9,1349.1,null,null,null,"ID-22002","Clinton","MacBook Air",1499]
[null,"ID-22003","Chester","Dell XPS 13",999,99.9,899.1,null,null,null,"ID-22003","Chester","Dell XPS 13",999]
[null,"ID-22004","Rodney","Dell XPS 13",999,99.9,899.1,null,null,null,"ID-22004","Rodney","Dell XPS 13",999]
[null,"ID-22006","Pittman","HP  x360",1199,119.9,1079.0999999999999,null,null,null,"ID-22006","Pittman","HP  x360",1199]
[null,"ID-22007","Pittman","Dell XPS 13",999,99.9,899.1,null,null,null,"ID-22007","Pittman","Dell XPS 13",999]
[null,"ID-22008","Clinton","HP  x360",1199,119.9,1079.0999999999999,null,null,null,"ID-22008","Clinton","HP  x360",1199]
[null,"ID-22009","Chester","Asus Zephyrus",1299,129.9,1169.0999999999999,null,null,null,"ID-22009","Chester","Asus Zephyrus",1299]
[null,"ID-22010","Pittman","MacBook Air",1599,159.9,1439.1,null,null,null,"ID-22010","Pittman","MacBook Air",1599]
[null,"ID-22011","Clinton","MacBook Air",1599,159.9,1439.1,null,null,null,"ID-22011","Clinton","MacBook Air",1599]
[null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006,719.1,null,null,null,"ID-22012","Chester","Lenovo  X1",799]
[null,"ID-22014","Chester","Dell XPS 13",1199,119.9,1079.0999999999999,null,null,null,"ID-22014","Chester","Dell XPS 13",1199]
[null,"ID-22015","Pittman","MacBook Air",1599,159.9,1439.1,null,null,null,"ID-22015","Pittman","MacBook Air",1599]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,Table1[Price])","v":15987},{"$f":"SUBTOTAL(109,Table1[Commission (10%)])","v":1598.7000000000003},{"$f":"SUBTOTAL(109,Table1[Gross Revenue])","v":14388.300000000003}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"6. VBA","index":8,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"How to Apply Same Formula to Multiple Cells in Excel"]
[]
[null,"Use Excel VBA",null,null,null,null,null,null,null,"Try Yourself!"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue",null,null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue"]
[null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"E6*0.1","v":99.9},{"$f":"E6-F6","v":899.1},null,null,"ID-22001","Pittman","Dell XPS 13",999]
[null,"ID-22002","Clinton","MacBook Air",1499,149.9,1349.1,null,null,"ID-22002","Clinton","MacBook Air",1499]
[null,"ID-22003","Chester","Dell XPS 13",999,99.9,899.1,null,null,"ID-22003","Chester","Dell XPS 13",999]
[null,"ID-22004","Rodney","Dell XPS 13",999,99.9,899.1,null,null,"ID-22004","Rodney","Dell XPS 13",999]
[null,"ID-22006","Pittman","HP  x360",1199,119.9,1079.0999999999999,null,null,"ID-22006","Pittman","HP  x360",1199]
[null,"ID-22007","Pittman","Dell XPS 13",999,99.9,899.1,null,null,"ID-22007","Pittman","Dell XPS 13",999]
[null,"ID-22008","Clinton","HP  x360",1199,119.9,1079.0999999999999,null,null,"ID-22008","Clinton","HP  x360",1199]
[null,"ID-22009","Chester","Asus Zephyrus",1299,129.9,1169.0999999999999,null,null,"ID-22009","Chester","Asus Zephyrus",1299]
[null,"ID-22010","Pittman","MacBook Air",1599,159.9,1439.1,null,null,"ID-22010","Pittman","MacBook Air",1599]
[null,"ID-22011","Clinton","MacBook Air",1599,159.9,1439.1,null,null,"ID-22011","Clinton","MacBook Air",1599]
[null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006,719.1,null,null,"ID-22012","Chester","Lenovo  X1",799]
[null,"ID-22014","Chester","Dell XPS 13",1199,119.9,1079.0999999999999,null,null,"ID-22014","Chester","Dell XPS 13",1199]
[null,"ID-22015","Pittman","MacBook Air",1599,159.9,1439.1,null,null,"ID-22015","Pittman","MacBook Air",1599]
[null,"Back to Home Page"]

{"sheet":" Without Changing Cell Ref","index":9,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"How to Copy a Range of Formulas Without Changing Cell References"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue",null,"Commission (10%)","Gross Revenue"]
[null,"ID-22001","Pittman","Dell XPS 13",1010,{"$f":"E4*0.1","v":101},{"$f":"E4-F4","v":909},null,{"$f":"E4*0.1","v":101},{"$f":"E4-F4","v":909}]
[null,"ID-22002","Clinton","MacBook Air",1499,{"$f":"E4*0.1","v":101},{"$f":"E5-F5","v":1398},null,{"$f":"E4*0.1","v":101},1398]
[null,"ID-22003","Chester","Dell XPS 13",999,{"$f":"E5*0.1","v":149.9},849.1,null,{"$f":"E5*0.1","v":149.9},849.1]
[null,"ID-22004","Rodney","Dell XPS 14",999,{"$f":"E6*0.1","v":99.9},899.1,null,{"$f":"E6*0.1","v":99.9},899.1]
[null,"ID-22006","Pittman","HP  x360",1199,{"$f":"E6*0.1","v":99.9},1099.0999999999999,null,{"$f":"E6*0.1","v":99.9},1099.0999999999999]
[null,"ID-22007","Pittman","Dell XPS 13",999,{"$f":"E7*0.1","v":99.9},899.1,null,{"$f":"E7*0.1","v":99.9},899.1]
[null,"ID-22008","Clinton","HP  x360",1199,119.9,1079.0999999999999,null,{"$f":"E8*0.1","v":119.9},1079.0999999999999]
[null,"ID-22009","Chester","Asus Zephyrus",1299,99.9,1199.0999999999999,null,{"$f":"E9*0.1","v":99.9},1199.0999999999999]
[null,"ID-22010","Pittman","MacBook Air",1599,119.9,1479.1,null,{"$f":"E10*0.1","v":119.9},1479.1]
[null,"ID-22011","Clinton","MacBook Air",1599,{"$f":"E9*0.1","v":99.9},1499.1,null,{"$f":"E9*0.1","v":99.9},1499.1]
[null,"ID-22012","Chester","Lenovo  X1",799,{"$f":"E10*0.1","v":119.9},679.1,null,{"$f":"E10*0.1","v":119.9},679.1]
[null,"ID-22014","Chester","Dell XPS 13",1199,{"$f":"E11*0.1","v":129.9},1069.0999999999999,null,{"$f":"E11*0.1","v":129.9},1069.0999999999999]
[null,"ID-22015","Pittman","MacBook Air",1599,{"$f":"E12*0.1","v":159.9},1439.1,null,{"$f":"E12*0.1","v":159.9},1439.1]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Change Formulas Multiple Cells","index":10,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"How to Change Formulas in Multiple Cells at Once"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue"]
[null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"E4*0.5","v":499.5},{"$f":"E4-F4","v":499.5}]
[null,"ID-22002","Clinton","MacBook Air",1499,{"$f":"E4*0.5","v":499.5},{"$f":"E5-F5","v":999.5}]
[null,"ID-22003","Chester","Dell XPS 13",999,{"$f":"E5*0.5","v":749.5},249.5]
[null,"ID-22004","Rodney","Dell XPS 14",999,{"$f":"E6*0.5","v":499.5},499.5]
[null,"ID-22006","Pittman","HP  x360",1199,{"$f":"E6*0.5","v":499.5},699.5]
[null,"ID-22007","Pittman","Dell XPS 13",999,{"$f":"E7*0.5","v":499.5},499.5]
[null,"ID-22008","Clinton","HP  x360",1199,{"$f":"E8*0.5","v":599.5},599.5]
[null,"ID-22009","Chester","Asus Zephyrus",1299,{"$f":"E9*0.5","v":499.5},799.5]
[null,"ID-22010","Pittman","MacBook Air",1599,{"$f":"E10*0.5","v":599.5},999.5]
[null,"ID-22011","Clinton","MacBook Air",1599,{"$f":"E9*0.5","v":499.5},1099.5]
[null,"ID-22012","Chester","Lenovo  X1",799,{"$f":"E10*0.5","v":599.5},199.5]
[null,"ID-22014","Chester","Dell XPS 13",1199,{"$f":"E11*0.5","v":649.5},549.5]
[null,"ID-22015","Pittman","MacBook Air",1599,{"$f":"E12*0.5","v":799.5},799.5]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Blank Cell","index":11,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"How to Apply Same Formula to Multiple Cells in Excel Based on Selection"]
[]
[null,"Order ID","Seller","Product","Price","Commission (10%)","Gross Revenue"]
[null,"ID-22001","Pittman","Dell XPS 13",999,{"$f":"E4*0.1","v":99.9},{"$f":"E4-F4","v":899.1}]
[null,"ID-22002","Clinton","MacBook Air",1499,{"$f":"E5*0.1","v":149.9},{"$f":"E5-F5","v":1349.1}]
[null,"ID-22003","Chester","Dell XPS 13",999,99.9,899.1]
[null,"ID-22004","Rodney",{"$f":"D6","v":"Dell XPS 13"},999,99.9,899.1]
[null,"ID-22006","Pittman","HP  x360",1199,119.9,1079.0999999999999]
[null,"ID-22007",{"$f":"C8","v":"Pittman"},"Dell XPS 13",999,99.9,899.1]
[null,"ID-22008","Clinton","HP  x360",1199,119.9,1079.0999999999999]
[null,"ID-22009","Chester","Asus Zephyrus",1299,129.9,1169.0999999999999]
[null,"ID-22010","Pittman","MacBook Air",1599,159.9,1439.1]
[null,"ID-22011","Clinton",{"$f":"D12","v":"MacBook Air"},1599,159.9,1439.1]
[null,"ID-22012","Chester","Lenovo  X1",799,79.900000000000006,719.1]
[null,"ID-22014",{"$f":"C14","v":"Chester"},"Dell XPS 13",1199,119.9,1079.0999999999999]
[null,"ID-22015","Pittman","MacBook Air",1599,159.9,1439.1]
[null,null,null,"Total =",{"$f":"SUM(E4:E16)","v":15987},{"$f":"SUM(F4:F16)","v":1598.7000000000003},{"$f":"SUM(G4:G16)","v":14388.300000000003}]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"Non-Adjacent Cells","index":12,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,"How to Apply Same Formula to Multiple Non-Adjacent Cells in Excel"]
[]
[null,"List 1",null,"List 2",null,"List 3"]
[null,71,null,79,null,85]
[null,97,null,41,null,82]
[null,65,null,65,null,53]
[null,76,null,12,null,15]
[null,81,null,61,null,60]
[null,59,null,24,null,100]
[null,95,null,56,null,28]
[null,68,null,98,null,57]
[null,92,null,59,null,32]
[null,21,null,89,null,74]
[null,20,null,26,null,34]
[null,66,null,70,null,79]
[null,{"$f":"SUM(B4:B15)","v":811},null,{"$f":"SUM(D4:D15)","v":680},null,{"$f":"SUM(F4:F15)","v":699}]
[]
[]
[]
[null,"Back to Home Page"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"SUM(1,2,3)","v":6}]
[null,null,null,{"$f":"SUM(1,2,3)","v":6}]
[]
[null,null,{"$f":"SUM(1,2,3)","v":6}]
[]
[null,null,null,{"$f":"SUM(1,2,3)","v":6}]