answersLogoWhite

0

I am not sure what you are asking, since you link cells, and not tabs. But, if you want to know how to link to a cell on another worksheet, add the name of the worksheet with an apostrophe (!) before the cell name. If you want to reference cell B13 from Sheet1 on Sheet2, enter the following formula on Sheet2: =Sheet1!B13.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

When you first install excel what does excel show in the taskbar?

Three worksheet tabs (Sheet1, Sheet2, and Sheet3).


When you first install Excel Excel shows what in the taskbar.?

Three worksheet tabs (Sheet1, Sheet2, and Sheet3).


What can be dragged to change the number of worksheet tabs that are viewable at one time in a workbook in excel?

There is a divider between the worksheet tabs section and the horizontal slider section. Click and drag the divider bar to the left to reduce the space allowed to display worksheet tabs and to the right to increase the viewing area of the worksheet tabs.


How do you type in a name on the tab of an excel worksheet?

If you are asking about worksheet name tabs, just right-click on the tab and select rename.


How do you add a worksheet to Excel?

Right-click on any worksheet name tab and click Insert.Shift+F11Click on the Insert worksheet icon to the right of all the existing worksheet name tabs.


What identifies a worksheet in a workbook?

It is a sheet tab. The names of the sheets appear on sheet tabs.


What is an active work sheet?

An active sheet is the worksheet you currently are accessing.


In excel each sheet displays where at the bottom of the workbook?

This is a true statement, but not a question.


Can additional worksheets be created from a workbook in Excel that defaults three worksheets?

yes. If you right click on the bottom left cormer of excel where the tabs are, click new and select worksheet. you can do this from here.


How do you get out of group edit mode in Microsoft Excel?

Click on a worksheet that is not in the group being editted (look at the worksheet tabs for ones with darker background as lighter background indicates the group being editted).


How do you add a separate worksheet to an existing worksheet?

Rename the tabs for each worksheet to identify the data they contain, Insert a new worksheet after the first worksheet, change the color of the tabs related to each project


What allows data easy to summarize and charted in excel?

An Excel worksheet or spreadsheet allows data to be easily summed and charted.