#How to link cells in excel online windows#

The first is by changing the name directly on the name box and the other one is by defining names under the Formulas menu. Naming cells in Excel can be done in two ways. If you are sharing the spreadsheet or workbook with other colleagues or business associates, using cell names that are easy for everyone to identify reduces potential confusion. For example, naming one cell вЂGrossIncomeвЂ™ and the other one вЂDeductionsвЂ™ makes it easier for you to compute net income by subtracting Deductions from GrossIncome for the result.ДЄnother benefit of naming cells is that it is easier for other users to understand. Instead of using the cellsвЂ™ column letter and row number, itвЂ™s more convenient to use a name that you can easily understand. This is also the case when creating formulas for computations. For instance, if you name a particular cell вЂTotalвЂ™, searching for this word is much faster than scrolling through the spreadsheet to find the correct cell or trying to remember its specific column and row. One of the reasons why you may want to change this name is to make it easier to find what you are looking for, especially when thereвЂ™s a lot of information in a particular spreadsheet. Why name cells in ExcelДЄs mentioned, the default name for each cell in an Excel spreadsheet is based on the relevant column and row. This name can actually be changed however. You will see this in the name box, which is located on the upper left side of the spreadsheet, next to the formula bar. Each cell in the spreadsheet has a corresponding name, which is identified by its column letter and row number.ДЇor instance, the cell under column A that belongs to row 1 has the default name A1. It is within these cells that data is entered when creating a worksheet for various functions including data management and computations, etc. Like other spreadsheet applications, Microsoft Excel documents are based on cells that can be arranged into rows and columns.

One way to make your spreadsheets easier to get around is to name the cells.

Many spreadsheets can be a challenge to navigate. Excel is specifically used for creating spreadsheets, basic databases, analyzing data, and even simplifying management.

#How to link cells in excel online windows#

Microsoft Office applications can run on almost every system businesses use, including Windows and Mac. Excel is one of the applications included in Microsoft Office, MicrosoftвЂ™s suite of office productivity software.