March 6, 2014

Access Cell in Different Excel Worksheet

How to access cell in different Excel worksheet
How to reference or access a cell in another worksheet:
1. If the sheet name is simple like ‘income’ then you can access the cells in this worksheet
by writing =income!Cell-address
2. If the worksheet name consists of multiple words with spaces like ‘Profit And Loss’ then you must enclose the name in single quotes like ‘Profit And Tax’ followed by an exclamation mark and then the cell address =’Profit And Loss’!Cell Address to access the cell.

Further reading:
How to reference formulas and data on other worksheets

One thought on “Access Cell in Different Excel Worksheet

Comments are closed.