Forum home » Delegate support and help forum » Microsoft Excel Training and help » visual+basic+for+excel+courses+london - Absolute referencing

	98.1 % recommend us
	More live stats...

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

Training information:

visual+basic+for+excel+courses+london - Absolute referencing

Resolved · Low Priority · Version Standard

Reply Thu 1 Nov 2007, 15:45Delegate Jj said...

Jj has attended:
Excel Introduction course

Absolute referencing

how do i set the cells to be fixed when i copy and paste cells containing formula or function?

For upcoming training course dates see: Pricing & availability

Reply Fri 2 Nov 2007, 10:25Trainer Katie said...

RE: absolute referencing

Hi JJ,

Thanks for your question.

Absolute Referencing is represented by a $ symbol. You can use [F4] key to rotate to your preferred format.

An example of using an absolute reference:
Cell A1 =

Excel articles

· Flexible uses for Excel at Home
· Excel: Survival Of The Fittest
· Mastering Page Layout In Excel
· How To Embed Fonts In Excel
· Conditional Formatting: A Useful Feature Of Excel

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy