Category Archives: Excel

Getting current Date and Time in Excel 2010/2013/2016

By | November 20, 2017

There are two functions which you can use to get current Date and Time in Excel: =TODAY() and =NOW(). You can use these functions as part of a text string by putting them into TEXT function with formatting string. It’s important to note that both of those functions are automatically recalculated each time you change or open your… Read More »

[Solved] Add, Attach or Insert A File in Excel 2013/2016 in 3 Easy Steps

By | November 20, 2017

This article will show you how to easily add/attach file like PDF, Word or any other to Excel 2013/2016 spreadsheet. Go to INSERT tab Click Object button or in case of smaller Excel 2013 window or any size Excel 2016 window: Click Create from file and browse for the file. Checking Link to file will cause file not… Read More »

Solve: This value doesn’t match the data validation restrictions defined for this cell

By | June 10, 2016

When you try to input some value in a cell and you get an error message in Excel 2016: or in Excel 2013: This means that someone has set Data Validation on that cell. To view its configuration and remove if needed follow these steps: Select cell and go to Data -> Data Validation Depending on the size… Read More »

Top 5 reasons why cell displays formula instead of results in Excel

By | April 26, 2017

Below are the top 5 most common reasons why formula text is shown in cell instead of its results. They are sorted by frequency with most popular at the top. They apply to Excel 2013 and Excel 2016. No equal sign before the formula Make sure that there is an equal sign before the formula. Formula is inside… Read More »