Page 76 - Excle-En-V3

Figure 105: Insert a link in Excel

Figure 106

A dialog box appears as follows to select the file or write the site address in the

title, then OK, so the word appears in blue with a line under it, such as opening the
Google site, and when you click on it, the site opens in the browser.

Figure 106: Dialog box Insert hyperlink

14.3- Data Validation
Through this option, you can control the content of a specific cell. For example,

we allow the cell to accept only a date, time, whole number, decimal, text with a
number of specific letters, a dropdown list that contains several choices, or the
traditional choice, which set the cell to accept any value written inside. This is done
through:

1- Select the cell to verify its content.
2- Select "data" tab.
3- Choose data validation by clicking on this icon
4- Choose the validation criteria you would like to be applied.

68 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024