Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Link updates

	98.1 % recommend us
	More live stats...

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

Training information:

Link updates

Resolved · Low Priority · Version 2007

Reply Thu 28 Jul 2011, 16:38Delegate samia said...

samia has attended:
Excel Intermediate course

Link updates

quickest way to do so

For upcoming training course dates see: Pricing & availability

Reply Fri 29 Jul 2011, 10:17Trainer Anthony said...

RE: link updates

Hi Sam, thanks for your query. Here's a useful walkthrough of updating links in Excel:

http://www.ozgrid.com/VBA/update-links.htm

Hope this helps,

Anthonya

Thu 4 Aug 2011: Automatically marked as resolved.

Excel articles

· Conditional Formatting: A Useful Feature Of Excel
· Backstage Management With Excel 2010
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· What's Better Than the Help Function in Excel? Microsoft Training
· Want To Create A Presentation In Excel?

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

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips