Calculate a Loan Payment in Excel
Whether you are trying to buy a new house, looking at buying a new car or applying for MORE student loans, you have no doubt wondered what your monthly payment would be. Excel provides an easy to use formula in which you can enter the loan information, and it will calculate the monthly payment for you. Once you learn to use it, it’s actually very simple. So let’s go ahead and take a look at the PMT Formula: Read More
Create a Drop Down Menu in a Cell
I recently received an email from a reader asking how to add a hidden drop down menu inside a cell. I was unable to respond back to the reader (email address was invalid), but I thought it was a great question and wanted to add it to Excel Hints. In just a couple steps, you’ll be able to add this feature to your spreadsheet and improve the validity of many spreadsheets you create. Read More
Excel Trim Formula
How many times have you tried to import a file into Excel, only to have extra blanks all over the place in the document? Well that’s where the Trim Formula can come into play. The Trim formula is used to clean up and remove all the leading and trailing blanks as well as all but one blank in-between text that you may have in a list of cells. So now instead of going into each cell one-by-one, there is one formula to do all the work for you. Let’s take a look at the formula first (it’s a short one):
=Trim(text)
This formula is very easy to use but can make you job a whole lot easier. Let’s take a look at some of the examples now.
Website Design Change
I am currently in the process of redesigning the website, so please bare with me while I get this finished. I have been using Blogger to post the updates to the website, but have been limited in some of the things I want to do. So recently I decided to make the switch to WordPress and redesign the site in the process.
Hopefully, the changes are for the better and will make for a better reader experience. Feel free to drop some comments on what you think of the change or any other suggestions you may have.
John
** Excel Hints provides Excel Tips and Excel Help for All Levels of Experience.
Add Comments to Your Spreadsheet
Excel offers an easy way to include some documentation within the spreadsheet you are working on. A few reasons for including comments in your work may be to explain a complex formula, note possible future changes or to remind you that you have some hidden columns you might want to come back to.
Adding comments is a very simple process in Microsoft Excel. There are two easy ways to go about adding a comment.
Adding a Comment #1: Select the cell where you want to add the comment. Select the “Insert” toolbar menu and select “Comment”. A box will appear and then go and enter your comment in the bubble/box provided.
Adding a Comment #2: Select the cell where you want to add the comment. Right-click inside the cell and select “Insert Comment”. Go ahead and enter your comment in the space provided and that’s it.
After your comment has been added, you can easily identify what cells have comments attached to them by the red triagle on the right side of the cell. To Edit the commented Cell, select “Edit Comment” from your right-click menu. To delete the comment, just right-click on the cell and select “Delete Comment”.
** Excel Hints provides Excel Tips and Excel Help for All Levels of Experience.
