The files in this repo contains MS Office scripts that I have developped over time to improve my efficiency in working with the MS Office suite.
- Open the visual basic editor by pressing Alt + F11
- In the project window, expand the Personal.xlsx file
- Copy the content of the Excel scripts file and paste in to the Code Editor
- Now you can access these scripts using the "Macros" button within any workbook.
| Cannot use (Excel Already uses it) | |
|---|---|
| Toggle Filters | L |
| Fonts tab | P |
| expand collapse formula bar | U |
| Opens the Font dialog box to change the font | F |
| Insert cells | + |
| Delete Cells | - |
| Creates names by using the labels of the selected rows and columns. | F3 |
| Switches between all Excel windows. | F6 |
| Prints the active sheet. | F12 |
| Paste as values | V |
| My Macros | |
| Fmt_Alignmnet_E | E |
| Fmt_CenterAcrossSeIection_M | M |
| Fmt_AIIGreyBorders_C | C |
| Fmt_CycleBorders_B | B |
| Fmt_CycleCellStyle_T | T |
| Fmt_CycleFill_X | X |
| Fmt_CycleFontCoIor_F | F |
| Fmt_NumberFormat N | N |
| Fmt_DecimalDecrease K | K |
| Fmt_Decimallncrease J | J |
| Fmt_AutoColorSeIection_A | A |
| Fmt_CurrentSheetNoGridZoom70_G | G |
| Fmt_CustomSuffix_H | H |
| Fmt_WrapText_W | W |
| Sht_insertwithName_I | I |
| Tool_PasteValues_V (Redundant) | V (Redundant) |
| Tool_copyAcross_R | R |
| Tool_copyDown_D | D |
Sources:
https://www.youtube.com/user/ExcelIsFun