{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["horizontal_align","vertical_align","text_control","reading order","font_style","font_size","underline","font_color","font_name","font_effects"],"not_rendered":{"charts":0,"images":0,"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":"horizontal_align","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Format Text Horizontally Using Excel VBA"]
[]
[null,"Text ","Formatted Text","Property","CODE"]
[null,"New York","New York","xlGeneral","Range(\"C5\").HorizontalAlignment = xlGeneral"]
[null,"Los Angeles","Los Angeles","xlCenter","Range(\"C6\").HorizontalAlignment = xlCenter"]
[null,"Chicago - third largest city in the USA","Chicago - third largest city in the USA","xlDistributed","Range(\"C7\").HorizontalAlignment = xlDistributed"]
[null,"Houston- fourth largest city in the USA.  It is a great place to live on.","Houston- fourth largest city in the USA.  It is a great place to live on.","xlJustify","Range(\"C8\").HorizontalAlignment = xlJustify"]
[null,"Phoenix","Phoenix","xlLeft","Range(\"C9\").HorizontalAlignment = xlLeft"]
[null,"Philadelphia","Philadelphia","xlRight","Range(\"C10\").HorizontalAlignment = xlRight"]

{"sheet":"vertical_align","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Format Text Vertically Using Excel VBA"]
[]
[null,"Text ","Formatted Text","Property","CODE"]
[null,"New York","New York","xlBottom","Range(\"C5\").VerticalAlignment = xlBottom"]
[null,"Los Angeles","Los Angeles","xlCenter","Range(\"C6\").VerticalAlignment = xlCenter"]
[null,"Chicago - third largest city in the USA","Chicago - third largest city in the USA. It is a nice place to live in.","xlDistributed","Range(\"C7\").VerticalAlignment = xlDistributed"]
[null,"Houston- fourth largest city in the USA.  It is a great place to live in.","Houston- fourth largest city in the USA.  It is a great place to live in.","xlJustify","Range(\"C8\").VerticalAlignment = xlJustify"]
[null,"Phoenix","Phoenix","xlTop","Range(\"C9\").VerticalAlignment = xlTop"]

{"sheet":"text_control","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Text Control Formatting Using Excel VBA"]
[]
[null,"Text ","Formatted Text","Property"]
[null,"Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500","Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500","WrapText"]
[null,"Lorem Ipsum is simply dummy text of the printing and ","Lorem Ipsum is simply dummy text of the printing and ","Shrink to Fit"]

{"sheet":"reading order","index":3,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Text Orientation Format Change Using Excel VBA"]
[]
[null,"Text ","Formatted Text","Property","CODE"]
[null,"New York","New York","xlHorizaontal","Range(\"C5\").HorizontalAlignment = xlGeneral"]
[null,"Los Angeles","Los Angeles","xlVertical","Range(\"C6\").HorizontalAlignment = xlCenter"]
[null,"Chicago","Chicago","xlDownward"]
[null,"Houston","Houston","xlUpward"]

{"sheet":"font_style","index":4,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Change Font Styles Using Excel VBA"]
[]
[null,"Text ","Formatted Text","Property","CODE"]
[null,"New York","New York","Italic ","Range(\"C5\").HorizontalAlignment = xlGeneral"]
[null,"Los Angeles","Los Angeles","Bold","Range(\"C6\").HorizontalAlignment = xlCenter"]
[null,"Chicago","Chicago","Regular"]
[null,"Houston","Houston","Bold Italic",null," "]

{"sheet":"font_size","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Change Font Sizes Using Excel VBA"]
[]
[null,"Text ","Formatted Text","Property","CODE"]
[null,"New York","New York","size=10","Range(\"C5\").HorizontalAlignment = xlGeneral"]
[null,"Los Angeles","Los Angeles","size=12","Range(\"C6\").HorizontalAlignment = xlCenter"]
[null,"Chicago","Chicago","size=14"]
[null,"Houston","Houston","size=16",null," "]
[null,"California ","California ","size=18"]

{"sheet":"underline","index":6,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Underline Texts Using Excel VBA"]
[]
[null,"Text ","Formatted Text","Property","CODE"]
[null,"New York","New York","xlUnderlineStyleNone","Range(\"C5\").HorizontalAlignment = xlGeneral"]
[null,"Los Angeles","Los Angeles","xlUnderlineStyleSingle","Range(\"C6\").HorizontalAlignment = xlCenter"]
[null,"Chicago","Chicago","xlUnderlineStyleDouble"]
[null,"Houston","Houston","xlUnderlineStyleSingleAccounting",null," "]
[null,"California ","California ","xlUnderlineStyleDoubleAccounting"]

{"sheet":"font_color","index":7,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Change Text Colors Using Excel VBA"]
[]
[null,"Text ","Formatted Text","Property","CODE"]
[null,"New York","New York","vbRed","Range(\"C5\").HorizontalAlignment = xlGeneral"]
[null,"Los Angeles","Los Angeles","vbGreen","Range(\"C6\").HorizontalAlignment = xlCenter"]
[null,"Chicago","Chicago","vbYellow"]
[null,"Houston","Houston","RGB(0, 255, 255)",null," "]
[null,"California ","California ","RGB(255, 255, 255)"]

{"sheet":"font_name","index":8,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Change Font Names Using Excel VBA"]
[]
[null,"Text ","Formatted Text","Property","CODE"]
[null,"New York","New York","Arial","Range(\"C5\").HorizontalAlignment = xlGeneral"]
[null,"Los Angeles","Los Angeles","Calibri","Range(\"C6\").HorizontalAlignment = xlCenter"]
[null,"Chicago","Chicago","New Times Roman"]
[null,"Houston","Houston","Arial Black",null," "]
[null,"California ","California ","Atma"]

{"sheet":"font_effects","index":9,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Text Font Effects Using Excel VBA"]
[]
[null,"Text ","Formatted Text","Property","CODE"]
[null,"New York","New York","Font.Strikethrough","Range(\"C5\").HorizontalAlignment = xlGeneral"]
[null,"Los Angeles","Los Angeles","Font.Subscript","Range(\"C6\").HorizontalAlignment = xlCenter"]
[null,"Chicago","Chicago","Font.Superscript"]