MS EXEL பயன்படுத்தும் போது உபயோகமுள்ள Ctrl Key குறுக்குவழிகள். (SHORTCUTS)

by நவீன் Mon Jul 12, 2010 3:56 pm

CTRL+( Unhides any hidden rows within the selection.

CTRL+) Unhides any hidden columns within the selection.

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

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

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.

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

CTRL+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
CTRL+: Enters the current time.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 active cell into the cell or the Formula Bar.CTRL+" Copies the value from the cell above the active cell into the cell or the Formula Bar.CTRL++ Displays the Insert dialog box to insert blank cells.CTRL+1 Displays the Format Cells dialog box.CTRL+2 Applies or removes bold formatting.CTRL+3 Applies or removes italic formatting.CTRL+4 Applies or removes underlining.CTRL+5 Applies or removes strikethrough.CTRL+6 Alternates between hiding objects, displaying objects, and displaying placeholders for objects.CTRL+7 Displays or hides the Standard toolbar.CTRL+8 Displays or hides the outline symbols.CTRL+9 Hides the selected rows.CTRL+0 Hides the selected columns.CTRL+A Selects the entire worksheet. CTRL+B Applies or removes bold formatting.CTRL+C Copies the selected cells. CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.CTRL+F Displays the Find dialog box.

CTRL+G Displays the Go To dialog box.

CTRL+H Displays the Find and Replace dialog box.

CTRL+I Applies or removes italic formatting.

CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

CTRL+L Displays the Create List dialog box.

CTRL+N Creates a new, blank file.

CTRL+O Displays the Open dialog box to open or find a file.

CTRL+P Displays the Print dialog box.

CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.

CTRL+S Saves the active file with its current file name, location, and file format.

CTRL+U Applies or removes underlining.

CTRL+V
Inserts the contents of the Clipboard at the insertion point and
replaces any selection. Available only after you cut or copied an
object, text, or cell contents.

CTRL+W Closes the selected workbook window.

CTRL+X Cuts the selected cells.

CTRL+Y Repeats the last command or action, if possible.

CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry you typed.