{"id":411,"date":"2018-06-28T08:58:05","date_gmt":"2018-06-28T08:58:05","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=411"},"modified":"2024-03-30T11:00:58","modified_gmt":"2024-03-30T11:00:58","slug":"naming-cells-and-ranges","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/naming-cells-and-ranges\/","title":{"rendered":"Naming Cells and Ranges in Excel"},"content":{"rendered":"\n
When you work with worksheets, you will often type cell addresses that reference to a particular cell or a range of cells (for example, Sheet2!A3:D5<\/strong>). In Excel, you can name those cells to better describe their contents. For example, it is easier to understand the notation.<\/p>\n\n\n\n than<\/p>\n\n\n\n Look at the table below. There are names of three persons and the number of hours they worked each day of the week.<\/p>\n\n\n\n=SUM(cost)\/month<\/pre>\n\n\n\n
=SUM(B3:B14)\/D5<\/pre>\n\n\n\n
Naming cells<\/h2>\n\n\n\n