The Copy and Paste functions are something we use practically every time we work with some Office document. But have you noticed that when you use the paste functionality, the Paste Options pop up menu lingers on and refuses to go away? This is quite annoying and often ends up … [Read more...] about How to Get Rid of the Paste Options Menu in Word, Excel and PPT
excel how to
How to Calculate Number of Days Between Two Dates in Excel
In a previous post, I showed you how to use the NETWORKDAYS() function in Excel to calculate the number of work days between two dates in Excel. In today’s post we’ll take a look at how you can use further Excel functions to calculate number of days between two dates in Excel. … [Read more...] about How to Calculate Number of Days Between Two Dates in Excel
How to Combine Text with a Date or Time in Excel
There is no straightforward way to enter a string of text in Excel along with a date or time. Excel simply does not allow you to combine text and dates or text and time together in the same cell. However, there is a simple workaround that makes it possible for you to do this. In … [Read more...] about How to Combine Text with a Date or Time in Excel
How to Hide Data in a Worksheet in Excel
There may be times when you want to share or view some data in an Excel worksheet, but not all of its contents. In such cases, you can hide the data from view. In this Excel tutorial, I’ll show you two ways in which to hide data in a worksheet in Excel 2016. … [Read more...] about How to Hide Data in a Worksheet in Excel
How to Calculate the Age of a Person in Excel
If you’re working with a lot of employee data and need to create an maintain a database with the employee’s ages, automatically updated every year, you can make use the the functions in Excel to do it. For this purpose all you need is the year of their birth or their date of … [Read more...] about How to Calculate the Age of a Person in Excel