{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["(hidden)list of Names","Settings","Custom Shortcuts","(hidden) Win & Mac Shortcuts","Link Format Exceptions","Capitalised Word Exceptions","Languages"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":49,"comments":2,"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":"(hidden)list of Names","index":0,"n_rows":114,"n_cols":10,"rows_kept":114,"cut":false,"hidden":true,"merged":[]}
["2022-04-07T10:15:21","Name","RefersTo","Visible","Value","20/04/2022  v022 unused names greyed out, to be deleted","Name","RefersTo","Visible","Value"]
[null,"'Custom Shortcuts'!_FilterDatabase","='Custom Shortcuts'!$B$14:$AZJ$105",false,"Array(1 to 92,1 to 1361)","","'Custom Shortcuts'!_FilterDatabase","='Custom Shortcuts'!$B$14:$AZJ$104",false,"Array(1 to 91,1 to 1361)"]
[null,"_xlfn.XLOOKUP","=#NAME?",false,"=#NAME?","","_xlfn.XLOOKUP",null,false,"=#NAME?"]
[null,"AutoFormatting","=Misc!$D$7",true,true,"","AutoFormatting","=Settings!$B$7",true,true]
[null,"bMacrosRun","=Misc!$D$6",true,true,"","bMacrosRun","=Settings!$B$6",true,true]
[null,"bRebindKeysOnFirstInvoke","=Misc!$D$5",true,true,"","bTestMode","=Settings!$B$3",true,false]
[null,"bTestMode","=Misc!$D$3",true,false,"","CASmodifiers","=Settings!$B$29:$B$32",true,"Array(1 to 4,1 to 1)"]
[null,"CASmodifiers","=Misc!$F$3:$F$6",true,"Array(1 to 4,1 to 1)","","cf_AddChangeLog","='Custom Shortcuts'!$G$25",true,1]
[null,"cf_AddChangeLog","='Custom Shortcuts'!$G$25",true,1,"","cf_AddSparkline","='Custom Shortcuts'!$G$32",true,"S"]
[null,"cf_AddSparkline","='Custom Shortcuts'!$G$33",true,"S","","cf_Anchoring","='Custom Shortcuts'!$G$21",true,"A"]
[null,"cf_Anchoring","='Custom Shortcuts'!$G$21",true,"A","","cf_Black","='Custom Shortcuts'!$G$59",true,"B"]
[null,"cf_Black","='Custom Shortcuts'!$G$60",true,"B","","cf_Border","='Custom Shortcuts'!$G$62",true,"D"]
[null,"cf_Border","='Custom Shortcuts'!$G$63",true,"D","","cf_Brackets","='Custom Shortcuts'!$G$63",true,"T"]
[null,"cf_Brackets","='Custom Shortcuts'!$G$64",true,"T","","cf_ChangeColours","='Custom Shortcuts'!#REF!",true,"='Custom Shortcuts'!#REF!"]
[null,"cf_ChangeColours","='Custom Shortcuts'!$G$28",true,4,"","cf_ClearFill","='Custom Shortcuts'!$G$48",true,"C"]
[null,"cf_ClearFill","='Custom Shortcuts'!$G$49",true,"C","","cf_CollapseGroup","='Custom Shortcuts'!$G$70",true,"E"]
[null,"cf_CollapseGroup","='Custom Shortcuts'!$G$71",true,"E","","cf_CopyAcross","='Custom Shortcuts'!$G$16",true,"A"]
[null,"cf_CopyAcross","='Custom Shortcuts'!$G$16",true,"A","","cf_CounterflowFill","='Custom Shortcuts'!$G$52",true,"O"]
[null,"cf_CounterflowFill","='Custom Shortcuts'!$G$53",true,"O","","cf_CreateOutputTrack","='Custom Shortcuts'!$G$28",true,5]
[null,"cf_CreateOutputTrack","='Custom Shortcuts'!$G$29",true,5,"","cf_DateStyle","='Custom Shortcuts'!$G$43",true,"L"]
[null,"cf_DateStyle","='Custom Shortcuts'!$G$44",true,"L","","cf_DecreaseZero","='Custom Shortcuts'!$G$39",true,","]
[null,"cf_DecreaseZero","='Custom Shortcuts'!$G$40",true,",","","cf_DeleteCondFormat","='Custom Shortcuts'!$G$34",true,8]
[null,"cf_DeleteCondFormat","='Custom Shortcuts'!$G$35",true,8,"","cf_DeleteSheet","='Custom Shortcuts'!$G$30",true,"-"]
[null,"cf_DeleteSheet","='Custom Shortcuts'!$G$31",true,"-","","cf_Exceptions","='Custom Shortcuts'!$G$74",true,"E"]
[null,"cf_Exceptions","='Custom Shortcuts'!$G$75",true,"E","","cf_ExpandGroup","='Custom Shortcuts'!$G$69",true,"E"]
[null,"cf_ExpandGroup","='Custom Shortcuts'!$G$70",true,"E","","cf_Export","='Custom Shortcuts'!$G$61",true,"X"]
[null,"cf_Export","='Custom Shortcuts'!$G$62",true,"X","","cf_FactorStyle","='Custom Shortcuts'!$G$41",true,"."]
[null,"cf_FactorStyle","='Custom Shortcuts'!$G$42",true,".","","cf_GreenFill","='Custom Shortcuts'!$G$50",true,"G"]
[null,"cf_GreenFill","='Custom Shortcuts'!$G$51",true,"G","","cf_Hide","='Custom Shortcuts'!$G$29",true,7]
[null,"cf_Hide","='Custom Shortcuts'!$G$30",true,7,"","cf_Import","='Custom Shortcuts'!$G$60",true,"M"]
[null,"cf_Import","='Custom Shortcuts'!$G$61",true,"M","","cf_IncreaseZero","='Custom Shortcuts'!$G$38",true,"."]
[null,"cf_IncreaseZero","='Custom Shortcuts'!$G$39",true,".","","cf_InputFill","='Custom Shortcuts'!$G$51",true,"I"]
[null,"cf_InputFill","='Custom Shortcuts'!$G$52",true,"I","","cf_JumpFrom","='Custom Shortcuts'!$G$68",true,"K"]
[null,"cf_JumpFrom","='Custom Shortcuts'!$G$69",true,"K","","cf_JumpTo","='Custom Shortcuts'!$G$67",true,"J"]
[null,"cf_JumpTo","='Custom Shortcuts'!$G$68",true,"J","","cf_LimeFill","='Custom Shortcuts'!$G$53",true,"R"]
[null,"cf_LimeFill","='Custom Shortcuts'!$G$54",true,"R","","cf_MacroFill","='Custom Shortcuts'!$G$54",true,"V"]
[null,"cf_MacroFill","='Custom Shortcuts'!$G$55",true,"V","","cf_NormalStyle","='Custom Shortcuts'!$G$40",true,","]
[null,"cf_NormalStyle","='Custom Shortcuts'!$G$41",true,",","","cf_PasteData","='Custom Shortcuts'!$G$22",true,"D"]
[null,"cf_PasteData","='Custom Shortcuts'!$G$22",true,"D","","cf_PasteDate","='Custom Shortcuts'!$G$22",true,"D"]
[null,"cf_PasteDate","='Custom Shortcuts'!$G$22",true,"D","","cf_PasteFormats","='Custom Shortcuts'!$G$23",true,"S"]
[null,"cf_PasteFormats","='Custom Shortcuts'!$G$23",true,"S","","cf_PercentStyle","='Custom Shortcuts'!$G$42",true,"P"]
[null,"cf_PercentStyle","='Custom Shortcuts'!$G$43",true,"P","","cf_PlaceHolderFill","='Custom Shortcuts'!$G$49",true,"Y"]
[null,"cf_PlaceHolderFill","='Custom Shortcuts'!$G$50",true,"Y","","cf_Placeholders","='Custom Shortcuts'!$G$20",true,"P"]
[null,"cf_Placeholders","='Custom Shortcuts'!$G$20",true,"P","","cf_PowerBI","='Custom Shortcuts'!$G$55",true,"W"]
[null,"cf_PowerBI","='Custom Shortcuts'!$G$56",true,"W","","cf_PrepareForRelease","='Custom Shortcuts'!$G$75",true,6]
[null,"cf_PrepareForRelease","='Custom Shortcuts'!$G$76",true,6,"","cf_PrepareForRelease01","='Custom Shortcuts'!$G$77",true,"Q"]
[null,"cf_PrepareForRelease01","='Custom Shortcuts'!$G$78",true,"Q","","cf_PrepareForRelease02","='Custom Shortcuts'!$G$78",true,"W"]
[null,"cf_PrepareForRelease02","='Custom Shortcuts'!$G$79",true,"W","","cf_PrepareForRelease03","='Custom Shortcuts'!$G$79",true,"T"]
[null,"cf_PrepareForRelease03","='Custom Shortcuts'!$G$80",true,"T","","cf_PrepareForRelease04","='Custom Shortcuts'!$G$80",true,"B"]
[null,"cf_PrepareForRelease04","='Custom Shortcuts'!$G$81",true,"B","","cf_PrepareForRelease05","='Custom Shortcuts'!$G$83",true,1]
[null,"cf_PrepareForRelease05","='Custom Shortcuts'!$G$84",true,1,"","cf_PrepareForRelease06","='Custom Shortcuts'!$G$84",true,2]
[null,"cf_PrepareForRelease06","='Custom Shortcuts'!$G$85",true,2,"","cf_PrepareForRelease07","='Custom Shortcuts'!$G$85",true,3]
[null,"cf_PrepareForRelease07","='Custom Shortcuts'!$G$86",true,3,"","cf_PrepareForRelease08","='Custom Shortcuts'!$G$86",true,4]
[null,"cf_PrepareForRelease08","='Custom Shortcuts'!$G$87",true,4,"","cf_PrepareForRelease09","='Custom Shortcuts'!$G$87",true,5]
[null,"cf_PrepareForRelease09","='Custom Shortcuts'!$G$88",true,5,"","cf_PrepareForRelease10","='Custom Shortcuts'!$G$88",true,6]
[null,"cf_PrepareForRelease10","='Custom Shortcuts'!$G$89",true,6,"","cf_PrepareForRelease11","='Custom Shortcuts'!$G$89",true,7]
[null,"cf_PrepareForRelease11","='Custom Shortcuts'!$G$90",true,7,"","cf_PrepareForRelease12","='Custom Shortcuts'!$G$90",true,8]
[null,"cf_PrepareForRelease12","='Custom Shortcuts'!$G$91",true,8,"","cf_PrepareForRelease13","='Custom Shortcuts'!$G$94",true,"L"]
[null,"cf_PrepareForRelease13","='Custom Shortcuts'!$G$95",true,"L","","cf_PrepareForRelease14","='Custom Shortcuts'!$G$95",true,"U"]
[null,"cf_PrepareForRelease14","='Custom Shortcuts'!$G$96",true,"U","","cf_PrepareForRelease15","='Custom Shortcuts'!$G$96",true,"C"]
[null,"cf_PrepareForRelease15","='Custom Shortcuts'!$G$97",true,"C","","cf_PrepareForRelease16","='Custom Shortcuts'!$G$97",true,"R"]
[null,"cf_PrepareForRelease16","='Custom Shortcuts'!$G$98",true,"R","","cf_PrepareForRelease17","='Custom Shortcuts'!$G$98",true,"F"]
[null,"cf_PrepareForRelease17","='Custom Shortcuts'!$G$99",true,"F","","cf_PrepareForRelease18","='Custom Shortcuts'!$G$99",true,"M"]
[null,"cf_PrepareForRelease18","='Custom Shortcuts'!$G$100",true,"M","","cf_PrepareForRelease19","='Custom Shortcuts'!$G$101",true,"S"]
[null,"cf_PrepareForRelease19","='Custom Shortcuts'!$G$102",true,"S","","cf_PrepareForRelease20","='Custom Shortcuts'!$G$100",true,"D"]
[null,"cf_PrepareForRelease20","='Custom Shortcuts'!$G$101",true,"D","","cf_Queries","='Custom Shortcuts'!$G$24",true,"Q"]
[null,"cf_Queries","='Custom Shortcuts'!$G$24",true,"Q","","cf_QuickLink","='Custom Shortcuts'!$G$15",true,"Q"]
[null,"cf_QuickLink","='Custom Shortcuts'!$G$15",true,"Q","","cf_RelocateInputs","='Custom Shortcuts'!$G$18",true,"R"]
[null,"cf_RelocateInputs","='Custom Shortcuts'!$G$18",true,"R","","cf_RelocateOutputs","='Custom Shortcuts'!$G$19",true,"O"]
[null,"cf_RelocateOutputs","='Custom Shortcuts'!$G$19",true,"O","","cf_ResetEnd","='Custom Shortcuts'!$G$31",true,"C"]
[null,"cf_ResetEnd","='Custom Shortcuts'!$G$32",true,"C","","cf_SaveChangeLog","='Custom Shortcuts'!$G$26",true,2]
[null,"cf_SaveChangeLog","='Custom Shortcuts'!$G$26",true,2,"","cf_SumAcross","='Custom Shortcuts'!$G$17",true,"N"]
[null,"cf_SumAcross","='Custom Shortcuts'!$G$17",true,"N","","cf_VarReport","='Custom Shortcuts'!$G$27",true,9]
[null,"cf_VarReport","='Custom Shortcuts'!$G$27",true,9,"","COL_INP","=Settings!$C$38",true,"F"]
[null,"COL_INP","=Settings!$C$4",true,"F","","ConstantColumn","=Settings!$B$38",true,6]
[null,"ConstantColumn","=Settings!$B$4",true,6,"","Custom_Shortcuts_Table","='Custom Shortcuts'!$A$14:$G$75",true,"Array(1 to 62,1 to 7)"]
[null,"Custom_Shortcuts_Table","='Custom Shortcuts'!$A$14:$G$76",true,"Array(1 to 63,1 to 7)","New","Excel_Shortcuts","='Win & Mac Shortcuts table'!$A$1:$F$244",true,"Array(1 to 244,1 to 6)"]
[null,"Font_Name","=Custom_Theme!$B$17",true,"Financial_Model","","keybindchk","='Custom Shortcuts'!$H$11",true,0]
[null,"keybindchk","='Custom Shortcuts'!$H$11",true,0,"","LABEL_INP","=Settings!$C$36",true,"E"]
[null,"LABEL_INP","=Settings!$C$2",true,"E","","LabelColumn","=Settings!$B$36",true,5]
[null,"LabelColumn","=Settings!$B$2",true,5,"","lstCapitalisationExceptions","='Capitalised Word Exceptions'!$A$2:$A$77",true,"Array(1 to 76,1 to 1)"]
[null,"lstCapitalisationExceptions","='Capitalised Word Exceptions'!$A$2:$A$77",true,"Array(1 to 76,1 to 1)","","lstCommands","='Custom Shortcuts'!$G$15:$G$75",true,"Array(1 to 61,1 to 1)"]
[null,"lstCommands","='Custom Shortcuts'!$G$15:$G$76",true,"Array(1 to 62,1 to 1)","","lstSheetsIgnore","='Link Format Exceptions'!$A$2:$A$37",true,"Array(1 to 36,1 to 1)"]
[null,"lstSheetsIgnore","='Link Format Exceptions'!$A$2:$A$37",true,"Array(1 to 36,1 to 1)","","MacModifierKey","='Custom Shortcuts'!$E$13",true,"Option + Shift +"]
[null,"MacModifierKey","='Custom Shortcuts'!$E$13",true,"Option","New","MacOS","='Custom Shortcuts'!$E$12",true,false]
[null,"Modifiers","=Misc!$F$3:$F$5",true,"Array(1 to 3,1 to 1)","","Modifiers","=Settings!$B$29:$B$31",true,"Array(1 to 3,1 to 1)"]
[null,"nmKeyBindCheck","='Custom Shortcuts'!$C$6",true,null,"","nmKeyBindCheck","='Custom Shortcuts'!$C$6",true]
[null,"OSVersion","='Custom Shortcuts'!$E$12",true,"Windows (32-bit) NT 10.00","New","OnKey_Table","='OnKey Table'!$A$1:$O$46",true,"Array(1 to 46,1 to 15)"]
[null,"'Custom Shortcuts'!Print_Area","='Custom Shortcuts'!$A$1:$N$105",true,"Array(1 to 105,1 to 14)","","OSVersion","='Custom Shortcuts'!$D$12",true,"Windows (32-bit) NT 10.00"]
[null,"QueryColumn","=Settings!$B$5",true,5,"","'Custom Shortcuts'!Print_Area","='Custom Shortcuts'!$A$1:$N$104",true,"Array(1 to 104,1 to 14)"]
[null,"ROW_INP","=Settings!$C$6",true,"J","New","Help!Print_Titles","=Help!$1:$3",true,"Array(1 to 3,1 to 16384)"]
[null,"sCalculationMode","='Custom Shortcuts'!$F$11",true,"Manual","New","Query_Inp","=Settings!$C$37",true,"E"]
[null,"Sparkline_EndColumn","=Misc!$D$19",true,null,"","QueryColumn","=Settings!$B$37",true,5]
[null,"Sparkline_RGB","=Misc!$D$16",true,12566463,"","ROW_INP","=Settings!$C$41",true,"J"]
[null,"Sparkline_StartColumn","=Misc!$D$18",true,"J","","sCalculationMode","='Custom Shortcuts'!$F$11",true,"Manual"]
[null,"Sparkline_Weight","=Misc!$D$17",true,0.5,"","Sparkline_EndColumn","=Settings!$B$19",true]
[null,"tblSheetsIgnore","='Link Format Exceptions'!$A$2:$B$37",true,"Array(1 to 36,1 to 2)","","Sparkline_RGB","=Settings!$B$16",true,12566463]
[null,"Theme_Colour","=Custom_Theme!$B$3",true,null,"","Sparkline_StartColumn","=Settings!$B$18",true,"J"]
[null,"Theme_Colour_01","=Custom_Theme!$B$3",true,null,"","Sparkline_Weight","=Settings!$B$17",true,0.5]
[null,"Theme_Font","=Custom_Theme!$B$19",true,"Example","","tblSheetsIgnore","='Link Format Exceptions'!$A$2:$B$37",true,"Array(1 to 36,1 to 2)"]
[null,"Theme_Name","=Custom_Theme!$B$1",true,"Financial_Model","","TimeSeriesStartColumn","=Settings!$B$41",true,10]
[null,"TimeSeriesStartColumn","=Settings!$B$6",true,10,"","TOT_INP","=Settings!$C$40",true,"H"]
[null,"TOT_INP","=Settings!$C$7",true,"H","New","TotalsColumn","=Settings!$B$40",true,8]
[null,"UF_Scaling","=Misc!$D$25",true,1,"","UF_Scaling","=Settings!$B$25",true,1]
[null,"UF_Scaling_Mac","=Misc!$D$23",true,1.5,"","UF_Scaling_Mac","=Settings!$B$23",true,1.5]
[null,"UF_Scaling_Windows","=Misc!$D$22",true,1,"","UF_Scaling_Windows","=Settings!$B$22",true,1]
[null,"Units_Inp","=Settings!$C$3",true,"G","","Units_Inp","=Settings!$C$39",true,"G"]
[null,"UnitsColumn","=Settings!$B$3",true,7,"","UnitsColumn","=Settings!$B$39",true,7]
[null,"VariancesOnUserform","=Misc!$D$8",true,false,"","VariancesOnUserform","=Settings!$B$8",true,false]
[null,"VarPercentTab","=Misc!$D$9",true,false,"","VarPercentTab","=Settings!$B$9",true,false]
[null,"VarRpt_MaxCols","=Misc!$D$13",true,1000,"","VarRpt_MaxCols","=Settings!$B$13",true,1000]
[null,"VarRpt_MaxRows","=Misc!$D$12",true,15000,"","VarRpt_MaxRows","=Settings!$B$12",true,15000]
[null,null,null,null,null,"New","WinModifierKey","='Custom Shortcuts'!$F$13",true,"Alt"]
[null,null,null,null,null,"New","WinOS","='Custom Shortcuts'!$F$12",true,true]

{"sheet":"Settings","index":1,"n_rows":116,"n_cols":9,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"\"To save and hide this workbook, press \" & VLOOKUP(\"ToggleVisiblePPM\",'Custom Shortcuts'!$B$1:$H$76,4,FALSE)","v":"To save and hide this workbook, press Ctrl + Shift + 7"}]
[null,null,null,"Note: hidden columns contain information used by the macros. Do not delete"]
[]
["USER SETTINGS",null,null,null,"Setting value","Range Name"]
[]
[null,null,"Calculation Mode",null,"Manual","Calculation_Setting"]
[]
[null,null,"Ctrl+Shift+4 Translation service"]
[null,null,null,"Azure Translator key",null,"Azure_Translator_Key"]
[null,null,null,"Azure Translator Region",null,"Azure_Translator_Region"]
[]
[null,null,"SPARKLINES (default line style applied)"]
[null,null,null,"Colour of line",12566463,"Sparkline_RGB"]
[null,null,null,"Weight of line in points",0.5,"Sparkline_Weight"]
[null,null,null,"Start column","J","Sparkline_StartColumn"]
[null,null,null,"End column",null,"Sparkline_EndColumn"]
[]
[null,null,"Column use convention",null,"Column Letter",null,"Column Number","Range name"]
[null,null,null,"Label Column","E","LABEL_INP",{"$f":"COLUMN(INDIRECT(E19&\"1\"))","v":5},"LabelColumn"]
[null,null,null,"Query Column","E","Query_Inp",{"$f":"COLUMN(INDIRECT(E20&\"1\"))","v":5},"QueryColumn"]
[null,null,null,"Constant Column","F","COL_INP",{"$f":"COLUMN(INDIRECT(E21&\"1\"))","v":6},"ConstantColumn"]
[null,null,null,"Units Column","G","UNITS_INP",{"$f":"COLUMN(INDIRECT(E22&\"1\"))","v":7},"UnitsColumn"]
[null,null,null,"Totals column","H","TOT_INP",{"$f":"COLUMN(INDIRECT(E23&\"1\"))","v":8},"TotalsColumn"]
[null,null,null,"Time series start","J","ROW_INP",{"$f":"COLUMN(INDIRECT(E24&\"1\"))","v":10},"TimeSeriesStartColumn"]
[]
[null,null,"Other options"]
[null,null,null,"Link to blank cells on copy across",true]
[]
[]
[null,null,"User Defined Formats",null,null,"UserDefinedFormats"]
[null,null,null,"Action","Format Example","Applied by macro","Used by procedure","What applied to","Original cf_Name"]
[null,null,null,{"$f":"INDEX(OnKey_Table,MATCH($G32,INDEX(OnKey_Table,0,2),0),4)","v":"Normal Style Toggle"},10000,{"$f":"INDEX(OnKey_Table,MATCH($G32,INDEX(OnKey_Table,0,2),0),5)","v":"Ctrl + Shift + ,"},"Normal","Numberformat","cf_NormalStyle"]
[null,null,null,"Factor Style",10,"Ctrl + Shift + .","FactorStyle","Numberformat","cf_FactorStyle"]
[null,null,null,"Percent Style",0.1,"Ctrl + Shift + P","PercentStyle","Numberformat","cf_PercentStyle"]
[null,null,null,"Date Style Long","2020-04-01","Ctrl + Shift + /","DateStyleLong","Numberformat","cf_DateStyleLong"]
[null,null,null,"Date Style Short","2020-04-01","Ctrl + /","DateStyleShort","Numberformat","cf_DateStyleShort"]
[null,null,null,"Placeholder",10,"Ctrl + Shift + Y","ShadingYellow","Interior.Color","cf_PlaceHolderFill"]
[null,null,null,"Green",10,"Ctrl + Shift + G","ShadingGreen","Interior.Color","cf_GreenFill"]
[null,null,null,"Input",10,"Ctrl + Shift + I","ShadingLtYellow","Interior.Color","cf_InputFill"]
[null,null,null,"Counterflow",10,"Ctrl + Shift + O","ShadingLtGray","Interior.Color","cf_CounterflowFill"]
[null,null,null,"Review",10,"Ctrl + Shift + R","ShadingLimeYellow","Interior.Color","cf_LimeFill"]
[null,null,null,"Valued",10,"Ctrl + Shift + V","ShadingLtTurquoise","Interior.Color","cf_MacroFill"]
[null,null,null,"Power BI",10,"Ctrl + Shift + W","ShadingPowerBI","Interior.Color","cf_PowerBI"]
[null,null,null,"Black",10,"Ctrl + Shift + B","FontColourBlack","Font.Color","cf_Black"]
[null,null,null,"Import",10,"Ctrl + Shift + M","FontColourBlue","Font.Color","cf_Import"]
[null,null,null,"Export",10,"Ctrl + Shift + X","FontColourRed","Font.Color","cf_Export"]
[null,null,null,"Border",10,"Ctrl + Shift + D","UnderOverLineWithBorder","Format","cf_Border"]
[]
[]
[]
["SYSTEM SETTINGS",null,null,null,"Setting value"]
[null,null,"OS Settings",null,null,"Range Name"]
[null,null,null,"Test Mode",false,"bTestMode"]
[null,null,null,"This OS version",{"$f":"INFO(\"OSVERSION\")","v":"Windows (64-bit ARM) NT 10.00"},"OSVersion"]
[null,null,null,"Current OS is Windows",{"$f":"LEFT(OSVersion,3)=\"Win\"","v":true},"WinOS"]
[null,null,null,"Current OS is Mac",{"$f":"LEFT(OSVersion,3)=\"Mac\"","v":false},"MacOS"]
[null,null,null,"Excel version",{"$f":"ExcelInfo()","v":"Version 16.0, 32-bit, build 17425"}]
[]
[null,null,"Variances settings"]
[null,null,null,"Create Variance % tab when\n creating other variance tabs",false,"VarPercentTab"]
[]
[null,null,null,"Maximum rows in Variance report",15000,"VarRpt_MaxRows"]
[null,null,null,"Maximum columns in Variance report",1000,"VarRpt_MaxCols"]
[]
[null,null,"Userform Dialog scaling"]
[null,null,null,"Scaling for Windows",1,"UF_Scaling_Windows"]
[null,null,null,"Scaling for Mac",1.5,"UF_Scaling_Mac"]
[null,null,null,"Userform Dialog scaling for this OS",{"$f":"IF(LEFT(OSVersion,3)=\"Win\",UF_Scaling_Windows,UF_Scaling_Mac)","v":1},"UF_Scaling"]
[]
[null,null,"Shortcut modifier keys"]
[null,null,null,"51 Custom Shortcuts",true,"bMacrosRun"]
[null,null,null,"Windows Shortcut Key Modifiers","Ctrl +","Modifiers"]
[null,null,null,null,"Ctrl + Shift +"]
[null,null,null,null,"Ctrl + Alt +"]
[null,null,null,null,"Ctrl + Alt + Shift +"]
[null,null,null,"Windows Alt modifier key","Alt +","WinModifierKey"]
[null,null,null,"Mac Alt modifier key","Option + Shift +","MacModifierKey"]
[]
[null,null,"System Defined Formats",null,null,"SystemDefinedFormats"]
[null,null,null,"Action","Format Example","Applied by macro","Used by procedure","What applied to","Original cf_Name"]
[null,null,null,{"$f":"INDEX(OnKey_Table,MATCH($G81,INDEX(OnKey_Table,0,2),0),4)","v":"Increase 0s"},"0.00 --> 0.000",{"$f":"INDEX(OnKey_Table,MATCH($G81,INDEX(OnKey_Table,0,2),0),5)","v":"Ctrl + ."},"IncreaseZeros","Numberformat"]
[null,null,null,{"$f":"INDEX(OnKey_Table,MATCH($G82,INDEX(OnKey_Table,0,2),0),4)","v":"Decrease 0s"}," 0.0  -->  0.0",{"$f":"INDEX(OnKey_Table,MATCH($G82,INDEX(OnKey_Table,0,2),0),5)","v":"Ctrl + ,"},"DecreaseZeros","Numberformat"]
[null,null,null,{"$f":"INDEX(OnKey_Table,MATCH($G83,INDEX(OnKey_Table,0,2),0),4)","v":"No shade"},null,{"$f":"INDEX(OnKey_Table,MATCH($G83,INDEX(OnKey_Table,0,2),0),5)","v":"Ctrl + Shift + C"},"ShadingNone","Interior.Color"]
[null,null,null,{"$f":"INDEX(OnKey_Table,MATCH($G84,INDEX(OnKey_Table,0,2),0),4)","v":"Date Style Toggle"},"2020-04-01",{"$f":"INDEX(OnKey_Table,MATCH($G84,INDEX(OnKey_Table,0,2),0),5)","v":"Ctrl + Shift + L"},"DateStyleToggle","Numberformat"]
[null,null,null,{"$f":"INDEX(OnKey_Table,MATCH($G85,INDEX(OnKey_Table,0,2),0),4)","v":"Square Brackets"},"[example]",{"$f":"INDEX(OnKey_Table,MATCH($G85,INDEX(OnKey_Table,0,2),0),5)","v":"Ctrl + Shift + T"},"other_Brackets","Contents"]
[]
[]
[null,null,"Shortcut error checks"]
[null,null,null,"Check key lengths should be 1",{"$f":"IF(COUNTIF(INDEX(OnKey_Table,0,11),1)=COUNT(INDEX(OnKey_Table,0,11)),\"\",D89)","v":""},"CheckKeyLength"]
[null,null,null,"Check keys duplicated",{"$f":"IF(COUNTIF(INDEX(OnKey_Table,0,12),1)=COUNT(INDEX(OnKey_Table,0,12)),\"\",D90)","v":""},"CheckKeyDuplicate"]
[null,null,null,"Check incorrect modifier keys",{"$f":"IF(ISERROR(SUM(INDEX(OnKey_Table,0,13))),D91,\"\")","v":""},"CheckModifierKeys"]
[]
[]
[null,null,"Model Range names required by macros",null,"Used by"]
[null,null,null,"Corkscrew_withBal","AddCorkScrew"]
[null,null,null,"Corkscrew_NoBal","AddCorkScrew"]
[null,null,null,"CASE_ACTIVE","RelocateInput"]
[null,null,null,"InputRowTemplate","RelocateInput"]
[null,null,null,"OutputRowTemplate","RelocateOutput"]
[null,null,null,"TrackStoredResults","StoreTrack"]
[null,null,null,"TrackActive","StoreTrack"]
[null,null,null,"TrackLiveResults","StoreTrack"]
[null,null,null,"InputStored","AddToChangeLog"]
[null,null,null,"ChangeLogLatestValueColumn","HardCodeChangeLog,AddToChangeLog"]
[null,null,null,"ChangeLogStartRow","AddToChangeLog"]
[null,null,null,"ChangeLogTimelineStart","AddToChangeLog"]
[null,null,null,"ChangeLogTitleRow","AddToChangeLog"]
[]
[]
[null,null,null,"Internal Development macros"]
[null,null,null,"Regression test all macros","#testMacros"]
[]
[null,null,null,"For Translation test"]
[null,null,null,"English","Français","Español","Deutsch","عربى","日本語"]
[null,null,null,"Hello","Bonjour","Hola","Hallo","أهلا","こんにちは"]
[null,null,null,"This is a test","Ceci est un test","Esto es una prueba","Dies ist ein Test","هذا اختبار","これはテストです"]

{"sheet":"Custom Shortcuts","index":2,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Type","Macro","Active","Action","Keyboard Shortcut","Mac Modifier Key(s)","Win Modifier Key(s)","Custom Key","Mnemonic","(unused column)","Key length check","Duplicate if >1 each shortcut","Modifier check","Error check","Excel shortcut check (Excel_Shortcuts is a range on the hidden sheet Win & Mac Shortcuts)","Documentation: What range names does this macro use?\nEvery macro uses bMacrosRun & OnKey_Table.\nInit uses Calculation_Setting\nAll forms use UF_Scaling"]
["Utilities","AddToChangeLog",true,"Add To Change Log",{"$f":"IF(MacOS, F2,G2) & \" \" & H2","v":"Ctrl + Shift + 1"},{"$f":"IF( G2=\"Ctrl + Alt +\",\"Ctrl + \" & MacModifierKey,G2&\"\")","v":"Ctrl + Shift +"},"Ctrl + Shift +",1,null,null,{"$f":"LEN(H2)","v":1},{"$f":"COUNTIF(INDEX(OnKey_Table,0,COLUMN(E1)),$E2)","v":1},{"$f":"MATCH(G2,CASmodifiers,0)","v":2},{"$f":"IF(AND(K2=1,L2=1,NOT(ISERROR(M2))),0,1)","v":0},{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E2,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"ChangeLogStartRow,ChangeLogTimelineStart,ChangeLogTitleRow,InputStored,LabelColumn"]
[null,"HardCodeChangeLog",true,"Save Change Log Values","Ctrl + Shift + 2","Ctrl + Shift +","Ctrl + Shift +",2,null,null,{"$f":"LEN(H3)","v":1},1,{"$f":"MATCH(G3,CASmodifiers,0)","v":2},{"$f":"IF(AND(K3=1,L3=1,NOT(ISERROR(M3))),0,1)","v":0},{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E3,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"ChangeLogLatestValueColumn,ChangeLogTimelineStart"]
[null,"TranslateSelection",true,"Translate Selection","Ctrl + Shift + 4","Ctrl + Shift +","Ctrl + Shift +",4,null,null,{"$f":"LEN(H4)","v":1},1,{"$f":"MATCH(G4,CASmodifiers,0)","v":2},{"$f":"IF(AND(K4=1,L4=1,NOT(ISERROR(M4))),0,1)","v":0},{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E4,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"ISO639_Data,UF_Scaling,Azure_Translation_Key,Azure_Translation_Region"]
[null,"StoreTrack",true,"Create Output Track","Ctrl + Shift + 5","Ctrl + Shift +","Ctrl + Shift +",5,null,null,{"$f":"LEN(H5)","v":1},1,{"$f":"MATCH(G5,CASmodifiers,0)","v":2},{"$f":"IF(AND(K5=1,L5=1,NOT(ISERROR(M5))),0,1)","v":0},{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E5,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"TrackStoredResults,TrackActive,TrackLiveResults"]
[null,"PrepareForRelease",true,"Bring up selection userform","Ctrl + Shift + 6","Ctrl + Shift +","Ctrl + Shift +",6,null,null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E6,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"TimeSeriesStartColumn,lstCapitalisationExceptions,LABEL_INP,Corkscrew_withBal,Corkscrew_NoBal,LabelColumn,ConstantColumn,UnitsColumn,TotalsColumn,TimeSeriesStartColumn,UNITS_INP"]
[null,"ToggleVisiblePPM",true,"Unhide / Rehide & Save Macro File","Ctrl + Shift + 7","Ctrl + Shift +","Ctrl + Shift +",7,null,null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E7,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"DeleteConditionalFormat",true,"Delete selected Conditional Format(s)","Ctrl + Shift + 8","Ctrl + Shift +","Ctrl + Shift +",8,null,null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E8,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"VarianceReport",true,"Create Variance tabs","Ctrl + Shift + 9","Ctrl + Shift +","Ctrl + Shift +",9,null,null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E9,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"ROW_INP,VariancesOnUserform,VarRpt_MaxRows,VarRpt_MaxCols,VarPercentTab"]
[null,"DeleteSheet",true,"Delete Worksheet","Ctrl + Alt + -","Ctrl + Option + Shift +","Ctrl + Alt +","-","Minus to remove",null,1,1,3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E10,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":"Zoom out"}]
[null,"Anchoring",true,"Anchoring","Ctrl + Alt + A","Ctrl + Option + Shift +","Ctrl + Alt +","A","A for Anchoring",null,1,1,3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E11,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"CopyAcross",true,"Copy Across","Ctrl + Shift + A","Ctrl + Shift +","Ctrl + Shift +","A","A for Copy Across",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E12,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":"Insert function arguments"},"ConstantColumn,LabelColumn"]
[null,"ResetEnd",true,"Reset end cell / clear unused range","Ctrl + Alt + C","Ctrl + Option + Shift +","Ctrl + Alt +","C","C for Clear to end",null,1,{"$f":"COUNTIF(INDEX(OnKey_Table,0,COLUMN(E12)),$E13)","v":1},3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E13,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"Units_INP"]
[null,"PasteAsValue",true,"Paste As Value w/o Format","Ctrl + Alt + D","Ctrl + Option + Shift +","Ctrl + Alt +","D","D for Data",null,1,1,3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E14,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"AmendExceptionSheets",true,"Exceptions","Ctrl + Alt + E","Ctrl + Option + Shift +","Ctrl + Alt +","E","E for Exceptions",null,1,1,3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E15,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"lstSheetsIgnore,lstCapitalisationExceptions"]
[null,"HelpKeys",true,"Show list of shortcuts","Ctrl + Alt + H","Ctrl + Option + Shift +","Ctrl + Alt +","H","H for Help",null,1,1,3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E16,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"OnKey_Table,CheckKeyLength,CheckKeyDuplicate,CheckModifierKeys"]
[null,"InsertSignSwitchRow",true,"Switch sign",{"$f":"IF(MacOS, F17,G17) & \" \" & H17","v":"Ctrl + Alt + N"},{"$f":"IF( G17=\"Ctrl + Alt +\",\"Ctrl + \" & MacModifierKey,G17&\"\")","v":"Ctrl + Option + Shift +"},"Ctrl + Alt +","N","N for Negation or sigN",null,{"$f":"LEN(H17)","v":1},{"$f":"COUNTIF(INDEX(OnKey_Table,0,COLUMN(E16)),$E17)","v":1},{"$f":"MATCH(G17,CASmodifiers,0)","v":3},{"$f":"IF(AND(K17=1,L17=1,NOT(ISERROR(M17))),0,1)","v":0},{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E17,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"RowSummation",true,"Sum Across","Ctrl + Shift + N","Ctrl + Shift +","Ctrl + Shift +","N","N for SummatioN",null,1,{"$f":"COUNTIF(INDEX(OnKey_Table,0,COLUMN(E16)),$E18)","v":1},2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E18,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"TotalsColumn,ConstantColumn"]
[null,"RelocateOutput",true,"Relocate Outputs","Ctrl + Alt + O","Ctrl + Option + Shift +","Ctrl + Alt +","O","O for Outputs",null,1,1,3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E19,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"COL_INP,Units_Inp,TOT_INP,LABEL_INP,OutputRowTemplate"]
[null,"FAST_Placeholders",true,"Placeholders List with comments","Ctrl + Alt + P","Ctrl + Option + Shift +","Ctrl + Alt +","P","P for Placeholder list",null,1,1,3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E20,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"LABEL_INP"]
[null,"AddModelQuery",true,"Model Queries ","Ctrl + Alt + Q","Ctrl + Option + Shift +","Ctrl + Alt +","Q","Q for Query",null,1,1,3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E21,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"LabelColumn,Label_INP,QueryColumn"]
[null,"QuickLink",true,"Quick Link","Ctrl + Shift + Q","Ctrl + Shift +","Ctrl + Shift +","Q","Q for Quick link",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E22,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"lstSheetsIgnore"]
[null,"RelocateInput",true,"Relocate Inputs","Ctrl + Alt + R","Ctrl + Option + Shift +","Ctrl + Alt +","R","R for Relocate",null,1,1,3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E23,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"CASE_ACTIVE,InputRowTemplate,ConstantColumn,TimeSeriesStartColumn,ROW_INP,COL_INP,LabelColumn"]
[null,"PasteAsValueFormat",true,"Paste Format From Copied Range","Ctrl + Alt + S","Ctrl + Option + Shift +","Ctrl + Alt +","S","S for paSte",null,1,1,3,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E24,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"AddSparkline",true,"Add Sparkline in column F","Ctrl + Shift + S","Ctrl + Shift +","Ctrl + Shift +","S","S for Sparkline",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E25,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"ConstantColumn,Sparkline_StartColumn,Sparkline_EndColumn,Sparkline_RGB,Sparkline_Weight"]
[null,"other_Brackets",true,"Square Brackets","Ctrl + Shift + T","Ctrl + Shift +","Ctrl + Shift +","T","T for Temporary",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E26,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":"Toggle table total row"}]
["Navigation","Group_Expand",true,"Expand Group","Ctrl + E","Ctrl +","Ctrl +","E","E for Expand",null,1,1,1,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E27,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":"Flash fill"}]
[null,"Group_Collapse",true,"Collapse Group","Ctrl + Shift + E","Ctrl + Shift +","Ctrl + Shift +","E","E for CollapsE",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E28,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"other_JumpLink",true,"Jump to Precedent","Ctrl + Shift + J","Ctrl + Shift +","Ctrl + Shift +","J","J for Jump",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E29,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"other_JumpHome",true,"Return from Jump","Ctrl + Shift + K","Ctrl + Shift +","Ctrl + Shift +","K","Next to J",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E30,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
["Number Formats","DecreaseZeros",true,"Decrease 0s","Ctrl + ,","Ctrl +","Ctrl +",",","< for decrease",null,1,1,1,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E31,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"Normal",true,"Normal Style Toggle","Ctrl + Shift + ,","Ctrl + Shift +","Ctrl + Shift +",",",",000 separator is Comma",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E32,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"IncreaseZeros",true,"Increase 0s","Ctrl + .","Ctrl +","Ctrl +",".","> for increase",null,1,1,1,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E33,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":"Move active cell clockwise in selection"}]
[null,"FactorStyle",true,"Factor Style","Ctrl + Shift + .","Ctrl + Shift +","Ctrl + Shift +",".","Decimal point key",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E34,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"DateStyleShort",true,"Date Style Short","Ctrl + /","Ctrl +","Ctrl +","/","dd mm yy",null,1,1,1,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E35,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":"Select current array"}]
[null,"DateStyleLong",true,"Date Style Long","Ctrl + Shift + /","Ctrl + Shift +","Ctrl + Shift +","/","dd mm yyyy",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E36,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
[null,"DateStyleToggle",true,"Date Style Toggle","Ctrl + Shift + L","Ctrl + Shift +","Ctrl + Shift +","L","L for Long date",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E37,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":"Toggle Autofilter"}]
[null,"PercentStyle",true,"Percent Style","Ctrl + Shift + P","Ctrl + Shift +","Ctrl + Shift +","P","P for Percent",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E38,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""}]
["Cell Formats","FontColourBlack",true,"Black","Ctrl + Shift + B","Ctrl + Shift +","Ctrl + Shift +","B","B for Black",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E39,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]
[null,"UnderOverLineWithBorder",true,"Border","Ctrl + Shift + D","Ctrl + Shift +","Ctrl + Shift +","D","D for unDerline",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E40,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]
[null,"FontColourBlue",true,"Import","Ctrl + Shift + M","Ctrl + Shift +","Ctrl + Shift +","M","M for iMport",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E41,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]
[null,"FontColourRed",true,"Export","Ctrl + Shift + X","Ctrl + Shift +","Ctrl + Shift +","X","X for eXport",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E42,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]
[null,"ShadingNone",true,"No shade","Ctrl + Shift + C","Ctrl + Shift +","Ctrl + Shift +","C","C for Clear",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E43,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]
[null,"ShadingGreen",true,"Green","Ctrl + Shift + G","Ctrl + Shift +","Ctrl + Shift +","G","G for Green",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E44,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]
[null,"ShadingLtYellow",true,"Input","Ctrl + Shift + I","Ctrl + Shift +","Ctrl + Shift +","I","I for Inputs",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E45,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]
[null,"ShadingLtGray",true,"Counterflow","Ctrl + Shift + O","Ctrl + Shift +","Ctrl + Shift +","O","O for cOunterflOws",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E46,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":"Select cells with comments"},"UserDefinedFormats"]
[null,"ShadingLimeYellow",true,"Review","Ctrl + Shift + R","Ctrl + Shift +","Ctrl + Shift +","R","R for Review",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E47,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]
[null,"ShadingLtTurquoise",true,"Valued","Ctrl + Shift + V","Ctrl + Shift +","Ctrl + Shift +","V","V for Stored Values",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E48,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]
[null,"ShadingPowerBI",true,"Power BI","Ctrl + Shift + W","Ctrl + Shift +","Ctrl + Shift +","W","W for poWer",null,1,1,2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E49,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]
[null,"ShadingRed",true,"Red","Ctrl + Alt + W","Ctrl + Option + Shift +","Ctrl + Alt +","W",null,null,1]
[null,"ShadingRedOchre",true,"RGB (255, 153,102)",{"$f":"IF(MacOS, F51,G51) & \" \" & H51","v":"Ctrl + Alt + B"},{"$f":"IF( G51=\"Ctrl + Alt +\",\"Ctrl + \" & MacModifierKey,G51&\"\")","v":"Ctrl + Option + Shift +"},"Ctrl + Alt +","B",null,null,{"$f":"LEN(H51)","v":1}]
[null,"ShadingYellow",true,"Placeholder","Ctrl + Shift + Y","Ctrl + Shift +","Ctrl + Shift +","Y","Y for Yellow",null,1,{"$f":"COUNTIF(INDEX(OnKey_Table,0,COLUMN(E49)),$E52)","v":1},2,0,{"$f":"_xlfn.XLOOKUP(SUBSTITUTE(E52,\" \",\"\"),INDEX(Excel_Shortcuts,0,IF(WinOS,4,5)),INDEX(Excel_Shortcuts,0,1),\"\",0)","v":""},"UserDefinedFormats"]

{"sheet":"(hidden) Win & Mac Shortcuts","index":3,"n_rows":244,"n_cols":6,"rows_kept":244,"cut":false,"hidden":true,"merged":[]}
["Action","WinKB","MacKB","Win","Mac","Although not documented, Ctrl+key in Mac usually works the same as Cmd+key.\nExcept for Cmd+H (Finder:Hide window)"]
["Create new workbook","CtrlN","⌘N","Ctrl+N","Cmd+N","UNICODE(\"⌘\") = 8984"]
["Open workbook","CtrlO","⌘O","Ctrl+O","Cmd+O","UNICODE(\"⇧\") = 8679"]
["Save workbook","CtrlS","⌘S","Ctrl+S","Cmd+S","UNICODE(\"⌃\") = 8963"]
["Save as","F12","⌘⇧S","F12","Cmd+Shift+S","Cmd+Shift+s"]
["Print file","CtrlP","⌘P","Ctrl+P","Cmd+P"]
["Open print preview window","CtrlF2","","Ctrl+F2",""]
["Close current workbook","CtrlW","⌘W","Ctrl+W","Cmd+W","Win:Ctrl+F4  (Mac: Activity Monitor)"]
["Close Excel","AltF4","⌘Q","Alt+F4","Cmd+Q"]
["Expand or collapse ribbon","CtrlF1","⌘⌥R","Ctrl+F1","Cmd+Option+R","UNICODE(\"⌥\") = 8997"]
["Activate access keys","Alt","","Alt+",""]
["Move to next ribbon control","Tab","Tab","Tab","Tab"]
["Activate or open selected control","Space","Space","Space","Space"]
["Confirm control change","Enter","Return","Enter","Return"]
["Get help on selected control","F1","","F1",""]
["Open options","AltFT","⌘,","Alt+FT","Cmd+,"]
["Open help","F1","⌘/","F1","Cmd+/"]
["Undo last action","CtrlZ","⌘Z","Ctrl+Z","Cmd+Z"]
["Redo last action","CtrlY","⌘Y","Ctrl+Y","Cmd+Y"]
["Copy selected cells","CtrlC","⌘C","Ctrl+C","Cmd+C"]
["Repeat last action","F4","⌘Y","F4","Cmd+Y"]
["Cut selected cells","CtrlX","⌘X","Ctrl+X","Cmd+X"]
["Paste content from clipboard","CtrlV","⌘V","Ctrl+V","Cmd+V"]
["Display the Paste Special dialog box","CtrlAltV","⌘⌃V","Ctrl+Alt+V","Cmd+Ctrl+V","Cmd+Option+V"]
["Display find and replace","CtrlF","⌘F","Ctrl+F","Cmd+F"]
["Display find and replace, replace selected","CtrlH","⌃H","Ctrl+H","Ctrl+H","Cmd+h (Finder:Hide window)"]
["Find next match","ShiftF4","⌘G","Shift+F4","Cmd+G"]
["Find previous match","CtrlShiftF4","⌘⇧G","Ctrl+Shift+F4","Cmd+Shift+G","Cmd+Shift+g"]
["Create embedded chart","AltF1","Fn⌥F1","Alt+F1","Fn+Option+F1"]
["Create chart in new worksheet","F11","FnF11","F11","Fn+F11"]
["Insert table","CtrlT","⌘T","Ctrl+T","Cmd+T"]
["Toggle Autofilter","CtrlShiftL","⌘⇧F","Ctrl+Shift+L","Cmd+Shift+F","Cmd+Shift+f"]
["Activate filter","Alt↓","⌥↓","Alt+↓","Option+↓"]
["Select table row","ShiftSpace","⇧Space","Shift+Space","Shift+Space"]
["Select table column","CtrlSpace","⌃Space","Ctrl+Space","Ctrl+Space","Cmd+Space: Spotlight Search"]
["Select table","CtrlA","⌘A","Ctrl+A","Cmd+A"]
["Clear slicer filter","AltC","⌥C","Alt+C","Option+C"]
["Toggle table total row","CtrlShiftT","⌃⇧T","Ctrl+Shift+T","Ctrl+Shift+T","Ctrl+Shift+t"]
["Drag and cut","drag","drag","drag","drag"]
["Drag and copy","Ctrldrag","⌥drag","Ctrl+drag","Option+drag"]
["Drag and insert","Shiftdrag","⇧drag","Shift+drag","Shift+drag"]
["Drag and insert copy","CtrlShiftdrag","⌥⇧drag","Ctrl+Shift+drag","Option+Shift+drag"]
["Drag to worksheet","Altdrag","⌘drag","Alt+drag","Cmd+drag"]
["Drag to duplicate worksheet","Ctrldrag","⌥drag","Ctrl+drag","Option+drag"]
["Move one cell right","→","→","→","→"]
["Move one cell left","←","←","←","←"]
["Move one cell up","↑","↑","↑","↑"]
["Move one cell down","↓","↓","↓","↓"]
["Move one screen right","AltPgDn","Fn⌥↓","Alt+PgDn","Fn+Option+↓"]
["Move one screen left","AltPgUp","Fn⌥↑","Alt+PgUp","Fn+Option+↑"]
["Move one screen up","PgUp","Fn↑","PgUp","Fn+↑"]
["Move one screen down","PgDn","Fn↓","PgDn","Fn+↓"]
["Move to right edge of data region","Ctrl→","⌘→","Ctrl+→","Cmd+→"]
["Move to left edge of data region","Ctrl←","⌘←","Ctrl+←","Cmd+←"]
["Move to top edge of data region","Ctrl↑","⌘↑","Ctrl+↑","Cmd+↑"]
["Move to bottom edge of data region","Ctrl↓","⌘↓","Ctrl+↓","Cmd+↓"]
["Move to beginning of row","Home","Fn←","Home","Fn+←"]
["Move to last cell in worksheet","CtrlEnd","Fn⌘→","Ctrl+End","Fn+Cmd+→"]
["Move to first cell in worksheet","CtrlHome","Fn⌘←","Ctrl+Home","Fn+Cmd+←"]
["Turn End mode on","End","Fn→","End","Fn+→"]
["Go back to hyperlink","CtrlGEnter","⌃GReturn","Ctrl+GEnter","Ctrl+GReturn"]
["Select entire row","ShiftSpace","⇧Space","Shift+Space","Shift+Space"]
["Select entire column","CtrlSpace","⌃Space","Ctrl+Space","Ctrl+Space"]
["Select entire worksheet","CtrlA","⌘A","Ctrl+A","Cmd+A"]
["Add adjacent cells to selection","ShiftClick","⇧Click","Shift+Click","Shift+Click"]
["Add non-adjacent cells to selection","CtrlClick","⌘Click","Ctrl+Click","Cmd+Click"]
["Same selection in next column",0,"⌥Tab","0","Option+Tab"]
["Same selection in previous column",0,"⌥⇧Tab","0","Option+Shift+Tab"]
["Move right between non-adjacent selections","CtrlAlt→","⌃⌥→","Ctrl+Alt+→","Ctrl+Option+→"]
["Move left between non-adjacent selections","CtrlAlt←","⌃⌥←","Ctrl+Alt+←","Ctrl+Option+←"]
["Toggle add to selection mode","ShiftF8","Fn⇧F8","Shift+F8","Fn+Shift+F8"]
["Cancel selection","Esc","Esc","Esc","Esc"]
["Select active cell only","ShiftBackspace","⇧Delete","Shift+Backspace","Shift+Delete"]
["Show the active cell on worksheet","CtrlBackspace","⌃Delete","Ctrl+Backspace","Ctrl+Delete"]
["Move active cell clockwise in selection","Ctrl.","⌃.","Ctrl+.","Ctrl+.","Does not work in Mac?"]
["Move active cell down in selection","Enter","Return","Enter","Return"]
["Move active cell up in selection","ShiftEnter","⇧Return","Shift+Enter","Shift+Return"]
["Move active cell right in a selection","Tab","Tab","Tab","Tab"]
["Move active cell left in a selection","ShiftTab","⇧Tab","Shift+Tab","Shift+Tab"]
["Extend selection by one cell right","Shift→","⇧→","Shift+→","Shift+→"]
["Extend selection by one cell left","Shift←","⇧←","Shift+←","Shift+←"]
["Extend selection by one cell up","Shift↑","⇧↑","Shift+↑","Shift+↑"]
["Extend selection by one cell down","Shift↓","⇧↓","Shift+↓","Shift+↓"]
["Extend the selection to the last cell right","CtrlShift→","⌘⇧→","Ctrl+Shift+→","Cmd+Shift+→"]
["Extend the selection to the last cell left","CtrlShift←","⌘⇧←","Ctrl+Shift+←","Cmd+Shift+←"]
["Extend the selection to the last cell up","CtrlShift↑","⌘⇧↑","Ctrl+Shift+↑","Cmd+Shift+↑"]
["Extend the selection to the last cell down","CtrlShift↓","⌘⇧↓","Ctrl+Shift+↓","Cmd+Shift+↓"]
["Extend selection up one screen","ShiftPgUp","Fn⇧↑","Shift+PgUp","Fn+Shift+↑"]
["Extend selection down one screen","ShiftPgDn","Fn⇧↓","Shift+PgDn","Fn+Shift+↓"]
["Extend selection right one screen","AltShiftPgDn","Fn⇧⌥↓","Alt+Shift+PgDn","Fn+Shift+Option+↓"]
["Extend selection left one screen","AltShiftPgUp","Fn⇧⌥↑","Alt+Shift+PgUp","Fn+Shift+Option+↑"]
["Extend selection to start of row","ShiftHome","Fn⇧←","Shift+Home","Fn+Shift+←"]
["Extend selection to first cell in worksheet","CtrlShiftHome","Fn⌃⇧←","Ctrl+Shift+Home","Fn+Ctrl+Shift+←"]
["Extend selection to last cell in worksheet","CtrlShiftEnd","Fn⌃⇧→","Ctrl+Shift+End","Fn+Ctrl+Shift+→"]
["Toggle extend selection mode","F8","FnF8","F8","Fn+F8"]
["Display 'Go To' dialog box","CtrlG","⌃G","Ctrl+G","Ctrl+G","F5"]
["Select cells with comments","CtrlShiftO","Fn⌃⇧O","Ctrl+Shift+O","Fn+Ctrl+Shift+O"]
["Select current region around active cell","CtrlShift*","⌃⇧Space","Ctrl+Shift+*","Ctrl+Shift+Space"]
["Select current region","CtrlA","⌘A","Ctrl+A","Cmd+A"]
["Select current array","Ctrl/","⌃/","Ctrl+/","Ctrl+/"]
["Select row differences","Ctrl\\","⌃\\","Ctrl+\\","Ctrl+\\"]
["Select column differences","CtrlShift|","⌃⇧|","Ctrl+Shift+|","Ctrl+Shift+|","Ctrl+Shift+\\"]
["Select direct precedents","Ctrl[","⌃[","Ctrl+[","Ctrl+["]
["Select all precedents","CtrlShift{","⌃⇧{","Ctrl+Shift+{","Ctrl+Shift+{","Ctrl+Shift+["]
["Select direct dependents","Ctrl]","⌃]","Ctrl+]","Ctrl+]"]
["Select all dependents","CtrlShift}","⌃⇧}","Ctrl+Shift+}","Ctrl+Shift+}","Ctrl+Shift+]"]
["Select visible cells only","Alt;","⌘⇧Z","Alt+;","Cmd+Shift+Z","Cmd+Shift+z"]
["Edit the active cell","F2","⌃U","F2","Ctrl+U"]
["Cancel entry","Esc","Esc","Esc","Esc"]
["Select one character right","Shift→","⇧→","Shift+→","Shift+→"]
["Select one character left","Shift←","⇧←","Shift+←","Shift+←"]
["Move one word right","Ctrl→","⌃→","Ctrl+→","Ctrl+→"]
["Move one word left","Ctrl←","⌃←","Ctrl+←","Ctrl+←"]
["Select one word right","CtrlShift→","⌃⇧→","Ctrl+Shift+→","Ctrl+Shift+→"]
["Select one word left","CtrlShift←","⌃⇧←","Ctrl+Shift+←","Ctrl+Shift+←"]
["Select to beginning of cell","ShiftHome","Fn⇧←","Shift+Home","Fn+Shift+←"]
["Select to end of cell","ShiftEnd","Fn⇧→","Shift+End","Fn+Shift+→"]
["Delete to end of line","CtrlDelete","Fn⌃Delete","Ctrl+Delete","Fn+Ctrl+Delete"]
["Delete character to the left of cursor","Backspace","Delete","Backspace","Delete"]
["Delete character to the right of cursor","Delete","FnDelete","Delete","Fn+Delete"]
["Insert line break in cell","AltEnter","⌃⌥Return","Alt+Enter","Ctrl+Option+Return"]
["Enter and move down","Enter","Return","Enter","Return"]
["Enter and move up","ShiftEnter","⇧Return","Shift+Enter","Shift+Return"]
["Enter and move right","Tab","Tab","Tab","Tab"]
["Enter and move left","ShiftTab","⇧Tab","Shift+Tab","Shift+Tab"]
["Complete entry and stay in same cell","CtrlEnter","⌃Return","Ctrl+Enter","Ctrl+Return"]
["Enter same data in multiple cells","CtrlEnter","⌃Return","Ctrl+Enter","Ctrl+Return"]
["Insert current date","Ctrl;","⌃;","Ctrl+;","Ctrl+;"]
["Insert current time","CtrlShift:","⌘;","Ctrl+Shift+:","Cmd+;"]
["Fill down from cell above","CtrlD","⌘D","Ctrl+D","Cmd+D"]
["Fill right from cell left","CtrlR","⌘R","Ctrl+R","Cmd+R"]
["Copy formula from cell above","Ctrl'","⌘'","Ctrl+'","Cmd+'"]
["Copy value from cell above","CtrlShift\"","⌃⇧\"","Ctrl+Shift+\"","Ctrl+Shift+\"","Ctrl+Shift+2"]
["Add hyperlink","CtrlK","⌘K","Ctrl+K","Cmd+K"]
["Display AutoComplete list","Alt↓","⌥↓","Alt+↓","Option+↓"]
["Flash fill","CtrlE","⌃E","Ctrl+E","Ctrl+E"]
["Format (almost) anything","Ctrl1","⌘1","Ctrl+1","Cmd+1"]
["Display Format Cells with Font tab selected","CtrlShiftF","⌃⇧F","Ctrl+Shift+F","Ctrl+Shift+F","Ctrl+Shift+f"]
["Toggle bold formatting","CtrlB","⌘B","Ctrl+B","Cmd+B"]
["Toggle italic formatting","CtrlI","⌘I","Ctrl+I","Cmd+I"]
["Toggle underline formatting","CtrlU","⌘U","Ctrl+U","Cmd+U"]
["Toggle strikethrough formatting","Ctrl5","⌘⇧X","Ctrl+5","Cmd+Shift+X","Cmd+Shift+x"]
["Align center","AltHAC","⌘E","Alt+HAC","Cmd+E"]
["Align left","AltHAL","⌘L","Alt+HAL","Cmd+L"]
["Align right","AltHAR","⌘R","Alt+HAR","Cmd+R"]
["Indent","AltH6","⌃⌥Tab","Alt+H6","Ctrl+Option+Tab"]
["Remove indent","AltH5","⌃⌥⇧Tab","Alt+H5","Ctrl+Option+Shift+Tab"]
["Increase font size one step","AltHFG","⌘⇧>","Alt+HFG","Cmd+Shift+>","Cmd+Shift+."]
["Decrease font size one step","AltHFK","⌘⇧<","Alt+HFK","Cmd+Shift+<","Cmd+Shift+,"]
["Apply general format","CtrlShift~","⌃⇧~","Ctrl+Shift+~","Ctrl+Shift+~","Ctrl+Shift+#"]
["Apply currency format","CtrlShift$","⌃⇧$","Ctrl+Shift+$","Ctrl+Shift+$","Ctrl+Shift+4"]
["Apply percentage format","CtrlShift%","⌃⇧%","Ctrl+Shift+%","Ctrl+Shift+%","Ctrl+Shift+5"]
["Apply scientific format","CtrlShift^","⌃⇧^","Ctrl+Shift+^","Ctrl+Shift+^","Ctrl+Shift+6"]
["Apply date format","CtrlShift#","⌃⇧#","Ctrl+Shift+#","Ctrl+Shift+#","Ctrl+Shift+7"]
["Apply time format","CtrlShift@","⌃⇧@","Ctrl+Shift+@","Ctrl+Shift+@","Ctrl+Shift+'"]
["Apply number format","CtrlShift!","⌃⇧!","Ctrl+Shift+!","Ctrl+Shift+!","Ctrl+Shift+1"]
["Add border outline","CtrlShift&","⌘⌥0","Ctrl+Shift+&","Cmd+Option+0"]
["Add or remove border right","AltR","⌘⌥→","Alt+R","Cmd+Option+→"]
["Add or remove border left","AltL","⌘⌥←","Alt+L","Cmd+Option+←"]
["Add or remove border top","AltT","⌘⌥↑","Alt+T","Cmd+Option+↑"]
["Add or remove border bottom","AltB","⌘⌥↓","Alt+B","Cmd+Option+↓"]
["Add or remove border upward diagonal","AltD","","Alt+D",""]
["Add or remove border horizontal interior","AltH","","Alt+H",""]
["Add or remove border vertical interior","AltV","","Alt+V",""]
["Remove borders","CtrlShift_","⌘⌥_","Ctrl+Shift+_","Cmd+Option+_"]
["Toggle absolute and relative references","F4","⌘T","F4","Cmd+T"]
["Open the Insert Function Dialog Box","ShiftF3","Fn⇧F3","Shift+F3","Fn+Shift+F3"]
["Autosum selected cells","Alt=","⌘⇧T","Alt+=","Cmd+Shift+T","Cmd+Shift+t"]
["Toggle formulas on and off","Ctrl`","⌃`","Ctrl+`","Ctrl+`"]
["Insert function arguments","CtrlShiftA","⌃⇧A","Ctrl+Shift+A","Ctrl+Shift+A","Ctrl+Shift+a"]
["Enter array formula","CtrlShiftEnter","⌃⇧Return","Ctrl+Shift+Enter","Ctrl+Shift+Return"]
["Calculate worksheets","F9","FnF9","F9","Fn+F9"]
["Calculate active worksheet","ShiftF9","Fn⇧F9","Shift+F9","Fn+Shift+F9"]
["Force calculate all worksheets","CtrlAltF9","","Ctrl+Alt+F9",""]
["Evaluate part of a formula","F9","FnF9","F9","Fn+F9"]
["Expand or collapse the formula bar","CtrlShiftU","⌃⇧U","Ctrl+Shift+U","Ctrl+Shift+U","Ctrl+Shift+u"]
["Display function arguments dialog box","CtrlA","⌃A","Ctrl+A","Ctrl+A"]
["Open the Name Manager","CtrlF3","Fn⌃F3","Ctrl+F3","Fn+Ctrl+F3"]
["Define name using row and column labels","CtrlShiftF3","Fn⌃⇧F3","Ctrl+Shift+F3","Fn+Ctrl+Shift+F3"]
["Select name box","AltF3","","Alt+F3",""]
["Paste name into formula","F3","F3","F3","F3"]
["Accept function with autocomplete","Tab","Tab","Tab","Tab"]
["Display Insert Dialog box","CtrlShift+","⌘⇧+","Ctrl+Shift++","Cmd+Shift++","Cmd+Shift+="]
["Insert rows","CtrlShift+","⌘⇧+","Ctrl+Shift++","Cmd+Shift++","Cmd+Shift+="]
["Insert columns","CtrlShift+","⌘⇧+","Ctrl+Shift++","Cmd+Shift++","Cmd+Shift+="]
["Display Delete dialog box","Ctrl-","⌘-","Ctrl+-","Cmd+-"]
["Delete rows","Ctrl-","⌘-","Ctrl+-","Cmd+-"]
["Delete columns","Ctrl-","⌘-","Ctrl+-","Cmd+-"]
["Delete cells","Ctrl-","⌘-","Ctrl+-","Cmd+-"]
["Delete contents of selected cells","Delete","FnDelete","Delete","Fn+Delete"]
["Hide columns","Ctrl0","⌃0","Ctrl+0","Ctrl+0"]
["Hide rows","Ctrl9","⌃9","Ctrl+9","Ctrl+9"]
["Unhide rows","CtrlShift(","⌃⇧(","Ctrl+Shift+(","Ctrl+Shift+(","Ctrl+Shift+9"]
["Unhide columns","CtrlShift)","⌃⇧)","Ctrl+Shift+)","Ctrl+Shift+)","Ctrl+Shift+0"]
["Group rows or columns","AltShift→","⌘⇧K","Alt+Shift+→","Cmd+Shift+K","Cmd+Shift+k"]
["Ungroup rows or columns","AltShift←","⌘⇧J","Alt+Shift+←","Cmd+Shift+J","Cmd+Shift+j"]
["Open Group Dialog Box","AltShift→","⌘⇧K","Alt+Shift+→","Cmd+Shift+K","Cmd+Shift+k"]
["Open Ungroup Dialog Box","AltShift←","⌘⇧J","Alt+Shift+←","Cmd+Shift+J","Cmd+Shift+j"]
["Hide or show outline symbols","Ctrl8","⌃8","Ctrl+8","Ctrl+8"]
["Zoom in","CtrlAlt+","⌥⌘+","Ctrl+Alt++","Option+Cmd++"]
["Zoom out","CtrlAlt-","⌥⌘-","Ctrl+Alt+-","Option+Cmd+-"]
["Zoom scroll","Ctrlscroll","^scroll","Ctrl+scroll","^scroll"]
["Select entire pivot table","CtrlA","⌘A","Ctrl+A","Cmd+A"]
["Toggle pivot table field checkbox","Space","Space","Space","Space"]
["Group pivot table items","AltShift→","⌘⇧K","Alt+Shift+→","Cmd+Shift+K","Cmd+Shift+k"]
["Ungroup pivot table items","AltShift←","⌘⇧J","Alt+Shift+←","Cmd+Shift+J","Cmd+Shift+j"]
["Hide pivot table item","Ctrl-","Ctrl-","Ctrl+-","Ctrl-"]
["Create pivot chart on same worksheet","AltF1","","Alt+F1",""]
["Create pivot chart on new worksheet","F11","FnF11","F11","Fn+F11"]
["Open pivot table wizard","AltDP","⌘⌥P","Alt+DP","Cmd+Option+P"]
["Insert new worksheet","ShiftF11","Fn⇧F11","Shift+F11","Fn+Shift+F11"]
["Go to next worksheet","CtrlPgDn","Fn⌃↓","Ctrl+PgDn","Fn+Ctrl+↓"]
["Go to previous worksheet","CtrlPgUp","Fn⌃↑","Ctrl+PgUp","Fn+Ctrl+↑"]
["Move to next pane","F6","FnF6","F6","Fn+F6"]
["Move to previous pane","ShiftF6","Fn⇧F6","Shift+F6","Fn+Shift+F6"]
["Go to next workbook","CtrlTab","⌘`","Ctrl+Tab","Cmd+`"]
["Go to previous workbook","CtrlShiftTab","⌘⇧`","Ctrl+Shift+Tab","Cmd+Shift+`"]
["Minimize current workbook window","CtrlF9","⌘M","Ctrl+F9","Cmd+M"]
["Maximize current workbook window","CtrlF10","Fn⌃F10","Ctrl+F10","Fn+Ctrl+F10"]
["Select adjacent worksheets","ShiftClick","⇧Click","Shift+Click","Shift+Click"]
["Select non-adjacent worksheets","CtrlClick","⌘Click","Ctrl+Click","Cmd+Click"]
["Toggle scroll lock","ScrLk","Fn⇧F14","ScrLk","Fn+Shift+F14"]
["Toggle full screen","CtrlShiftF1","⌃⌘F","Ctrl+Shift+F1","Ctrl+Cmd+F"]
["Move to next control","Tab","Tab","Tab","Tab"]
["Move to previous control","ShiftTab","⇧Tab","Shift+Tab","Shift+Tab"]
["Move to next tab","CtrlTab","⌃Tab","Ctrl+Tab","Ctrl+Tab"]
["Move to previous tab","CtrlShiftTab","⌃⇧Tab","Ctrl+Shift+Tab","Ctrl+Shift+Tab"]
["Accept and apply","Enter","Return","Enter","Return"]
["Check and uncheck box","Space","Space","Space","Space"]
["Cancel and close the dialog box","Esc","Esc","Esc","Esc"]
["Check spelling","F7","FnF7","F7","Fn+F7"]
["Open Thesaurus dialog box","ShiftF7","Fn⇧F7","Shift+F7","Fn+Shift+F7"]
["Open Macro dialog box","AltF8","Fn⌥F8","Alt+F8","Fn+Option+F8"]
["Open VBA Editor","AltF11","Fn⌥F11","Alt+F11","Fn+Option+F11"]
["Duplicate object","CtrlD","⌘D","Ctrl+D","Cmd+D"]
["Snap to grid","Alt","⌘","Alt+","Cmd+"]
["Hide or show objects","Ctrl6","⌃6","Ctrl+6","Ctrl+6"]
["Display Modify Cell Style dialog box","Alt'","⌘⇧L","Alt+'","Cmd+Shift+L","Cmd+Shift+l"]
["Display right-click menu","ShiftF10","Fn⇧F10","Shift+F10","Fn+Shift+F10"]
["Insert or edit note","ShiftF2","Fn⇧F2","Shift+F2","Fn+Shift+F2"]
["Insert threaded comment","CtrlShiftF2","Fn⌘⇧F2","Ctrl+Shift+F2","Fn+Cmd+Shift+F2"]
["Delete comment","ShiftF10D","Fn⇧F10","Shift+F10D","Fn+Shift+F10"]
["Display control menu","AltSpace","","Alt+Space",""]
["New Name","CtrlAltF3","⌃L","Ctrl+Alt+F3","Ctrl+L"]

{"sheet":"Link Format Exceptions","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Sheets to not change","Export Exception","Import Exception"]
["Change",false,false]
["FinStat",true,true]
["FS",true,true]
["FS Qtr",true,true]
["FS Qtr P90",true,true]
["FSAnn",true,true]
["InpC",true,true]
["InpS",true,true]
["InpS_M",true,true]
["Tmp",true,true]

{"sheet":"Capitalised Word Exceptions","index":5,"n_rows":44,"n_cols":1,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Words to not change"]
["AEP"]
["BEG"]
["CHF"]
["COD"]
["DSCR"]
["DSRA"]
["EBIT"]
["EBITDA"]
["EBL"]
["EGR"]
["EGRs"]
["EPC"]
["FC"]
["GBP"]
["GWh to kWh conversion"]
["IBRD"]
["IEP"]
["IEPs"]
["IFRIC"]
["IFRIC12"]
["IFRS"]
["IRR"]
["LC"]
["LLCR"]
["LNTP"]
["MIGA"]
["MMRA"]
["NPV"]
["O&M"]
["P50"]
["P75"]
["P90"]
["PCOD"]
["POS"]
["PPA"]
["PPI"]
["SHL"]
["SPV"]
["TPN"]
["US PPI"]
["USD"]
["VAT"]
["WHT"]

{"sheet":"Languages","index":6,"n_rows":113,"n_cols":4,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
["ISO639","name","nativeName","dir"]
[null,"(automatic)"]
["en","English","English","ltr"]
["de","German","Deutsch","ltr"]
["es","Spanish","Español","ltr"]
["fr","French","Français","ltr"]
["af","Afrikaans","Afrikaans","ltr"]
["am","Amharic","አማርኛ","ltr"]
["ar","Arabic","العربية","rtl"]
["as","Assamese","অসমীয়া","ltr"]
["az","Azerbaijani","Azərbaycan","ltr"]
["ba","Bashkir","Bashkir","ltr"]
["bg","Bulgarian","Български","ltr"]
["bn","Bangla","বাংলা","ltr"]
["bo","Tibetan","བོད་སྐད་","ltr"]
["bs","Bosnian","Bosnian","ltr"]
["ca","Catalan","Català","ltr"]
["cs","Czech","Čeština","ltr"]
["cy","Welsh","Cymraeg","ltr"]
["da","Danish","Dansk","ltr"]
["dv","Divehi","ދިވެހިބަސް","rtl"]
["el","Greek","Ελληνικά","ltr"]
["et","Estonian","Eesti","ltr"]
["eu","Basque","Euskara","ltr"]
["fa","Persian","فارسی","rtl"]
["fi","Finnish","Suomi","ltr"]
["fil","Filipino","Filipino","ltr"]
["fj","Fijian","Na Vosa Vakaviti","ltr"]
["fo","Faroese","Føroyskt","ltr"]
["fr-CA","French (Canada)","Français (Canada)","ltr"]
["ga","Irish","Gaeilge","ltr"]
["gl","Galician","Galego","ltr"]
["gu","Gujarati","ગુજરાતી","ltr"]
["he","Hebrew","עברית","rtl"]
["hi","Hindi","हिन्दी","ltr"]
["hr","Croatian","Hrvatski","ltr"]
["hsb","Upper Sorbian","Hornjoserbšćina","ltr"]
["ht","Haitian Creole","Haitian Creole","ltr"]
["hu","Hungarian","Magyar","ltr"]
["hy","Armenian","Հայերեն","ltr"]
["id","Indonesian","Indonesia","ltr"]
["ikt","Inuinnaqtun","Inuinnaqtun","ltr"]
["is","Icelandic","Íslenska","ltr"]
["it","Italian","Italiano","ltr"]
["iu","Inuktitut","ᐃᓄᒃᑎᑐᑦ","ltr"]
["iu-Latn","Inuktitut (Latin)","Inuktitut (Latin)","ltr"]
["ja","Japanese","日本語","ltr"]
["ka","Georgian","ქართული","ltr"]
["kk","Kazakh","Қазақ Тілі","ltr"]
["km","Khmer","ខ្មែរ","ltr"]
["kmr","Kurdish (Northern)","Kurdî (Bakur)","ltr"]
["kn","Kannada","ಕನ್ನಡ","ltr"]
["ko","Korean","한국어","ltr"]
["ku","Kurdish (Central)","Kurdî (Navîn)","rtl"]
["ky","Kyrgyz","Кыргызча","ltr"]
["lo","Lao","ລາວ","ltr"]
["lt","Lithuanian","Lietuvių","ltr"]
["lv","Latvian","Latviešu","ltr"]
["lzh","Chinese (Literary)","中文 (文言文)","ltr"]
["mg","Malagasy","Malagasy","ltr"]
["mi","Māori","Te Reo Māori","ltr"]
["mk","Macedonian","Македонски","ltr"]
["ml","Malayalam","മലയാളം","ltr"]
["mn-Cyrl","Mongolian (Cyrillic)","Mongolian (Cyrillic)","ltr"]
["mn-Mong","Mongolian (Traditional)","ᠮᠣᠩᠭᠣᠯ ᠬᠡᠯᠡ","ltr"]
["mr","Marathi","मराठी","ltr"]
["ms","Malay","Melayu","ltr"]
["mt","Maltese","Malti","ltr"]
["mww","Hmong Daw","Hmong Daw","ltr"]
["my","Myanmar (Burmese)","မြန်မာ","ltr"]
["nb","Norwegian","Norsk Bokmål","ltr"]
["ne","Nepali","नेपाली","ltr"]
["nl","Dutch","Nederlands","ltr"]
["or","Odia","ଓଡ଼ିଆ","ltr"]
["otq","Querétaro Otomi","Hñähñu","ltr"]
["pa","Punjabi","ਪੰਜਾਬੀ","ltr"]
["pl","Polish","Polski","ltr"]
["prs","Dari","دری","rtl"]
["ps","Pashto","پښتو","rtl"]
["pt","Portuguese (Brazil)","Português (Brasil)","ltr"]
["pt-PT","Portuguese (Portugal)","Português (Portugal)","ltr"]
["ro","Romanian","Română","ltr"]
["ru","Russian","Русский","ltr"]
["sk","Slovak","Slovenčina","ltr"]
["sl","Slovenian","Slovenščina","ltr"]
["sm","Samoan","Gagana Sāmoa","ltr"]
["so","Somali","Soomaali","ltr"]
["sq","Albanian","Shqip","ltr"]
["sr-Cyrl","Serbian (Cyrillic)","Српски (ћирилица)","ltr"]
["sr-Latn","Serbian (Latin)","Srpski (latinica)","ltr"]
["sv","Swedish","Svenska","ltr"]
["sw","Swahili","Kiswahili","ltr"]
["ta","Tamil","தமிழ்","ltr"]
["te","Telugu","తెలుగు","ltr"]
["th","Thai","ไทย","ltr"]
["ti","Tigrinya","ትግር","ltr"]
["tk","Turkmen","Türkmen Dili","ltr"]
["tlh-Latn","Klingon (Latin)","Klingon (Latin)","ltr"]
["tlh-Piqd","Klingon (pIqaD)","Klingon (pIqaD)","ltr"]
["to","Tongan","Lea Fakatonga","ltr"]
["tr","Turkish","Türkçe","ltr"]
["tt","Tatar","Татар","ltr"]
["ty","Tahitian","Reo Tahiti","ltr"]
["ug","Uyghur","ئۇيغۇرچە","rtl"]
["uk","Ukrainian","Українська","ltr"]
["ur","Urdu","اردو","rtl"]
["uz","Uzbek (Latin)","Uzbek (Latin)","ltr"]
["vi","Vietnamese","Tiếng Việt","ltr"]
["yua","Yucatec Maya","Yucatec Maya","ltr"]
["yue","Cantonese (Traditional)","粵語 (繁體)","ltr"]
["zh-Hans","Chinese Simplified","中文 (简体)","ltr"]
["zh-Hant","Chinese Traditional","繁體中文 (繁體)","ltr"]
["zu","Zulu","Isi-Zulu","ltr"]