Wednesday, July 31, 2013

USEFULL ALL MICROSOFT EXCELL shortcut:-

CTRL+(     : Unhides any hidden rows within the selection.
CTRL+)     : Unhides any hidden columns within the selection.
CTRL+~    :Applies the General number format.
CTRL+$    :Applies the Currency format with two decimal places (negative numbers in parentheses). 
CTRL+%   :Applies the Percentage format with no decimal places.
CTRL+^    : Applies the Exponential number format with two decimal places.
CTRL+#    :Applies the Date format with the day, month, and year.
CTRL+@   : Applies the Time format with the hour and minute, and AM or PM.
CTRL+!     : Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. 

No comments:

Post a Comment