To get refreshed data from a Web site using Excel 97, save the site address (URL) for every new query in a text file with the extension .iqy. To sa...
To add a Comment to a formula: 1. At the end of the formula, add a + (plus) sign. 2. Type the letter N, and in parentheses, type your Comment in q...
The Watch Window (new in Excel 2002 & Excel 2003) holds important information, such as Book name, Sheet name, defined Name, Value, and Formula. Sp...
CATEGORY - Excel Information VERSION - All Microsoft Excel Versions To change the Comment shape: 1. Select the cell containing the Comment and p...
Why it is highly recommended to delete unnecessary/unneeded range Names: Large number of range Names makes it more difficult to locate a specific Nam...
Name syntax rules: The Name string must begin with a text character, not a number, and consists of adjacent characters. Two words can be joined wi...
You may have a sheet or sheets in your workbook that contains confidential information or information that you do not update that often. You can hid...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
