Page 39 - Excle-En-V3

3- go to the Name box on the formula bar, type ‘A1:C4’, and click Enter

4- Figure 35: select the entire worksheet
5- To select the entire worksheet, click the Select All mark

Figure 36: Select a table or list

4.4 - Change Cell name:

Each cell has a name, defined by a letter and then a number. The name appears
in the Name Box next to the formula bar at the top of the worksheet. To change the
name of a cell or an entire range, select the cell or range of cells, click on the Name
box, and type the new name.

Figure 37: Naming cell or range of cells

The range can also be named by selecting the range, then from the Formulas tab,
from the Defined Names group, choose the (Define Name) command, type the new
name, and click OK

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