Ribbon Menu¶
Loading EGTools++ adds an EGTools++ tab to the ribbon. Feature buttons are organised into groups; new groups will be added as more features arrive.
Group: Visible Cells¶
Copying and pasting under filters/hidden rows (two split buttons: Copy = Copy Visible Cells / Paste = Paste Values). Details: Visible Cells
| Menu item | Description |
|---|---|
| Copy Visible Cells | Remember only the visible cells of the selection as the copy source and copy them to the clipboard |
| Copy Range | Remember the entire selection (hidden cells included) as the copy source |
| Paste Values | Paste the remembered source into the target's visible cells only, as values |
| Paste Formulas | Paste into the visible cells only, as formulas |
| Paste All | Paste values, formulas and formats into the visible cells only |
Group: Merge/Unmerge Cells¶
Features for working with merged cells (two split buttons: Merge = Merge Contents Only / Unmerge = Split to Rows Only). Details: Merge/Unmerge Cells
| Menu item | Description |
|---|---|
| Merge Same Values | Merge vertical runs of equal values (hierarchical across columns) |
| Merge Keeping Values | Merge in appearance only, keeping every value — formulas and filters keep working |
| Merge Same Values Keeping | Visually merge each run of equal values while keeping the values |
| Merge Contents Only/with Style | Merge the area into one cell, joining contents with separator/line breaks (with Style keeps character formatting) |
| Merge Rows Only/with Style | Make each row one merged cell, joining its contents |
| Merge Columns Only/with Style | Make each column one merged cell, joining contents with line breaks |
| Unmerge and Fill | Unmerge cells and fill the merged value back in (formulas become values) |
| Split to Rows Only/with Style | Split merged-cell text at line breaks into rows (inserting rows as needed) |
| Split to Columns Only/with Style | Split merged-cell text at a separator into columns (inserting columns as needed) |
Group: Image/Picture¶
Inserts, aligns and extracts images on cells (two split buttons: Image = Insert Image / Fit = Fit Selected). Details: Image/Picture
| Menu item | Description |
|---|---|
| Insert Image | Pick an image file and insert it fitted to the selection |
| Insert by Name | Find the folder image matching each cell value and insert it into that cell |
| Insert into Form | Clone the form and insert the folder's images at the {{}} placeholders in order |
| Fit Selected | Fit the selected pictures to their top-left cells |
| Fit All | Fit every picture on the sheet to its cell in one pass |
| Export All | Save every picture on the sheet to a folder at original quality |
Group: Calendar¶
Builds calendar/schedule sheets (two split buttons: Calendar = Monthly / Schedule = Daily B). Details: Calendar
| Menu item | Description |
|---|---|
| Monthly | Monthly calendar sheet (week numbers, holidays, lunar dates) |
| Annual A | Annual calendar, portrait (3×4) |
| Annual B | Annual calendar, landscape (4×3) |
| Weekly | Weekly schedule (Sun–Sat, 08:00–21:00 time axis) |
| Daily A | Daily schedule, two panes (carries over unfinished tasks) |
| Daily B | Daily schedule, three panes (carries over unfinished tasks) |
Group: Forms¶
Fills a form with a data list, repeatedly (split button, default = Make Labels). Details: Forms
| Menu item | Description |
|---|---|
| Make Labels | Clone the form per data row, substituting {{fieldname}} with values |
| Mail Merge | Clone the form sheet per data row into individual sheets/files (xlsx/PDF), print each and/or send email (file attached) |
Group: Utilities¶
Frequently used helpers (split button, default = Clear Errors). Details: Utilities
| Menu item | Description |
|---|---|
| Delete Styles | Batch-delete custom cell styles (choose to keep built-in / in-use ones) |
| Delete Names | Delete defined names with broken references or hidden names |
| Clear Errors | Wrap erroring formulas with IFERROR so errors disappear |
| Clear Empty Text | Turn zero-length-string cells into truly empty cells |
| Arrange Notes | Move every note next to its cell and auto-size it |
| Change Border Colors | Change all border colors in the selection (line styles kept) |
| Draw Free Form | Create a freeform shape tracing the outline of the colored cells |
| Freeze UDF Values | Replace EGTools formulas with values, keeping the formula in a note (for sharing) |
| Apply CheckBox | Cell format showing 0/1 input as ✅/⬜ |
| Recalculate All | Force a full recalculation of all open workbooks |
Group: EGTools¶
A split button collecting batch function-name conversion, SMTP settings, API key management and add-in information (default = About EGTools++).
| Menu item | Description |
|---|---|
| Apply Legacy Compatibility | Batch-convert modern/native (_xlfn.*) function tokens to EGTools-compatible names |
| Restore Native Functions | Batch-restore EGTools function names to native built-ins |
| List/Array Cells to Text | Read Microsoft 365 beta list/array cells (#UNKNOWN! in older Excel) from the saved file and convert them to comma-separated / {…} array text |
| SMTP Settings | Register the SMTP server for mail-merge sending (password never stored) |
| Manage API Keys | Register/remove public-API keys (juso · data.go.kr · vworld — the data.go.kr key is shared by holidays, calendars and business-registration lookups) |
| About EGTools++ | Shows version, distribution page and base libraries; notifies with a link when a newer GitHub Release is available |
The new-version check also runs automatically once when the ribbon loads after Excel starts; if a newer release exists, a notification dialog with a link to the distribution page is shown (once per session).
Cell Right-Click Menu¶
Besides the ribbon, items are also added to the cell context menu. Details: Cell Right-Click Menu
| Item | Description |
|---|---|
| Date Picker | Pop up a calendar next to the cell and enter the clicked date |
| Open URL | Open the http/https URL found in the cell in the default browser |
Insert Tab CheckBox¶
An Apply CheckBox button is also added to Excel's
Insert tab. It is not shown on Microsoft 365, which has native checkboxes.
Home Tab Alignment Group¶
The default Alignment group on Excel's Home tab is replaced with an identical layout plus a
Center Across Selection button below the merge button (a toggle that applies/clears the
horizontal alignment without merging cells). If Excel's merge dropdown already has the native
"Center Across Selection" item (Microsoft 365 Insider channel), the default group is left as is.
Details: Home Tab Alignment Group