Keyboard shortcuts for formatting cells
To do this | Press |
|---|---|
Open the Format Cells dialog box. | Ctrl+1 |
Format fonts in the Format Cells dialog box. | Ctrl+Shift+F or Ctrl+Shift+P |
Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use the arrow keys to create a reference. | F2 |
Insert a note. Open and edit a cell note. | Shift+F2 Shift+F2 |
Insert a threaded comment. Open and reply to a threaded comment. | Ctrl+Shift+F2 Ctrl+Shift+F2 |
Open the Insert dialog box to insert blank cells. | Ctrl+Shift+Plus sign (+) |
Open the Delete dialog box to delete selected cells. | Ctrl+Minus sign (-) |
Enter the current time. | Ctrl+Shift+Colon (:) |
Enter the current date. | Ctrl+Semicolon (;) |
Switch between displaying cell values or formulas in the worksheet. | Ctrl+Grave accent (`) |
Copy a formula from the cell above the active cell into the cell or the formula bar. | Ctrl+Apostrophe (') |
Move the selected cells. | Ctrl+X |
Copy the selected cells. | Ctrl+C |
Paste content at the insertion point, replacing any selection. | Ctrl+V |
Open the Paste Special dialog box. | Ctrl+Alt+V |
Italicize text or remove italic formatting. | Ctrl+I or Ctrl+3 |
Bold text or remove bold formatting. | Ctrl+B or Ctrl+2 |
Underline text or remove underline. | Ctrl+U or Ctrl+4 |
Apply or remove strikethrough formatting. | Ctrl+5 |
Switch between hiding objects, displaying objects, and displaying placeholders for objects. | Ctrl+6 |
Apply an outline border to the selected cells. | Ctrl+Shift+Ampersand sign (&) |
Remove the outline border from the selected cells. | Ctrl+Shift+Underscore (_) |
Display or hide the outline symbols. | Ctrl+8 |
Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. | Ctrl+D |
कोणत्याही टिप्पण्या नाहीत:
टिप्पणी पोस्ट करा