Excel technical Computer information : Microsoft Excel shortcut keys

*Shortcut*	*Description*
`Tab`	*Move to the next cell, to the right of the currently selected cell.*
*`Ctrl`+`A`*	*Select all contents of a worksheet.*
*`Ctrl`+`B`*	*Bold all cells in the highlighted section.*
*`Ctrl`+`C`*	*Copy all cells in the highlighted section.*
*`Ctrl`+`D`*	Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press `Ctrl`+`Shift`+Down arrow to select multiple cells. Then press `Ctrl`+`D` to fill them with the contents of the original cell.
*`Ctrl`+`F`*	*Search current sheet.*
*`Ctrl`+`G`*	*Go to a certain area.*
*`Ctrl`+`H`*	*Find and replace.*
*`Ctrl`+`I`*	*Puts italics on all cells in the highlighted section.*
*`Ctrl`+`K`*	*Inserts a hyperlink.*
*`Ctrl`+`L`*	*Opens the Create Table dialog box.*
*`Ctrl`+`N`*	*Creates a new workbook.*
*`Ctrl`+`O`*	*Opens a workbook.*
*`Ctrl`+`P`*	*Print the current sheet.*
*`Ctrl`+`R`*	Fill right. Fills the cell to the right with the contents of the selected cell. To fill more than one cell, select the source cell and press `Ctrl`+`Shift`+Right arrow to select multiple cells. Then press `Ctrl`+`R` to fill them with the contents of the original cell.
*`Ctrl`+`S`*	*Saves the open worksheet.*
*`Ctrl`+`T`*	*Open the Create Table dialog box.*
*`Ctrl`+`U`*	*Underlines all cells in the highlighted section.*
*`Ctrl`+`V`*	*Pastes everything copied onto the clipboard.*
*`Ctrl`+`W`*	*Closes the current workbook.*
*`Ctrl`+`X`*	*Cuts all cells in the highlighted section.*
*`Ctrl`+`Y`*	*Repeats the last entry (redo).*
*`Ctrl`+`Z`*	*Undo the last action.*
*`Ctrl`+`1`*	*Changes the format of the selected cells.*
*`Ctrl`+`2`*	*Bolds all cells in the highlighted section.*
*`Ctrl`+`3`*	*Puts italics all cells in the highlighted section.*
*`Ctrl`+`4`*	*Underlines all cells in highlighted section.*
*`Ctrl`+`5`*	*Puts a strikethrough all cells in the highlighted section.*
*`Ctrl`+`6`*	*Shows or hides objects.*
*`Ctrl`+`7`*	*Shows or hides the toolbar.*
*`Ctrl`+`8`*	*Toggles the outline symbols.*
*`Ctrl`+`9`*	*Hides rows.*
*`Ctrl`+`0`*	*Hides columns.*
*`Ctrl`+`Shift`+`:`*	*Enters the current time.*
*`Ctrl`+`;`*	*Enters the current date.*
*`Ctrl`+`*	*Changes between displaying cell values or formulas in the worksheet.*
*`Ctrl`+`'`*	*Copies a formula from the cell above.*
*`Ctrl`+`Shift`+`"`*	*Copies value from cell above.*
*`Ctrl`+`-`*	*Deletes the selected column or row.*
*`Ctrl`+`Shift`+`=`*	*Inserts a new column or row.*
*`Ctrl`+`Shift`+`~`*	*Switches between showing Excel formulas or their values in cells.*
*`Ctrl`+`Shift`+`@`*	*Applies time formatting.*
*`Ctrl`+`Shift`+`!`*	*Applies comma formatting.*
*`Ctrl`+`Shift`+`$`*	*Applies currency formatting.*
*`Ctrl`+`Shift`+`#`*	*Applies date formatting.*
*`Ctrl`+`Shift`+`%`*	*Applies percentage formatting.*
*`Ctrl`+`Shift`+`^`*	*Applies exponential formatting.*
**`Ctrl`+`Shift`+``***	*Selects the current region around the active cell.*
*`Ctrl`+`Shift`+`&`*	*Places border around selected cells.*
*`Ctrl`+`Shift`+`_`*	*Removes a border.*
*`Ctrl`+`+`*	*Insert.*
*`Ctrl`+`-`*	*Delete contents of the currently-active cell.*
*`Ctrl`+`Shift`+`(`*	*Unhide rows.*
*`Ctrl`+`Shift`+`)`*	*Unhide columns.*
*`Ctrl`+`/`*	*Selects the array containing the active cell.*
*`Ctrl`+`\`*	*Selects the cells with a static value or don’t match the formula in the active cell.*
*`Ctrl`+`[`*	*Selects all cells referenced by formulas in the highlighted section.*
*`Ctrl`+`]`*	*Selects cells that contain formulas that reference the active cell.*
*`Ctrl`+`Shift`+`{`*	*Selects all cells directly or indirectly referenced by formulas in the highlighted section.*
*`Ctrl`+`Shift`+`}`*	*Selects cells which contain formulas that directly or indirectly reference the active cell.*
*`Ctrl`+`Shift`+`\|` (pipe)*	*Selects the cells within a column that don’t match the formula or static value in the active cell.*
*`Ctrl`+`Enter`*	*Fills the selected cells with the current entry.*
*`Ctrl`+`Spacebar`*	*Selects the entire column.*
*`Ctrl`+`Shift`+`Spacebar`*	*Selects the entire worksheet.*
*`Ctrl`+`Home`*	*Move to cell A1.*
*`Ctrl`+`End`*	*Move to last cell with text on the worksheet.*
*`Ctrl`+`Tab`*	*Move between Two or more open Excel files.*
*`Ctrl`+`Shift`+`Tab`*	*Activates the previous workbook.*
*`Ctrl`+`Shift`+`A`*	*Inserts argument names into a formula.*
*`Ctrl`+`Shift`+`F`*	*Opens the drop-down menu for fonts.*
*`Ctrl`+`Shift`+`O`*	*Selects all of the cells that contain comments.*
*`Ctrl`+`Shift`+`P`*	*Opens the drop-down menu for point size.*
*`Shift`+`Insert`*	*Pastes what is stored on the clipboard.*
*`Shift`+`Page Up`*	*In a single column, highlights all cells above that are selected.*
*`Shift`+`Page Down`*	*In a single column, highlights all cells above that are selected.*
*`Shift`+`Home`*	*Highlights all text to the left of the cursor.*
*`Shift`+`End`*	*Highlights all text to the right of the cursor.*
*`Shift`+Up Arrow*	*Extends the highlighted area up one cell.*
*`Shift`+Down Arrow*	*Extends the highlighted area down one cell.*
*`Shift`+Left Arrow*	*Extends the highlighted area left one character.*
*`Shift`+Right Arrow*	*Extends the highlighted area right one character.*
*`Alt`+`Tab`*	*Cycles through applications.*
*`Alt`+`Spacebar`*	*Opens the system menu.*
*`Alt`+`Backspace`*	*Undo.*
*`Alt`+`Enter`*	*While typing text in a cell, pressing `Alt`+`Enter` moves to the next line, allowing for multiple lines of text in one cell.*
*`Alt`+`=`*	*Creates a formula to sum all of the above cells.*
*`Alt`+`'`*	*Allows formatting on a dialog box.*
`F1`	*Opens the help menu.*
`F2`	*Edits the selected cell.*
`F3`	*After a name is created, `F3` pastes names.*
`F4`	*Repeats last action. For example, if you changed the color of text in another cell, pressing `F4` changes the text in cell to the same color.*
`F5`	*Goes to a specific cell. For example, C6.*
`F6`	*Move to the next pane.*
`F7`	*Spell check selected text or document.*
`F8`	*Enters Extend Mode.*
`F9`	*Recalculates every workbook.*
`F10`	*Activates the menu bar.*
`F11`	*Creates a chart from selected data.*
`F12`	*Save As option.*
*`Shift`+`F1`*	*Opens the "What's This?" window.*
*`Shift`+`F2`*	*Allows the user to edit a cell comment.*
*`Shift`+`F3`*	*Opens the Excel formula window.*
*`Shift`+`F5`*	*Brings up a search box.*
*`Shift`+`F6`*	*Move to previous pane.*
*`Shift`+`F8`*	*Add to selection.*
*`Shift`+`F9`*	*Performs calculate function on active sheet.*
*`Ctrl`+`F3`*	*Open Excel Name Manager.*
*`Ctrl`+`F4`*	*Closes current window.*
*`Ctrl`+`F5`*	*Restores window size.*
*`Ctrl`+`F6`*	*Next workbook.*
*`Ctrl`+`Shift`+`F6`*	*Previous workbook.*
*`Ctrl`+`F7`*	*Moves the window.*
*`Ctrl`+`F8`*	*Resizes the window.*
*`Ctrl`+`F9`*	*Minimize current window.*
*`Ctrl`+`F10`*	*Maximize currently selected window.*
*`Ctrl`+`F11`*	*Inserts a macro sheet.*
*`Ctrl`+`F12`*	*Opens a file.*
*`Ctrl`+`Shift`+`F3`*	*Creates names using those of either row or column labels.*
*`Ctrl`+`Shift`+`F6`*	*Moves to the previous worksheet window.*
*`Ctrl`+`Shift`+`F12`*	*Prints the current worksheet.*
*`Alt`+`F1`*	*Inserts a chart.*
*`Alt`+`F2`*	*Save As option.*
*`Alt`+`F4`*	*Exits Excel.*
*`Alt`+`F8`*	*Opens the macro dialog box.*
*`Alt`+`F11`*	*Opens the Visual Basic editor.*
*`Alt`+`Shift`+`F1`*	*Creates a new worksheet.*
*`Alt`+`Shift`+`F2`*	*Saves the current worksheet.*

Excel technical Computer information

बुधवार, १५ मार्च, २०२३

Microsoft Excel shortcut keys

कोणत्याही टिप्पण्‍या नाहीत:

टिप्पणी पोस्ट करा

लोकप्रिय पोस्ट

लेबल

संपर्क फॉर्म