Excel Hints Redesigned

The new design for Excel Hints is now active and can be seen at the homepage. Hopefully you will find that the new design is much more user friendly and easier to read than the old design.

A few of the new features that have been added:

  • New Feedburner Feed: If you would like recieve all the updates for Excel Hints to be up-to-date with what is going on you have two options - RSS Feed or you can subscribe by email.
  • Improved Search Capability: Use the search button on the top right of the page to search for posts related to what you are searching for.
  • Improved Category Grouping: Catagories are now grouped under parent catagories to help with your navigation of the site. If you would like a list of all categories available please look at the bottom of the second column.
  • New Contact Form: Any questions you have for Excel Hints that may not belong in a comment section can be emailed directly. There is also an option to have the email copied to your email address as well.

Over the next few days, I hope to get all the old links converted over to the new design. Anyone coming through a link on a search engine may still visit the old site until they try to access the homepage as I don’t have all the redirects completed yet. Please bare with us during that transistion time.

As always, any suggestions for improvement of the site is definitely encouraged.

Looking forward to adding more Excel Information.

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

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