Posts in MS Office Tips

Microsoft Excel Tips: How to calculate the number of days, months or years between two dates

How Tos MS Office Tips Tips & Tricks

One of the fundamental questions that Excel users may find themselves asking is “How to calculate the number of years, months, or days between two given dates?” This article will show the ways or methods in calculating days, months or years between 2 given dates. There are certain situations when you want to know the number of days, months or years. For instance, in computing rentals or amortizations, in comparing usage or consumption, and many other scenarios, knowing how to calculate the days, months and even years will be vital…. Read More

Microsoft Excel Tip: How to lock cells and make them un-editable

How Tos MS Office Tips Tips & Tricks

There are certain times and conditions when you feel the need that other people can only edit or add and modify data from selected cells in your Excel sheet. The rest of the cells in the sheet or workbook must be un-editable. Example of these Excel sheets are survey questionnaires wherein other people can just input their answers but not alter the questions. Others can be a fillable form wherein other people can just enter their personal or other information but the form content and layout are locked for editing…. Read More

Microsoft Excel: How to apply conditional formatting to a cell based on values of another cells or range?

How Tos MS Office Tips Tips & Tricks

There are times in our spread sheet that we need to format the cells or cell range based on certain conditions. These conditions however pertain to the contents of the cells that you are to format. This is when Conditional Formatting is very useful. For instance, format the cell range G5:G50 if the values in the individual cells is less than 70%. If you are a teacher calculating the students grade in Excel and you want to automatically color the final grade with dark red if they are faling grades, like below… Read More

Microsoft Excel: The imaginary cell borders are gone. How to show them back?

How Tos MS Office Tips Tips & Tricks

We are used to seeing cells in MS Excel with a light gray borders. These are called “grid lines”. They are just there as a default behavior of MS Excel to provide visual boundaries among cells. These grid lines are NOT actually being printed by default, they are just visual aide to users to visually see the boundaries between cells. When your Excel settings are messed up and you end up with just a plain white worksheets without those cell boundaries or grid lines, here are the steps to show… Read More

Microsoft Excel: How to Send Excel Workbook as Email Attachment

How Tos MS Office Tips Tips & Tricks

If you are using MS Excel 2007, 2010 or the newer versions from the date of this writing, now you can send your Excel file as an email attachment using the commands found in Excel menus. This is the “Send As Attachment” command in Excel 2010. What this menu command does is actually simple. When you open your workbook in Excel and this workbook is intended to be sent to someone through email, you can click on the Send As Attachment button and then Excel will invoke or launch your… Read More

Microsoft Excel Power Shortcuts: Converting cell formulas to values

How Tos MS Office Tips Tips & Tricks

Microsoft Excel 2010, like its older version (2003 or 2007) are packed with huge sets of features and shortcuts waiting to be uncovered. In this article, we will discover how to copy the values of a cell excluding the formulas. Normally, when you copy the cells containing a formula, the formula is copied automatically and the cell references are updated dynamically. This is a very essential feature of Excel. Since the formula is being copied and the cell references in the formula are updated, the cells will then show up… Read More

Excel 2007/2010 Glitch: All Files Now Open as Blank

How Tos MS Office Tips Tips & Tricks

If you have been using Excel 2010 or 2007 for some time, you might have encountered this Excel problem scenario. If not, watch out since you may encounter it any time. The problem is, out of the blue, all the Excel files now open as blank. How to resolve this glitch? This is indeed a glitch of some sort since their are no specific setting changes that cause the problem to occur. Also, this happens to few people only using the same version of MS Excel. If you are troubled… Read More

Microsoft Excel: How to extract the “Month”, Day or Year in a DATE entry in a cell?

How Tos MS Office Tips Tips & Tricks

Suppose you are working in an Excel sheet containing cells with dates. Depending on your actual requirement, one of the things that you might want to do is to extract the day, month, or even the year in a date entry in an Excel cell. For instance, your cell A1 contains the date June 7, 2013. It could have been entered as 6/7/2013 but the cell was format to show the date in a long pattern. But as long as Excel recognizes the data as a DATE, then it stores… Read More

Excel 2003/2007/2010/2013: Copying a row and pasting in column and vice versa

How Tos MS Office Tips Tips & Tricks

When working with huge amount of data in Excel, there will always come a time that you want to copy the contents of a row and paste it in a column, or vice versa. Have you had such encounter before? Suppose your summary report lists years downwards, or in a column. But then your boss requires the years are listed across, that is, in a row. If there are just few years in the report, it will be just easy to re-type them manually. However, if the report has years… Read More