Have you ever felt the need to assign names to data that is repeatedly used?
In my excel worksheet when I need to use certain data repeatedly I have to keep copying the data repeatedly to the cells.
For example in my road model, I have data which I need to repeat over ever sheet. For this instead of going by the conventional copy paste method, I use the naming method. In this method I name the data and call the data later using the name
For this I use the shortcut
Ctrl + F3 - Name a data value
How is this useful?
Once I have named my data, I can call the data again by giving the name. This eases my work as I don’t have to keep copying the data from another sheet.