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 |
| 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.