Microsoft Excel Tutorials, Help, Forum, and more

Search TeachExcel

Featured Excel Content

Link to a Location Within the Spreadsheet in Excel

How to make clickable links within Excel that point to other locations within the same spreadsheet. This allows you to quickly navigate through large spreadsheets. You can create a title worksheet and include links from there to any other worksheet and specific cells within the worksheet. Right-click the cell where you want the link to appear and ...

View Excel Tip

Highlight and Sort the Top and Bottom Performers in a List in Excel

How to highlight the rows of the top and bottom performers in a list of data. This allows you to quickly identify who or what is performing well and performing badly. In addition, you will learn how to sort this data so it appears next to each other so you can clearly see and compare the differences. Sections: Highlight Top and Bottom Performers S ...

View Excel Tip

Increment a Date By X Days for Each Row in Excel

How to quickly increment a date by a certain number of days for each entry. Type the first date in a cell. Make sure that it's in a format that Excel recognizes as a date, such as in my example. Go to the next cell under that and enter the next date that you would like to appear. Select both cells: Put your mouse over the bottom right of the black ...

View Excel Tip

Prevent Images and Shapes from Resizing or Moving in Excel

How to stop Images and Shapes from resizing in Excel when you change the size of rows and columns. This will allow you to keep the dimensions of your images and shapes while allowing them to move with the spreadsheet when you change its size, or to freeze them in place. Steps to Prevent Images and Shapes from Changing Size or Moving Right-click the ...

View Excel Tip

NOT Function - Change False to True and True to False in Excel

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 ...

View Excel Tip

Determine if Cells Contain a Specific Value in Excel

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 ...

View Excel Tip

Remove All Hyperlinks Quickly in Excel

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 ...

View Excel Tip

Add Formatting to Comments in Excel

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. ...

View Excel Tip

Break out of or Exit Different Types of Loops in VBA Macros in Excel

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 ...

View Excel Tip

Password Protect Excel VBA Macros

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 ...

View Excel Tip

Search TeachExcel

New Excel Help Service!

Featured Excel Content