customizing
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Customizing

Customizing

resolvedResolved · Low Priority · Version 2003

replyReply Tue 10 Jun 2008, 17:02Delegate Nicole said...

Nicole has attended:
Excel Intermediate course
Outlook Advanced course
Excel Advanced course
Powerpoint Intermediate Advanced course

Customizing

Please can I have a little more information on customizing and on absolute cells and linking formulars. Thanks

For upcoming training course dates see: Pricing & availability

replyReply Thu 10 Jul 2008, 09:46Trainer Mark said...

RE: Customizing

Hi Nicole

How are you doing, im so sorry i haven't got back to you sooner as i have been so busy

As for your question the absolute cell references have to functions, which are the dollar signs mean remember and follow

so that means if you move the cell to another location excel will always locate this so that your formulas will still work

the other element about dollar signs is you can use the F4 function key to insert them and the more times you press the F4 button you can move the position of the dollar signs

Hope this helps

Please feel free to reply to this post, or mark this resolved, or email me back

On mark

Thanks

Mark East

MOUS Master Instructor

 

Please browse our web site to find out more about
excel vba course london and other Microsoft training courses.

Excel tip:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard