Time Saving Excel Shortcuts Keys For PPC

Save Time Using PPC Excel Shortcuts

CRTL + SHIFT + 4 (To printer $ sign)

CTRL + SHIFT + 5 (To printer % sign)

ALT + =  ( It sums the value )

CTRL+PgUp Switches between worksheet tabs, from left-to-right.

CTRL+PgDn Switches between worksheet tabs, from right-to-left.

CTRL+SHIFT+( Unhides any hidden rows within the selection.

CTRL+SHIFT+& Applies the outline border to the selected cells.

CTRL+SHIFT_ Removes the outline border from the selected cells.

CTRL+SHIFT+~ Applies the General number format.

CTRL+SHIFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses).

CTRL+SHIFT+% Applies the Percentage format with no decimal places.

CTRL+SHIFT+^ Applies the Scientific number format with two decimal places.

CTRL+SHIFT+# Applies the Date format with the day, month, and year.

CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM.

CTRL+SHIFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

CTRL+SHIFT+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).