Search TeachExcel

New Excel Help Service!

We need your input to help create a new Live Online Excel Help service.

Please take our survey and let us know your thoughts!

Excel Survey

Have a great day!

Don


Featured Excel Content


Excel Tip
Change True to False and False to True with this simple function in Excel. To do this, we use the NOT function. Syntax =NOT(logical) ArgumentDescription Logical The value that should have its result reversed. Input TRUE and it becomes FALSE and FALSE and it becomes TRUE. You can put a cell reference, an actual value, or a logical function in for th ...
 
Excel Tip
Find if a cell or range of cells contains a specific value in Excel. This method can be used on individual cells when you want to "mark" them or to find out how many cells in a range contain that specific value. With this method, it doesn't matter where the text, number, or value is located within the cell. Sections: Find if a Value is Contained in ...
 
Excel Tip
How to quickly remove all hyperlinks or a selection of hyperlinks from Excel. This removes the link itself and any associated formatting but keeps the visible text in place. Sections: Remove Hyperlinks from Excel Remove All Hyperlinks from a Worksheet at Once Notes Remove Hyperlinks from Excel Select the cell that contains the hyperlink. Do this wi ...
 
Excel Tip
How to format the appearance of a comment and the text within it. Sections: Format Text within a Comment Format the Comments Appearance Access All Formatting and Adjustment Options for Comments Notes Format Text within a Comment Format the appearance of the text in the comment. Right-click the cell that contains the comment and click Edit Comment. ...
 
Excel Tip
How to Exit, End, or Break out of loops in Excel. This tutorial includes breaking out of While, Do, and For loops. Sections: Break out of a Do Loop Break out of a For Loop Break out of a While Loop Break out of a Loop when a Condition is Met Notes Break out of a Do Loop This will exit or break out of a Do loop, including Do While and Do Until loops ...
 
Excel Tip
How to password protect VBA code and macros in Excel so that a user cannot see the code or edit it or do anything to it at all. This allows you to safely secure your VBA code and prevent users from tampering with it or even seeing it. Steps to Password Protect VBA Code/Macros Go to the VBA Editor window by hitting Alt  + F11 Right-click the desire ...
 
Excel Tip
Simple way to open an Excel workbook using VBA and macros. Syntax Workbooks.Open ("File Path") Replace file path with the path to the file on your computer along with the full file name. Here is what it looks like in the VBA Editor window: Note: you do not always have to use the file extension of the file but it is a good practice to do so. In my ...
 
Excel Tip
How to close an Excel workbook using VBA and macros, including how to save the file before you close it or discard any changes. Sections: Selecting Which Workbook to Close Close Workbook While Saving Changes Close Workbook Without Saving Changes Let the User Decide to Save Changes or Not Notes Selecting Which Workbook to Close First, we need to tel ...
 
Excel Tip
You can change the size of the units on a chart axis, their interval, where they start, where they finish, and more. Sections: Change Vertical Axis Units Change the Horizontal Axis Notes Change Vertical Axis Units Select your chart and then go to the Layout tab and click Axes > Primary Vertical Axes and then More Primary Vertical Axis Options.. ...
 
Excel Tip
How to make the Y axis start at 0 in charts in Excel. This is a simple formatting issue. Select the Chart and go to the Layout tab (that is visible only when you select a chart). Click the Axes button and go to Primary Vertical Axis and then More Primary Vertical Axis Options... You will now be in the Format Axis window. Look to the top and next to ...
 
Excel Forum