Macros that make tables with the same values or tables that use merged cells easier to see and use "Effective Cells" series Equivalent and merged cell macros (version with font transparency)
EC Research Institute Co., Ltd.
About This Product
By merging tables that have the same value, splitting merged cells, and smoothly setting values, merged cells that were previously difficult or troublesome to view are now easier to view and handle. Recombination is also easy.
With the font transparency function, normal formulas and sorting are still possible, but only the appearance can be automatically set to make it easier to see, like a merged cell.
Features
■Priority can be determined even if there are merged cells both vertically and horizontally
You can choose from four types: "Vertical only", "Horizontal only", "Landscape with vertical priority", and "Vertical with horizontal priority".
■You can easily change the format
- Font, cell color, display format, borders, and layout can be set.
・It is also possible to split/combine and change the format.
・It is also possible to select the merged cells and change the format without splitting or merging them.
■You can select whether to process cells in the target range individually or in batch.
・Individual processing is performed while checking the range one by one. Batch processing can be performed all at once at high speed.
- You can use it even if there are cells you want to process and cells you don't want to process within the target range.
■Easy to incorporate into user macros
・Rather than using an add-in, we purposely adopted a method where information is entered directly on the sheet.
- Setting parameters such as the sheet name and start line of the target file can be set using user-created macros.
・Moreover, the startup command is also made public, so it can be started directly from a user-created macro.
- Can be used alone or by incorporating it into a macro.
- User processing that incorporates convenient processing can be easily constructed.
- Even if there are many sheets to process or the settings change, settings and processing can be repeated. (Please refer to the help for specific startup commands and how to incorporate them into user macros.)
Especially recommended for those who:
■General users who work with sheets containing merged cells
・Meeting materials, customer materials, management materials.
・There are surprisingly many sheets that contain merged cells.
■Those who handle data tables with consecutive same values
・Tables with the same values are difficult to read.
・I want to make it easier to see, but it is difficult to use merged cells.
Please use this service if you are dissatisfied with merged cells or if you are dealing with data that has the same value.
-
Product
Macros that make tables with the same values or tables that use merged cells easier to see and use "Effective Cells" series Equivalent and merged cell macros (version with font transparency)
-
Handling Company
EC Research Institute Co., Ltd.
-
Categories
1 Models of Macros that make tables with the same values or tables that use merged cells easier to see and use "Effective Cells" series Equivalent and merged cell macros (version with font transparency)
| Product Image | Part Number | Price (excluding tax) |
|---|---|---|
|
|
Equivalence and merge cell macro (font transparency compatible version) for business use |
Available upon quote |
Customers who viewed this product also viewed
Other products of EC Research Institute Co., Ltd.
View more products of EC Research Institute Co., Ltd.
