Tag Archives: Excel 2013

Set Units of Measurement to Inches or Centimeters in Excel 2013/2016

By | January 26, 2018

By default, Excel takes units of measurement from the system settings. Sometimes, however, these settings are not the ones we want to use in Excel. The good news is that these units can be changed in Excel settings without having to intervene in the system configuration. Here’s how to do it. On the ribbon click File tab On… Read More »

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

By | December 2, 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 | January 26, 2018

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 »