The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Links between pages

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Links between pages

Resolved · Medium Priority · Version 2003

ReplyWed 10 Mar 2010, 16:32Delegate Jude said...

Links between pages

could you re-cap linking between pages please

For upcoming training course dates see: Pricing & availability

ReplyThu 11 Mar 2010, 10:59Trainer Simon said...

RE: links between pages

Hi Jude,

Thank you for your question. Use a blank workbook for this example.

Select Sheet 2 cell A1 and click the equals button. Switch to Sheet 1 and select cell A1. Finally press enter to complete the formula.

So if you click into cell A1 of Sheet 2 the formula bar would read:

=Sheet1!A1

I hope this answers your question.

Regards

Simon

Wed 17 Mar 2010: Automatically marked as resolved.

Excel articles

· How Excel Can Transform All Of Your Office Documents
· How To Protect Your Work In Excel 2010
· Getting To Grips With Gantt In Excel
· How To Split A Stacked Chart In Excel
· Excel 2010 A Glance Into The Future

Please browse our web site to find out more about
excel-xp-training and other Microsoft training courses.

Excel tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips

Using The Excel Forms Toolbar To Spruce Up A Workbook

Excel is used across many areas of business and in many different ways. Whether presenting or storing data, the Forms toolbar can be used to protect and improve the data itself and create a user-friendly interface for the workbook. This article will discuss some simple ways of enhancing a workbook without needing to use VBA coding.

» Article: Excel computer training

I sent a question in a few days ago but as yet have had no reply. Please can you tell me the procedure to create a block, in a menu, to change colour when the mouse hovers over it. I have a small table of 1 column and 10 rows, each row having a title on i..

» Forum post: Dreamweaver 8, CSS/Behaviors question

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidde...