[Free ebook Download]MS Excel 280 Short keys: Guide Book by Junaid Ali

DOWNLOAD

Author:Junaid Ali [Ali, Junaid]
Language: eng
Format: azw3
Published: 2017-03-30T04:00:00+00:00

CTRL Combination shortcut keys

CTRL+SHIFT+Unhides any hidden rows within the select on.

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 (nega(ve numbers in parentheses).

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

CTRL+SHIFT+^ Applies the Scien(fic 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 nega(ve values.

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

In a PivotTable, it selects the en(rePivotTable report.

CTRL+SHIFT+: Enters the current (me.

CTRL+SHIFT+" Copies the value from the cell above the ac(ve cell into the cell or the Formula Bar.

CTRL+SHIFT++ Displays the Insert dialog box to insert blank cells.

CTRL+ - Displays the Delete dialog box to delete the selected cells.

CTRL+; Enters the current date.

CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet.

CTRL+' Copies a formula from the cell above the ac(ve cell into the cell or the Formula Bar

#evba #etipfree #eama #kingexcel
📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1