Posts Tagged ‘Excel Cell’

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

[ad#post-link]

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.

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.

And enter 3 inside the cell

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

Enter 2 in the cell

Now move to another cell and enter this simple formula

=First+Last

You will see the result 5

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

Go to Tools menu and click Options

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

And click OK.

[ad#post-link]

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

Dave

Ms Excel Tips and Tricks Hide or Unhide Excel workbook

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

[ad#post-link]

• 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

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

Read more about Microsoft excel tips and tricks from our website

[ad#post-link]