Tag Archives: Excel 2016

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 »

[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 »