This tool does Logical and Visual comparison between two worksheets. In a Visual comparison, it highlights the differences between two cells that are located in same place. In a Logical comparison, it present the differences between two worksheets based on same key field that is located in column A of each worksheet. See more details on Excel Compare worksheets.
Likeoffice Excel Utility Data Analysis provides information about the number of unique values in your selection (means, if you have the word “box” shown 4 times, it counts it once only), numbers of cells that appear only once and number of cells that appear more than once. Standing on one cell, is considered as choosing the whole column.
This tool generates a summary report. Based on a table with data (first row title and from second row the data), it produces in a seperate worksheet a summary information, using vlookup, countif and sumif functions. For each function, you may place up to three columns.
It highlights in a color identical cells in your selection. Each group of cells with same value will get same color. Each click will colors are changed randomly.
It will allows you to design your worksheet and then to have your designed worksheet in simple icon click. Go to the Likeoffice menu in order to set your definitions. The icon in the Excel toolbar only executes these settings.
Header style It allows you to design your header in the table and to effect it to the first row in the worksheet in one click. Go to the 'Worksheet view' and open the 'Design header' box in order to customize your header.
This utility will hide or unhide all sheets. Normally in Excel you can only unhide one hidden sheet at a time. Now you can quickly make them all visible in one step.
It removes unnecessary spaces before and after the phrase in a certain cell in the selection. It actually does the trim() function (removes spaces) on each cell in the selection.
It reverses the text in each cell in your selection. For example: "Excel" becomes "lecxE" or "Vista2007" becomes "2007atsiV". It doesn't reverse the numbers though.
It extracts Text only in each cell in your selection. It extracts text from a varying text and number strings. Cell may starts with numbers or text. For example: "NY 10050" becomes "NY" or "12a4bcd" becomes "abcd".
It extracts Numbers only in each cell in your selection. It extracts numbers from a varying text and number strings. Cell may starts with numbers or text. For example: "NY 10050" becomes "10050" or "12a4bcd" becomes "124".
It will convert the numbers in your selection to English words. For example the number "USD -342.91" will be written as: "Minus Three Hundred Forty Two Dollars And Ninety One Cents". This utility will replace the numbers in your selection with a written numbers. The default currencies are none, dollars or euro. You can also type in another currency. If a number contains more than two decimals this function will spell out the number as if it was rounded to two decimals.
It will define four types of ranges: 1) expand down to the last text or numeric entry in your column 2) expand down as many rows as there are entries 3) expand right to the last text or numeric entry in your row and 4) expand down and right as many rows as there are numeric and text entries. this range is a table.
It will do the following commands: - removes hyperlinks in each cell in the selection. - activates hyperlinks in each cell in the selection - removes pictures and shapes.
It will activate your hyperlinks in your selection. For example: if in a cell you have: 'www.likeoffice.com' then, after running it the cell will have same value with hyperlink carry this address.
Once you decided to buy Excel Utility Pro and have full access to all features you do the following: 1. Pay 2. Send us your PC Mac address through this form 3. Activate you Excel Utility with the code we will send you.
