none

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

None

resolvedResolved · Low Priority · Version 2010

david has attended:
Excel Introduction course

None

none

RE: none

Hi David

Thanks for attending the Excel Introduction training yesterday.

If you have any questions please go to www.stl-training.co.uk and sign in with your email address and your delegate account password.

Thanks
Doug
STL

Fri 9 Sep 2016: Automatically marked as resolved.


 

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips


Server loaded in 0.06 secs.