Excel Tips and Tricks Cell Label, Cell Name, Range Name


Microsoft Excel worksheets has name for each cells. They start from A1.

These are used to calculate values and for reference purposes. Having these numbers in a complex formula will be a pain. If you know these number in words it will be very easy to do the calculations.

So Go to the first cell A1

Just above that A1 cell, you have the cell reference box.

Label Cells

Type the name you want, I am typing First as a reference to cell A1. It means that there is no more A1 cell in the worksheet because we changed it to First.

Cell Names

And enter 3 inside the cell

Now move to any other cell and change the cell name/label to Last

Cell Names 1

Enter 2 in the cell

Now move to another cell and enter this simple formula


Cell Names 2

You will see the result 5

Cell Names 3

Before this formula to work, you need to change the options to accept these labels

Cell Label Options

Go to Tools menu and click Options

Under the calculations tab, Check the “Accept Labels in Formulas”

And click OK.


If you have any questions or suggestions, please post a comment.

Dave 🙂

Ms Excel Tips and Tricks Hide or Unhide Excel workbook

.. Excel Logo

  • You can hide any Microsoft excel workbook or sheets.
  • To hide a work book open the work book
  • Click Window menu
  • Click hide

Excel Hide work boox and sheets


  • The current workbook will be hidden from the view
  • When you close the MS Excel, If you have not saved the excel work book earlier, you will be prompted for the ms excel to be saved
  • You can find the Ms excel in the same folder but when you open you will not see any content
  • If you want to unhide a work book, open the MS excel and go to Windows menu and click Unhide

Excel unHide work book and sheets

  • Ms Excel will ask you which one of the hidden files that you want to open
  • Choose the file that you want to open

Excel unHide work book and sheets Confirmation

Read more about Microsoft excel tips and tricks from our website