customizing

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Customizing

resolvedResolved · Low Priority · Version 2003

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

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@stl-training.co.uk

Thanks

Mark East

MOUS Master Instructor


 

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.09 secs.