how to link different cells to different sheets in excel for mac 2011

Link Different Cells To Different Sheets In Excel 2011 Full Pathname For
Link Different Cells To Different Sheets In Excel 2011 Update Any External

It can be a real pain when you dont have freeze panes on, and when you start to scroll down the screen you lose the headings at the top of your columns.

For example, if Im creating a personal cash flow worksheet and at the end of the month I have 4083.58 in my bank account.

I can easily link the closing balance from the end of last month to the opening balance for this month.

This saves me having to do double-entry, and it ensures the two figures are always the same.

When worksheets are linked, generally one worksheet contains a reference to data in another.

The worksheet supplying the data is called the source worksheet.

The worksheet containing the reference is termed the dependent worksheet.

There are two worksheets open, Monthly Actuals and Yearly Budget.

The worksheet Yearly Budget contains the following external reference, MonthlyActualsB6:B7.

Yearly Budget is the dependent worksheet relying on data from Monthly Actuals, and Monthly Actuals is the source worksheet, providing data for Yearly Budget.

To quickly locate linked cells check out my blog post Find, modify and break links to an Excel workbook.

Linking a range of cells The following techniques describe how to link cells from a source worksheet into a dependent worksheet.

In the source worksheet select the required cells.

Copy the selected data, e.g.

CTRL C or right-click, Copy.

Switch to the dependent worksheet and then select the upper left corner of the range where you want the linked data to appear.

To paste the link do one of the following: Right-click where you want to paste the link and then select Paste Link from the shortcut menu.

From the Home tab, in the Clipboard group click on the arrow under the Paste option and select Paste Link.

The data will be pasted as a link through to the source worksheet.

Note: using this option may use an absolute cell reference to refer to the linked cell.

If you would prefer a relative reference refer to the steps in Option 2.

Option 2: Create a link manually You can manually create a link to any cell by inserting a reference to the source data.

In the dependant worksheet select the cell to hold the linked data and then type equals ().

Switch to the source worksheetworkbook and select the cell holding the data to be linked.

Link Different Cells To Different Sheets In Excel 2011 Update Any External

Press ENTER. Hint: you may like to have all source worksheets open before saving the dependent worksheet, as this will automatically update any external references if the source worksheet is saved in a different folder.

Identifying linked cells You can easily identify where cells are linked as the link address will show in the Formula bar.

Link Different Cells To Different Sheets In Excel 2011 Full Pathname For

NorthernB9 Linking to an external workbook Full pathname for worksheetReference e.g.

C:DocumentsLink Between Worksheets.xlsxNorthernB9 Share 0 Tweet 0 Share 0 Sharyn is an expert trainer.

She became the first certified Microsoft MOUS Authorised Instructor in New Zealand.

She is endorsed by Microsoft as a qualified Microsoft Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops.

Her approach to taking the techie-speak out of technology training has placed her as a preferred supplier to many of New Zealands leading organisations.

How to freeze a row in Excel Sharyn Baines Lets look at how to freeze a row in Excel.

How To Link Different Cells To Different Sheets In Excel For Mac 2011