| 1. |
Introduction
ExTools is a add-in program for Microsoft Excel (Windows). It is
designed to make your work with Excel more productive as it provides
many features that make spreadsheet editing much easier.
Features:
. Many tools and utilites that add power to Excel. They can be
accessed from the ExTools
menu and also the worksheet pop-up menu.
· “Undo” function is provided for many of the tools. (This feature
is NOT available for any other FREE Excel add-in programs)
· Extools is made up of many tools. No unnecessary tools are loaded
during Excel startup, therefore speeding the startup process. During
working, Extools will automatically manage its own memory usage. You
do not need to manually unload any tools, it will be handled
transparently in the background.
Compatibility:
Extools is designed for Excel 97, 2000, 2002 and 2003. |
| |
[Top] |
| |
|
| 2. |
Favorite Files
This tool lets you store shortcuts to your favorite files. Once a
file is added to this folder, you will be able to open it just by
double clicking the file inside the list box.
Add Files to the Favorite Files Folder
1. On the ExTools menu, click 'Favorite Files'.
2. To add a file, click the 'Add' button, and then browse for your
favorite file from the 'Select File To Add' dialog box.
Remove Files From the Favorite Files Folder
1. On the ExTools menu, click 'Favorite Files'.
2. To remove a file, click the 'Remove' button. A message box will
pop up to ask for confirmation, click the 'Yes' button to remove the
file.
Note:
Only the shortcut in the Favorite Files folder will be removed. Your
original file will not be deleted. |
| |
[Top] |
| |
|
| 3. |
Favorite Text Clips
This tool lets you store text clips for later use. Use it to save
frequently used phrases, and you will be able to insert it to a
selected cell by double clicking the clip item in the Favorite Text
Clips’ list box.
Add Text Clips
1. On the ExTools menu, click 'Favorite Text Clips'.
2. Click the 'Add button'.
Edit Text Clips
1. On the ExTools menu, click 'Favorite Text Clips'.
2. Select the text clip you want to edit and click the 'Edit'
button.
Remove Text Clips
1. On the ExTools menu, click 'Favorite Text Clips'.
2. Select the text clip and click the 'Remove' button. A message box
will pop up to ask for confirmation, click the 'Yes' button to
remove the clip. |
| |
[Top] |
| |
|
| 4. |
Delete Empty Cells In Columns
This tool will help you to delete empty cells within selected
columns. Non empty cells will be shifted up to fill in the space.
To delete empty cells :
1. Select a range. Then, on the 'ExTools -> Range' menu, click
'Delete Empty Cells In Columns'.
2. In the Delete Empty Cells dialog box, click 'Ok'. |
| |
[Top] |
| |
|
| 5. |
Transpose
Use this tool to convert a vertical range to horizontal and vice
versa.
To transpose a range :
1. Select range. Then, on the 'ExTools -> Range' menu, click
'Transpose'.
2. Select the location (first cell) for the destination of the
transposed range and click 'Ok'. |
| |
[Top] |
| |
|
| 6. |
Reverse Order
Reverses the order of cells for selected column or row. Example : 1
2 3 4 5 --> 5 4 3 2 1
To reverse a range :
1. Select a range, consisting only a single row or column. Then, on
the 'ExTools -> Range' menu, click 'Reverse Order (Flip Cells)'.
2. Click 'Ok'.
Note :
You cannot reverse a range containing more than 20,000 cells.
Therefore, ExTools will warn you if you select an entire column or
any range exceeding the max number of permitted cells. |
| |
[Top] |
| |
|
| 7. |
Check For Duplicates
This tool looks for all duplicate entries in the range you select.
Duplicate entries can be highlighted or deleted.
To check for duplicates :
1. On the 'ExTools -> Range' menu, click 'Check For Duplicates'.
2. Select the range you want to check. Select 'Highlight' or
'Delete'.
3. Click 'Apply'. |
| |
[Top] |
| |
|
| 8. |
Multiple Selection Copy
Excel allows only a single range to be copied. To copy multiple
ranges follow the steps below:
1. Select the ranges you want to copy.
2. On the 'ExTools -> Range' menu, click 'Multiple Selection Copy'.
3. Select the destination for pasting the ranges. Click 'Ok'. |
| |
[Top] |
| |
|
| 9. |
Save Selection As File
You can save a selection to a Excel, Comma delimited (CSV) or Text
file with this tool.
To save selection to a file :
1. On the 'ExTools -> Range menu', click 'Save Selection As File'.
2. Select the range you want to save.
3. Select the file type you want to save to. (Excel, Comma delimited
or Text)
4. Click 'Location' to specify a filename and select the location to
save to.
5. Click 'Save' in the Save Range As dialog box. |
| |
[Top] |
| |
|
| 10. |
Save Selection As HTML
You can save a selection to a HTML table with this tool. HTML tags
for a table representing your selection will be generated and saved
to a HTML file you specify. You can then open/view the source of
this file and copy to your HTML project for further modification.
To save selection to HTML file :
1. On the 'ExTools -> Range' menu, click 'Save Selection As HTML'.
2. Select the range you want to save.
3. Select or deselect the available Auto Detect options as needed.
4. Click 'Location' to specify a filename and select the location to
save to.
5. Click 'Save' in the Save Range As dialog box. |
| |
[Top] |
| |
|
| 11. |
Save Selection As Picture
You can save a selection as GIF, JPEG or PNG file format with this
tool. The graphics conversion filters are provided by Microsoft
Office. If in any case, you can’t save to the above picture formats,
you may have to re-install Office.
To save a selection to picture file :
1. On the 'ExTools -> Range' menu, click 'Save Selection As
Picture'.
2. Select the range you want to save.
3. Specify the file format, name and location in the Save As dialog
box. Click 'Save'. |
| |
[Top] |
| |
|
| 12. |
View
Interactively change the view settings for your worksheet with this
tool. To access this tool, on the ExTools -> Worksheet menu, click
View.
From the View dialog box, select/deselect the check boxes to toggle
the corresponding settings. Changes will be made as soon as any
check box is clicked so that you can see the result.
If you do not want the changes to take place, just click the Reset
button to restore the default settings. |
| |
[Top] |
| |
|
| 13. |
Compare Worksheets
Use this to find the differences between two worksheets from any
open workbooks. A new report workbook will be generated to list the
differences, and you can also choose to highlight the differences on
the original sheets too.
To compare two worksheets for any differences :
1. On the 'ExTools -> Worksheet' menu, click 'Compare Worksheets'.
2. From the list of worksheets, select two to compare. If you want
the differences to be highlighted, check the Highlight Differences
box.
3. Click 'Ok'. |
| |
[Top] |
| |
|
| 14. |
Create Worksheet Map
Use this to create a map that will show the content type of each
cell of the active worksheet. This map is a worksheet (new workbook)
that summarizes the data type of the cells in the active worksheet.
To create a worksheet map :
1. Activate/Select the worksheet.
2. If you want to create a map of only a certain range, select the
range now.
3. On the 'ExTools -> Worksheet' menu, click 'Create Worksheet Map'.
4. From the dialog box, select the mapping source (Range or whole
Worksheet).
5. Click 'Ok'. |
| |
[Top] |
| |
|
| 15. |
Sort Sheets
Use this to sort the worksheets in the active workbook in ascending
order.
To sort worksheets :
1. Activate/Select the workbook.
2. On the 'ExTools -> Worksheet' menu, click 'Sort Sheets'. |
| |
[Top] |
| |
|
| 16. |
Delete Empty Sheets
Sometimes you may receive files containing many empty worksheets.
Use this tool to delete all empty worksheets with a single click.
To delete empty worksheets :
1. Activate the workbook.
2. On the 'ExTools -> Worksheet' menu, click 'Delete Empty Sheets'.
Note:
Extools will check for contents in all cells and also the presence
of other objects (Shapes, Chart Objects, OLE Objects) before
deciding whether a worksheet is empty or used.
Worksheets with no cell contents but contain objects will not be
deleted. |
| |
[Top] |
| |
|
| 17. |
Hide Blank Rows/Columns At End of Sheet
Use this tool to set the scrollable area of a worksheet. You may use
it to hide all the rows below and all columns to the right of the
used area.
The scrollable (visible) area will always start from the top-left
cell (A1),
To set scrollable(visible) area :
1. On the 'ExTools -> Worksheet' menu, click 'Hide Blank
Rows/Columns At End of Sheet'.
2. Select the end cell for the scrollable(visible) range. You just
need to select a single cell.
3. Click 'Ok'.
Note:
If you want to restore the worksheet to its original condition, on
the 'ExTools -> Worksheet' menu, click 'Unhide All Hidden
Rows/Columns'. |
| |
[Top] |
| |
|
| 18. |
Unhide All Hidden Rows/Columns
All hidden rows and columns of the avtive worksheet will be unhidden
in a single click with this tool. |
| |
[Top] |
| |
|
| 19. |
Unhide All Hidden Sheets
All hidden sheets of the active worksheet will be unhidden in a
single click with this tool. |
| |
[Top] |
| |
|
| 20. |
Remove Hyperlinks on Worksheet
Use this tool to remove all hyperlinks on the active worksheet. The
original text will remain, only links will be removed.
To remove all hyperlinks:
1. Go to the 'ExTools -> Worksheet' menu, click 'Remove Hyperlinks
on Worksheet'. |
| |
[Top] |
| |
|
| 21. |
Reset Last Cell
If you delete the contents at the end (last cell) of your worksheet,
Excel may still remember it incorrectly as the last cell. To find
the last cell, press Ctrl + End on the keyboard, if Excel activates
the wrong last cell, you need to reset it.
To reset last cell :
1. Activate the worksheet.
2. On the 'ExTools -> Worksheet' menu, click 'Reset Last Cell'. |
| |
[Top] |
| |
|
| 22. |
Save And Backup
This tool will save and also create a backup copy of your workbook.
The backup copy can be created in any folder or drive you specify.
Also, by default, ‘.bak’ extension will be added to the original
file, which can be changed if necessary.
To save and backup :
1. Activate the workbook.
2. On the 'ExTools -> Workbook' menu, click 'Save And Backup'.
3. The default filename and location for the backup file will be
shown in the Backup As box, if you want to change the location,
click 'Browse' to select another folder.
4. Change the backup filename in the Backup As box if necessary.
5. Click 'Ok'. |
| |
[Top] |
| |
|
| 23. |
Close All Saved Workbooks
This tool closes all workbooks that have been saved and have no
changes. |
| |
[Top] |
| |
|
| 24. |
Close And Delete Current Workbook
With this tool, the current or active workbook will be closed and
then deleted from the hard drive. Before deleting, a message box
will be shown to ask for confirmation.
Caution:
Deleted file will not be shown in the Recycle Bin. |
| |
[Top] |
| |
|
| 25. |
Close All Workbooks Without Saving
All open workbooks will be closed without saving, therefore, all
changes will not be recorded. Before closing, a message box will be
shown to ask for confirmation.
Caution:
Files are closed without saving changes. |
| |
[Top] |
| |
|
| 26. |
List All Fonts
This tool creates a new workbook and lists all the available fonts.
Sample text in the actual fonts is provided too. |
| |
[Top] |
| |
|
| 27. |
Clear Recently Used Files List
This clears the listing of recently used files from the Excel File
menu. |
| |
[Top] |
|
|
| 28. |
Conditional Select Cells By Value
This tool will help you to select cells based on a specified
criteria.
To select cells by value :
1. On the 'ExTools -> Select' menu, click 'Conditional Select Cells
By Value'.
2. Select the range you want ExTools to check. (By clicking and
dragging the mouse on the active worksheet)
3. Choose the Condition and enter the criteria in the dialog box.
4. Click 'Ok'.
Note :
To check for text values, use the 'LIKE' condtition. Wildcard
characters can be used in the criteria you specify.
Examples of using wildcard characters :
Key in *c to select cells containing text of any length that end
with ‘c’.
Key in abc? to select cells that start with ‘abc’ and have any
alphabet as the last character.
Key in abc# to select cells that start with ‘abc’ and have any
numbers(0-9) as the last character. |
| |
[Top] |
| |
|
| 29. |
Conditional Select Cells By Format
This tool will select cells based on the specified format of a
reference cell.
To select cells by format :
1. On the 'ExTools -> Select' menu, click 'Conditional Select Cells
By Format'.
2. Select the range you want ExTools to check. (By clicking and
dragging the mouse on the active worksheet)
3. Select a single cell as the reference cell for the type of format
to check for.
4. Choose a format type to check from the dropdown list.
5. Click 'Ok'. |
| |
[Top] |
| |
|
| 30. |
Conditional Select Rows By Value
This tool will select whole rows based on the value of cells in a
reference column.
To select rows by value :
1. On the 'ExTools -> Select' menu, click 'Conditional Select Rows
By Value'.
2. Select a a range within a single column to check.
3. Choose the Condition and enter the criteria in the dialog box.
4. Click 'Ok'. |
| |
[Top] |
| |
|
| 31. |
Select Cell With Max Value
This tool selects the cell containing the maximum value within a
specified search range.
To select cell with max value :
1. On the 'ExTools -> Select' menu, click 'Select Cell With Max
Value'.
2. Select the range you want ExTools to check. (By clicking and
dragging the mouse on the active worksheet)
3. Click Ok. |
| |
[Top] |
| |
|
| 32. |
Select Cell With Min Value
This tool selects the cell containing the minimum value within a
specified search range.
To select cell with max value :
1. On the 'ExTools -> Select' menu, click 'Select Cell With Min
Value'.
2. Select the range you want ExTools to check. (By clicking and
dragging the mouse on the active worksheet)
3. Click 'Ok'. |
| |
[Top] |
| |
|
| 33. |
Select Last Cell
This cell has the highest row number and the highest column number
in the used range of a worksheet. In Excel, you can press Ctrl + End
to select the last cell, but sometimes, but sometimes Excel may not
be able to keep track of the last cell correctly. |
| |
[Top] |
| |
|
| 34. |
Select Cells With Error
This tool finds and selects all cells that contain error in the
active worksheet. |
| |
[Top] |
| |
|
| 35. |
Select Used Area
Selects the used range of the active worksheet. |
| |
[Top] |
| |
|
| 36. |
Select To Right
Extends selection from current cell to the right-most non-empty
cell. |
| |
[Top] |
| |
|
| 37. |
Select To Bottom
Extends selection from current cell to the bottom-most non-empty
cell. |
| |
[Top] |
| |
|
| 38. |
Select All Sheets
Selects all worksheets of the current workbook. |
| |
[Top] |
| |
|
| 39. |
Select All Empty Sheets
Selects all empty worksheets of the current workbook. |
| |
[Top] |
| |
|
| 40. |
Text - Case
This tool converts the case of cell contents to Upper case, Lower
case or Proper case.
To convert case :
1. On the 'ExTools' menu, click 'Text'.
2. Select the range for conversion. (By clicking and dragging the
mouse on the active worksheet)
3. Click the 'Case' tab, then select the desired type of case
conversion.
4. Click 'Apply'. |
| |
[Top] |
| |
|
| 41. |
Text - Insert
This tool inserts any specified text into selected cells which
already contain some other text. You can choose whether to insert
the text at the left, right or starting from any position of the
current cell content.
To insert text :
1. On the 'ExTools' menu, click 'Text'.
2. Select the range to be processed. (By clicking and dragging the
mouse on the active worksheet)
3. Click the 'Insert' tab.
4. Enter the text to be inserted.
5. Choose how the text will be inserted (Left, Right or Offset).
6. Click 'Apply'.
Tip:
You can also use space characters for the text to be inserted.
Note:
Text will not be inserted into empty cells. |
| |
[Top] |
| |
|
| 42. |
Text - Trim
This tool trims the cell contents of selected cells. You can choose
to trim/remove the space characters to the Left or Right of the cell
contents, remove extra spaces or remove all spaces.
Two more powerful options are available : Left and Right. Use these
to trim specified number of characters from the left or right of
cell contents.
To trim :
1. On the 'ExTools' menu, click 'Text'.
2. Select the range to be processed. (By clicking and dragging the
mouse on the active worksheet)
3. Click the 'Trim' tab.
4. Choose the Trim options.
5. Click 'Apply'. |
| |
[Top] |
| |
|
| 43. |
Text - Remove
This tool will remove any specified characters from selected cells.
Note that you can specify more than one character to be removed.
To remove :
1. On the 'ExTools' menu, click 'Text'.
2. Select the range to be processed. (By clicking and dragging the
mouse on the active worksheet)
3. Click the 'Remove' tab.
4. Enter the characters to remove.
5. Click 'Apply'. |
| |
[Top] |
| |
|
| 44. |
Text - Combine
This tool will combine the contents of adjacent columns into one
cell.
To combine :
1. On the 'ExTools' menu, click 'Text'.
2. Select the range to be processed. (By clicking and dragging the
mouse on the active worksheet)
3. Click the 'Combine' tab.
4. Choose whether to add spaces in between combined words.
5. Click 'Apply'. |
| |
[Top] |
| |
|
| 45. |
Copy Cell Formula As Is
By default, Excel will create formulas using relative referencing,
and when any formula is copied to another cell, Excel will adjust
the formula address to reflect the new cell location.
Use this tool to copy any formula to a new location without changing
the formula address.
To make exact copy of formulas :
1. On the 'ExTools -> Formula And Numbers' menu, click 'Copy Cell
Formula As Is'.
2. Select the formulas to copy. ( You can select more than one
formula, but must be within a single selection)
3. Select the location to paste to.
4. Click 'Apply'. |
| |
[Top] |
| |
|
| 46. |
Convert Formula To Constant Value
This tool will convert cells containing formulas to its current
value. The formulas in the cells will be lost.
To convert :
1. On the 'ExTools -> Formula And Numbers' menu, click 'Convert
Formula To Constant Value'.
2. Select the formulas to convert. (Multiple selection is allowed)
3. Click 'Apply'. |
| |
[Top] |
| |
|
| 47. |
Convert Between Absolute And Relative Reference
Use this tool tool to convert the reference style of your formulas.
The available reference types are Relative, Rows Relative Columns
Absolute, Rows Absolute Columns Relative and Absolute.
To convert :
1. On the 'ExTools -> Formula And Numbers' menu, click 'Convert
Between Absolute And Relative Reference'.
2. Select the formulas to convert. (Multiple selection is allowed)
3. Click 'Apply'. |
| |
[Top] |
| |
|
| 48. |
Perform Math Calculation on Selection
Use this tool to perform mathematical calculations on cells inside a
selection. The result of the calculation can be written back as
formulas or constant values.
To calculate :
1. On the 'ExTools -> Formula And Numbers' menu, click 'Perform Math
Calculation on Selection'.
2. Select the range to perform calculation.
3. Enter the formula/mathematical expression in the formula box.
4. Choose whether the results will be written back as formula or
constant value.
5. Click 'Apply'. |
| |
[Top] |
|
|
| 49. |
Unit Converter
This tool is used to convert from/to metric units.
To convert units :
1. On the 'ExTools -> Formula And Numbers' menu, click 'Unit
Converter'.
2. Select the input range. (By clicking and dragging the mouse on
the active worksheet)
3. From the Unit Category list box, select the conversion type.
4. Select From and To units.
5. Click 'Apply'. |
| |
[Top] |
| |
|
| 50. |
Round Numbers
This tool rounds numbers to specified number of decimals.
To round numbers :
1. On the 'ExTools -> Formula And Numbers' menu, click 'Round
Numbers'.
2. Select the input range. (By clicking and dragging the mouse on
the active worksheet)
3. Select the number of decimals.
4. Click 'Apply'. |
| |
[Top] |
| |
|
| 51. |
Convert Percents To Numbers
Converts numbers formatted as percents to general number format (
the percentage sign ‘%’ will also be removed).
To convert :
1. On the ExTools -> Formula And Numbers menu, click Convert
Percents To Numbers.
2. Select the input range. (By clicking and dragging the mouse on
the active worksheet)
3. Click Apply. |
| |
[Top] |
| |
|
| 52. |
Convert Numbers To Ordinals
Converts whole numbers to ordinals (Example : 1st , 2nd … ).
Fractional numbers will be rounded to whole numbers before being
converted.
To convert :
1. On the ExTools -> Formula And Numbers menu, click Convert Numbers
To Ordinals.
2. Select the input range. (By clicking and dragging the mouse on
the active worksheet)
3. Click Apply. |
| |
[Top] |
| |
|
| 53. |
Convert Numbers To Text
Converts numbers to its equivalent text/string.
To convert :
1. On the 'ExTools -> Formula And Numbers' menu, click 'Convert
Numbers To Text'.
2. Select the input range. (By clicking and dragging the mouse on
the active worksheet)
3. Click 'Apply'. |
| |
[Top] |
| |
|
| 54. |
Convert Between Roman And Arabic Numbers
Converts numbers to Roman/Arabic. Example : 9 <-> IX , 10 <-> X …
To convert :
1. On the 'ExTools -> Formula And Numbers' menu, click 'Convert
Between Roman And Arabic Numbers'.
2. Select the input range. (By clicking and dragging the mouse on
the active worksheet)
3. Select the conversion type.
4. Click 'Apply'. |
| |
[Top] |
| |
|
| 55. |
Insert Random Numbers To Selection
Inserts random numbers to cells in selection. You can specify the
minimum and maximum value of the random numbers being generated.
To insert random numbers :
1. On the 'ExTools -> Formula And Numbers' menu, click 'Insert
Random Numbers To Selection'.
2. Select the range to insert random numbers. (By clicking and
dragging the mouse on the active worksheet)
3. Specify the Min and Max value for the random numbers.
4. Click 'Apply'. |
| |
[Top] |
| |
|
| 56. |
Set Subscript/Superscript
Sets the last character of cell contents to subscript or
superscript.
To set :
1. On the 'ExTools -> Format' menu, click 'Set
Subscript/Superscript'.
2. Select the range to set. (By clicking and dragging the mouse on
the active worksheet)
3. Select Subscript or Superscript.
4. Click 'Apply'. |
| |
[Top] |
| |
|
| 57. |
Word Wrap On/Off
Toggles word wrap on and off for selected cells. |
| |
[Top] |
| |
|
| 58. |
Center Vertically
Use this tool to quickly center cell contents vertically within the
cells. |
| |
[Top] |
| |
|
| 59. |
Print Multiple Sheets
This tool allows you to select multiple sheets from any open
workbook for printing.
To print :
1. On the 'ExTools -> Print' menu, click 'Print Multiple Sheets'.
2. Select the sheets to print.
3. Click 'Ok'. |
| |
[Top] |
| |
|
| 60. |
Set File Path As Header/Footer
This tool allows you to set the full file path as the header/footer
for the sheets in the active workbook.
To set :
1. On the 'ExTools -> Print' menu, click 'Set File Path As
Header/Footer'.
2. Select the location for the header/footer.
3. Click 'Ok'. |
| |
[Top] |
| |
|
| 61. |
Number Of Days Between Two Dates
This tool calculates the number of days between any two dates you
specify.
To calculate :
1. On the 'ExTools -> Date' menu, click 'Number Of Days Between Two
Dates'.
2. Set the two dates.
3. Click 'Ok'. |
| |
[Top] |
| |
|
| 62. |
Add Days To A Date
This tool calculates the end date after adding a specified number of
days to the start date.
To calculate :
1. On the ExTools -> Date menu, click Add Days To A Date.
2. Set Start Date and number of Days To Add.
3. Click Ok. |
| |
[Top] |
| |
|
| 63. |
Calculator
This comes together with Windows. If you can’t get it to run, check
Windows installation.
Tip:
You can also launch the calculator by clicking 'Windows Start Menu
-> Run', then type 'calc' in the Run dialog box. |
| |
[Top] |
| |
|
| 64. |
Character Map
This comes together with Windows. If you can’t get it to run, check
Windows installation.
Note:
If you can't launch Character Map, go to 'Windows Start Menu ->
Control Panel -> Add or Remove Programs -> Add or Remove Windows
Components'.
You will then see Windows Components Wizard. From the list of
components, choose 'Accessories and Utilities' then click 'Details',
you will be able to choose the Windows utilities to install. |
| |
[Top] |
| |
|
| 65. |
Delete Empty Rows
Select a range and any empty rows can be deleted. Note that the
WHOLE row will be deleted if it's empty. |
| |
[Top] |
| |
|
| 66. |
Google Search
Right click on any cell containing text and click Google Search from the pop-up menu. The cell's text will be sent to Google and the search results will be displayed in a new web browser window. |
| |
[Top] |
| |
|
| 67. |
List All Filenames in Selected Folder
There is no easy way to grab actual names(in text and editable form) of all files within a folder. This tool will allow you to select a folder, then all the names of the files within the folder will be listed in a new workbook. |
| |
[Top] |
| |
|
| 68. |
Color Alternate Rows in Selection
Use this tool to alternately color the rows or a selected area. You can choose to color every other row or every 2,3,4,5... rows. Select the area, then go to Extools > Range > Color Alternate Rows in Selection
There are two methods provided:
- Normal formatting - This is same as the Fill Color tool found on Excel's tool bar. If you add or delete rows, the alternately colored rows will be out of sync and you need to reapply the alternate row coloring.
- Conditional formatting - This is same as the Conditional Formatting tool located at Excel's Format menu. Row shading will automatically readjust if you insert or delete rows. To remove the shading, you can't use Excel's Fill Color tool -- use Excel's 'Conditional Format' or Extool's 'Clear Conditional Formatting in Selection'.
|
| |
[Top] |
| |
|
| 69. |
Clear Conditional Formatting in Selection
Use this tool to remove all Conditional Formatting in selected area. Select the area, then go to Extools > Range > Clear Conditional Formatting in Selection |
| |
[Top] |
| |
|
| 70. |
Select Cells Containing Formula
Use this tool to select(find) cells containing formula. This tool is located at Extools > Select > Select Cells Containing Formula |
| |
[Top] |
| |
|
| 71. |
Custom Error Messages
Choose a range of(or one) formula and set a custom error message to be displayed, instead of the original #NULL!, #DIV/0!, #VALUE!, #REF!, #NAME?, #NUM! and #N/A error messages. ISERROR condition and your custom message are added to the selected formulas. To hide error messages, just leave the message input box blank. Run this tool by going to Extools > Formula & Numbers > Custom Error Messages
|
| |
[Top] |