Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 28 - 2632_CodeMind
P. 28

    The exclamation point separates the worksheet portion of the reference from the cell portion.
                     Other Workbook References

                     You can use cell references to access cells in other workbooks in a similar manner as you would refer
                     to cells in different worksheets within the same workbook. These references are called external
                     references.

                     For example, to enter a reference to Book2 in Book1, follow the given steps:
                     Step 1   Create two workbooks named Book1 and Book2.

                     Step 2   Select cell A1 in Sheet1 of Book1, and type an equal (=) sign.
                     Step 3    Switch  to  Book2  by  pressing  the  Alt+Tab  keys  on  the  keyboard.  Click  to  select
                               cell A2.

                     Step 4   Press the Enter key.
                               After you press the Enter key, your formula in Book1, Cell A1, should be
                               = [Book2] Sheet1! $A$2.

                     This reference has 3 parts:
                     1.  The workbook Book2 in square brackets.

                     2.  The worksheet Sheet1 followed by ! sign.
                     3.  The cell having absolute reference.
                     Hence,  referencing  cells  in  the  external  workbooks  is  done  by  selecting  the  workbook,  then  the
                     worksheet, and then the cell you want to link reference to.

                     Customise Worksheet Tab

                     To customise the worksheet tab, follow the given steps:

                                                                                      2  Click on  the  Rename to
                                                                                     rename  the  sheet,  or  Tab
                                                                                     Color to select a tab colour.

                                                                                       3  Type in the name or
                                                                                      select a colour you would
                                                                                      like for your sheet.

                         1  Right-click
                        the sheet tab
                        that you want
                        to customise.

                     The name or colour of the sheet will be changed.
                     You can also use the Insert, Delete, and Move or Copy options to add a new sheet, delete a sheet,
                     and move or copy a sheet, respectively.

                                                                                  Formulas and Functions in Excel  27

| 23 24 25 26 27 28 29 30 31 32 33 |