These are the keys that are used in aur computer for the general use
INTRODUCTION FOR ALL CTRL KEYS
CTRL+( :- It is used to Unhide any hidden rows within the selection.
CTRL+) :- It is used to Unhide any hidden columns within the selection.
CTRL+& :- It is used to Applies the outline border to the selected cells.
CTRL+_ :- It is used to Removes the outline border from the selected cells.
CTRL+~ :- It is used to Applies the General number format.
CTRL+$ :- It is used to Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+% :- It is used to Applies the Percentage format with no decimal places.
CTRL+^ :- It is used to Applies the Exponential number format with two decimal places.
CTRL+# :- It is used to Applies the Date format with the day, month, and year.
CTRL+@ :- It is used to Applies the Time format with the hour and minute, and AM or PM.
CTRL+! :- It is used to Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+- :- It is used to Displays the Delete dialog box to delete the selected cells.
CTRL+* :- It is used to Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
CTRL+: :- It is used to Enters the current time.
CTRL+; :- It is used to Enters the current date.
CTRL+` :- It is used to Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+’ :- It is used to Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+” :- It is used to Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL++ :- It is used to Displays the Insert dialog box to insert blank cells.
CTRL+1 :- It is used to Displays the Format Cells dialog box.
CTRL+2 :- It is used to Applies or removes bold formatting.
CTRL+3 :- It is used to Applies or removes italic formatting.
CTRL+4 :- It is used to Applies or removes underlining.
CTRL+5 :- It is used to Applies or removes strikethrough.
CTRL+6 :- It is used to Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+7 :- It is used to Displays or hides the Standard toolbar.
CTRL+8 :- It is used to Displays or hides the outline symbols.
CTRL+9 :- It is used to Hides the selected rows.
CTRL+0 :- It is used to Hides the selected columns.
CTRL+A :- It is used to Selects the entire worksheet.
CTRL+A :- It is used to If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
CTRL+B :- It is used to Applies or removes bold formatting.
CTRL+C :- It is used to Copies the selected cells.
CTRL+C :- It is used to CTRL+C followed by another CTRL+C displays the Microsoft Office Clipboard.
CTRL+D :- It is used to 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 :- It is used to Displays the Find dialog box.
CTRL+G :- It is used to Displays the Go To dialog box.
F5 :- It is used to F5 also displays this dialog box.
CTRL+H :- It is used to Displays the Find and Replace dialog box.
CTRL+I :- It is used to Applies or removes italic formatting.
CTRL+K :- It is used to Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+L :- It is used to Displays the Create List dialog box.
CTRL+N :- It is used to Creates a new, blank file.
CTRL+O :- It is used to Displays the Open dialog box to open or find a file.
CTRL+SHIFT+O :- It is used to Selects all cells that contain comments.
CTRL+P :- It is used to Displays the Print dialog box.
CTRL+R :- It is used to 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 :- It is used to Saves the active file with its current file name, location, and file format.
CTRL+U :- It is used to Applies or removes underlining.
CTRL+V :- It is used to 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 :- It is used to Closes the selected workbook window.
CTRL+X :- It is used to Cuts the selected cells.
CTRL+Y :- It is used to Repeats the last command or action, if possible.
CTRL+Z :- It is used to Undo command to reverse the last command or to delete the last entry you typed.
CTRL+SHIFT+Z :- It is used to Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.
|
| Author: Deepak Yadav 15 Oct 2009 | Member Level: Silver Points : 1 |
Hi,
In Dot Net , There is another one with the control key called
Control+A+ K+D
It will format the code in a professional manner which could be easily checked than hassle code written by us
control+A selects all the text and Then K + D along with that arranges in the good manner
Cheers
Deepak Yadav
|
| Author: Shinu 17 Oct 2009 | Member Level: Bronze Points : 0 |
Its very usefull...
|
| Author: Prashant Swami 17 Nov 2009 | Member Level: Silver Points : 0 |
It's a great stuff.
keep it up.
|