excel

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

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

Excel 2007

resolvedResolved · Low Priority · Version 2007

Peter has attended:
Excel Advanced course

Excel 2007

could someone provide me withe the function key shortcard list

RE: excel 2007

Dear Peter

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.


Nick who was in the same training as you also asked the same question so for convenience I am pasting the link below which you can refer to.

https://www.stl-training.co.uk/post-19529-ctrl-shortcuts.html #19529


If you have trouble remembering the shortcut keys please remember the Access key we discussed during training that is new in Office 2007. You simply have to press ALT button and then the letters that appear on the Ribbon: Tabs or the Quick Access Toolbar!!


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Mon 9 Feb 2009: Automatically marked as resolved.


 

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips


Server loaded in 0.08 secs.