{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Macros to select cells","Sample data","Sample data2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":3,"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":"Macros to select cells","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,1,3,2],[7,2,7,3]]}
[]
[]
[]
[null,"VBA Macros to Select Cells in Excel"]
[]
[null,"Author","Ablebits.com"]
[null,"Last update","2023-06-09"]
[null,"Tutorial URL","How to select multiple cells in Excel"]
[]
[null,"The workbook contains the following macros:"]
[null,"SelectCurrentRegion - selects the current range based on the active cell."]
[null,"SelectCellsWithValues - selects all the cells containing values (constants) in the active sheet, ignoring formulas and empty cells."]
[null,"SelectCellsWithData - selects all cells with data on a sheet, including both cells with values (constants) and cells with formulas."]
[]
[null,"How to use the macros:"]
[null,"1. Keep this workbook open."]
[null,"2. Open your own workbook in which you want to select cells."]
[null,"3. In your workbook, press Alt + F8, select the desired macro, and click Run."]

{"sheet":"Sample data","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Sample data to select cells in Excel"]
["Item","Jan","Feb","Mar"]
["Apples",374,397,460]
["Banana",256,512,515]
["Cherries",317,null,328]
["Coconut",273,241,232]
["Dates",255,307,561]
["Fig",340,222,592]
["Grapes",420,289,529]
["Kiwi",null,330]
["Lemon",317,262,491]
["Lime",260,263,500]
["Mango",525,553,568]
["Melon",581,252,530]
["Orange",414,224]
["Papaya",205,359,254]
["Peach",445,285,212]
["Pear",258,220,372]
["Plum",448,217,360]
["Prunes",408,280,267]
["Total",{"$f":"SUM(B3:B20)","v":6096},{"$f":"SUM(C3:C20)","v":5213},6771]

{"sheet":"Sample data2","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[11,0,11,3]]}
["Sample data to select cells in Excel"]
[2021]
["Item","Jan","Feb","Mar"]
["Apples",374,397,460]
["Banana",256,512,515]
["Cherries",null,596]
["Coconut",273,241,232]
["Prunes",408,280,267]
["Total",{"$f":"SUM(B4:B8)","v":1311},{"$f":"SUM(C4:C8)","v":2026},1474]
[]
[]
[2022]
["Item","Jan","Feb","Mar"]
["Apples",374,397,460]
["Banana",256,512,515]
["Cherries",317,596,328]
["Coconut",null,241]
["Prunes",408,280,267]
["Total",{"$f":"SUM(B14:B18)","v":1355},{"$f":"SUM(C14:C18)","v":2026},{"$f":"SUM(D14:D18)","v":1570}]