You are here: HomeExcelTutorials

Formula to Reference Tab Name

Formula to Reference Tab Name

Price: FREE

Is there a formula that will return the tab name?
For example:
My tab name is "John"
I want cell A1 to automatically say "John" by referencing the tab name.

Visit publisher's web-site: Formula to Reference Tab Name

Category and Tags: ExcelTutorials :

Related Tutorials

Reference a Worksheet Tab in Formula

Free: Yes
Tags: Excel › Functions

How can I reference a worksheet tab in a formula, so that it always refers to the previous tab in a workbook, such as a formula in Tab 3 needs info from the same cell in Tab 2 in order to keep track of balances. When I copy and paste the spreadsheets into a new worksheet it keeps the reference that was in the original worksheet.

Excel: Copy to a new tab but keep formula references from old shee

Free: Yes
Tags: Excel ›

I have a roughly 25 rows of formulas that I need to copy to a new tab that reference numbers within the same worksheet.
How do I get these newly copied formulas within the new tab to still reference all of the information in the original tab?

Reference cell in one TAB from another using two criteria

Free: Yes
Tags: Excel › Functions

I would like to reference a cell in TAB A based on two criteria,
Where
Named_Range_Date = A1
Named_Range_Hour = B3
I need to be able to copy this formula so that I can populate a new table,

Excel: Row reference from a different tab

Free: Yes
Tags: Excel ›

I have a need to refer to the row number from a different tab.
Tab 2 cell A1 will be a variable reference (i.e. will change frequently) to a cell on a different tab.
I need cell B1 on Tab 2 to refer to cell A1 and pull the row number that cell A1 is pointing to on Tab 1
For example:
Tab 2:
Cell A1 = Tab1!N35
I need Cell B1 (on Tab 2) to refer to Cell A1 on Tab 2 BUT return the row number that cell A1 is referring to on tab 1 - namely row 35
Can this be done through any formulas or combination of formulas? I tried but no success!

Delete a tab and remove all reference to it

Free: Yes
Tags: Excel ›

I need to delete some tabs from a worksheet which contain no data. However, numerous cells in my work paper link to these tabs. Although this does not result in any change in value, since the cells are blank, deleting the tab will result in #ref errors.
Is there a way to delete a tab and also remove all reference to said tab? The tabs serve no purpose and it is bothersome that removing them would result in a lot of wasted time removing the invalid references. Any help you can offer is greatly appreciated, thank you for your assistance.

Related Applications & Scripts

Free: Yes
Tags: JavaScript › Excel AJAX Tabs

Put the content of your tabs within some divs, call a javascript function. Result? A nice looking tab view.

Free: Yes
Tags: JavaScript › Excel Drop Down Menus

Drop Down Tabs is a horizontal CSS tabs menu that supports a second level drop down menu for each of its tabs. The entire interface is rendered in plain HTML, making the script very easy to customize, plus all of its contents are search engine friendly. You can optionally set which tab should be selected by default when the page loads (ie: 1st tab, 2nd tab etc), or have the script automatically select a tab when the page loads based on a match between the current page's URL and one of the menu tabs'. If there is a match, that tab is selected.
Drop Down Tabs comes with 5 sleek examples to let you quickly pick your favourite to use on your site. Customize each example's CSS to modify the look as desired. We got you covered alright!

Tab Image Rotator

Free: No
Tags: Flash › Excel Banner Rotation

- Driven by pure AS3 menu list class, the menu can be vertical or horizontal
- XML driven content
- Support many file type: jpg, png, gif, and swf.
- Unlimited amount of news can be displayed
- Optional tiled background.
- Keyboard shortcut support, press up/down arrow key to navigate the menu.

Tab Gallery v2 Bright

Free: No
Tags: Flash › Excel Image Galleries

This is a two level Flash gallery that has support for JPG, GIF, PNG image viewing and for FLV playback. The first level is represented by the categories (tabs). The list of tabs is located at the bottom of the application. The number of tabs can be unlimited and each tab has it's corespondent in the XML file in the "category" tag. If the list of tabs is too long, a mouse sliding behavior will be enabled. The list will slide horizontally according to the mouse x position. The image used for displaying the tab has to have 95x75 px.

iTuner Sound Reference

Free: No
Tags: Mobile › Excel iPhone Sound

Replace the chord sounds with your sounds and make a tuner app for yourself!