If you’re planning to create an Excel sheet for others to enter data into (for example, a survey or a form), there’s a simple way to check the validity of data they enter. If users enter information in some other format, Excel will prompt them to type the correct information in each cell. For example, […]
Microsoft Excel – Prompt users to type specific data into cells
How to Add tool tips to links in Microsoft Word
You may know how to hyperlink text within documents, but Did you know you can also add tool tips to links in Microsoft Word? Tooltips are small boxes that appear when you hover your cursor over any link. You might already experience this when you visited a website or read a word document. Adding link tool-tips […]
How to protect individual cells and cell areas in Excel
I often work in Microsoft Excel and it includes many different functions and usability features that makes the things more easy and increase productivity. Yesterday, I discovered that Excel lets you lock individual cells without locking the complete worksheet. Once you lock/protect individual cells in Excel, they can no longer be modified, but the remaining […]