Poon's Blog

I always think microsoft excel is a great tool for works. how do you think of it?

I use excel to plan,to log,to calculate,to process data...

And excel can complete jobs greatly.

And if shortcuts are used , jobs can be done double excellent!!

The following are some shortcuts i often used, hope they can help ;-)

1.Move to the previous sheet in the workbook :

CTRL+PAGE UP

Select the current and next sheet.
2.Move to the previous sheet in the workbook :

CTRL+PAGE DOWN

3. To access the menu: press

/

or

ALT

keys.
4.Do you want to highlight cells by a hot key ? you can define a MACRO.
For example: if you want to highlight many tables' header :
>Go to : tools-> macro -> record new macro...
>A message box will prompt to ask for a hot key , you can define ctrl + (somekey)
to invoke the comming macro , such as ctrl + q . (note:do use the system defined hot key e.g. ctrl + s,ctrl+a,ctrl + c... or you will get conflict . )
>Then goto the color fill panel choose the color you like .
> Ttop recording the macro.
>Test: choose the header (some cells )of a table, type ctrl + q.
Macro combines several operations into a keystroke or only a click of button : -）that's fantastic.