{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Instructions"],"not_rendered":{"charts":0,"images":6,"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":"Instructions","index":0,"n_rows":151,"n_cols":15,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
[]
["How to Install This Add-In",null,null,null,null,null,null,null,null,null,null,null,null,null,"What this Add-in Does"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1) WB Calculations ON/OFF"]
["1) Save this file as an Excel Add-in",null,null,null,null,null,null,null,null,null,null,null,null,null,"This will toggle whether calculations for the workbook are on or off."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) WS Calculations ON/OFF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will toggle calculations for the worksheet that you are currently on."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note that if workbook calculations are off, it won't matter if worksheet calculations are on, calculations will be off."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3) Very Hidden Tabs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you hide a tab in Excel by right-clicking and selecting 'Hide,' it can easily be unhidden."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Using this macro, the tabs will be hidden and can not be unhidden without using a macro."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You can unhide these tabs using this macro as well."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4) Clear Spaces"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will remove any leading, trailing, or extra spaces in a cell."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5) Replace as Values"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you have a formula in a cell, this macro will replace it as a value so that only the result will be stored, not the formula."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6a) Convert to Numbers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you have a number stored as text, this macro will convert it to a number."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6b) Convert to Text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will do the opposite of 6a and will convert a number into a text format."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6c) Flip Signs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For any numbers, this will multiply by -1 and flip positive values to negatives, and vice versa."]
[]
["Doing this will make sure that Windows saves it in the correct place and you don't have to worry about finding the add-in folder",null,null,null,null,null,null,null,null,null,null,null,null,null,"7) Remove 0s from Table"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If you have 0s in a table or a pivot table, this will remove unfilter any 0 values. This does not hide any error values."]
["2) Close this file and open a new one. Go to Excel Options (this is under File->Options in newer versions of Excel)."]
["     Then select the Add-ins section. Ensure Excel Add-ins are selected and click on Go",null,null,null,null,null,null,null,null,null,null,null,null,null,"8a) Divide by 1000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will divide the selected cells by 1,000. "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8b) Multiply by 1000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will multiply the selected cells by 1,000."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9) Concatenate Columns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will group two columns together. Simply select the columns (or cells - the selection does not have to be an entire column) and  click this  button."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10) Find Errors"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will cycle through all the error values on the current sheet, allowing you to correct them one by one."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11) Unmerge Cells"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select a merged cell and clicking this button will unmerge the cells and put the merged cell value into each of them."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12) Encrypt Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will convert your sensitive data into x's followed by a series of numbers."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13) Filter PT by Selection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instead of clicking one by one, list the items you want to filter in a pivot table and then click this button. Make sure the the first cell relates to the header name in the pivot table for this to work."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14) Change PT Formatting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will change the pivot table format that is created by default. It will repeat labels, remove subtotals, and change the format to tabular."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15a) Change Field to Comma Format"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Changes your pivot table field format to comma"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15b) Change Field to Accounting Format"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Changes your pivot table field format to accounting"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16) Filter Unique Values"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select a range of cells, and this button will pull the unique values from them."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17) Count Unique Values"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will count the number of unique values in the range you select."]
[]
["3) Select the Add-in you want to install and then click OK",null,null,null,null,null,null,null,null,null,null,null,null,null,"18) Reverse Lookup"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allows you to lookup from a list of values to see if any of the values are in the cells you selected. If there is a match, it will extract a corresponding value from your other list."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19) Compare Sheets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A quick way to compare the differences between one sheet and the other. Any differences will be highlighted."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20) Update Links"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Create a link from the url in a cell. To update a link you have to right-click on a cell and input the value into the address field. This macro will do that, and take the cell value in there."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21) Add Footer Location"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quickly add the location of your active file into your page's footer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["You should now see the tab show up in your new Excel file."]
[]
[]
[]
[]
["If you didn't close this file then you'll see the tab show up twice. That's because it shows up because it's already in the file, and the second time is because you installed the add-in."]
["However, that will only happen in this workbook. In all other files the tab should only show up once."]
[]
["How to Remove This Add-in"]
[]
["1) Get back to the Add-ins section from step 3, uncheck the Add-in, and click on OK"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The tab should now be gone."]
[]
[]
["2) If you want to delete it entirely, go back into the Add-ins section and this time click on the Browse button"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3) Delete the file"]
[]
[]
[]
[]
[]
[]
[]
["Now if you were to try and re-select the Add-in from your list it would tell you it doesn't exist, and there you can confirm that you want to remove it."]