Adding comments to your worksheet allows you to share your thoughts with other users, or to serve as a reminder for yourself. Right click the cell where you want to insert the comment, and begin typing in the box that appears. Click off the cell and you'll see a little red triangle in the upper right hand corner of the cell where you just inserted a comment. This is a visual … [Read more...]
Using Charts in Excel
There are several different types of charts found in Excel. All of which are used to display information in a way that makes it easier to interpret data. Column charts are best suited to compare distinct object levels in a vertical format. Line charts compare trends over even time periods, but are not necessarily used to show totals. Pie charts show the relative size of … [Read more...]
Calculating the End Date After a Given Number of Work Days
Often times, a project manager will be given a project's start date and the number of days it should take to complete. Considering, however, that most people work Monday through Friday, you can't simply add a certain number of days to the starting day's date to come up with your ending date, because that wouldn't take into consideration weekends and holdiays. Using the … [Read more...]
Pop Up Input Box
Ever wish you could ask someone a bunch of questions and have them entered into the appropriate cells? With this macro, you can have an input box pop up asking the user to answer a question (i.e. what is your name, what is your address, etc.). By defining the user's response with a unique name, you can have the macro populate the file for you. Use the example below as a guide. … [Read more...]
Delete Hidden Rows and Columns
Sometimes we hide certain rows or columns because we don't want the data to print, or just to get it out of the way. Other times though we simply don't want to share the data in a hidden row or column. Assuming that the data in visible cells isn't dependent on the data in hidden cells (i.e. if a formula references a hidden cell), we can use the macro below to automatically … [Read more...]