Microsoft Excel Useful Shortcut keys…

Shortcut
Description
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 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+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 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+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 within the highlighted section.
Ctrl+Y
Repeats the last entry.
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.
Ctrl+Shift+(
Unhide rows.
Ctrl+Shift+)
Unhide columns.
Ctrl+/
Selects the array containing the active cell.
Ctrl+\
Selects the cells that have 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 on 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+Backpspace
Undo.
Alt+Enter
While typing text in a cell, pressing Alt+Enter will move 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 has been created, F3 will paste names.
F4
Repeats last action. For example, if you changed the color of text in another cell, pressing F4 will change 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 by 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.



Comments

Post a Comment

Popular posts from this blog

Types of Networks: LAN, WAN, WLAN, MAN, SAN, PAN, EPN & VPN.

Image
there are several different types of computer networks. Computer networks can be characterized by their size as well as their purpose. The size of a network can be expressed by the geographic area they occupy and the number of computers that are part of the network. Networks can cover anything from a handful of devices within a single room to millions of devices spread across the entire globe. Some of the different networks based on size are: Personal area network, or PAN Local area network, or LAN Metropolitan area network, or MAN Wide area network, or WAN One way to categorize the different types of computer network designs is by their scope or scale. For historical reasons, the networking industry refers to nearly every type of design as some kind of  area network . Common types of area networks are: LAN -  Local Area Network WAN - Wide Area Network WLAN -  Wireless Local Area Network MAN - Metropolitan Area Ne
Read more

WHY MICROSOFT EXCEL IS IMPORTANT FOR ANALYTICAL CAREER???

Image
in our current work atmosphere, we usually come across various data. We read it, access it and work on it. Have you ever analyzed it? You didn’t need it or haven’t got the opportunity to work on. Isn’t it? Well, that’s true in most of our cases. The requirement of every analytical tool is to analyze data & extract relevant information which can lead to increase in business growth. If we talk about today, there are many ways to perform business analytics & reporting like  SAS, R, Big Data, Salesforce, SAP, SSAS, SSRS, Tableau, Qlik Sense, Machine Learning , etc. Every tool has its own uniqueness and is well used & adopted by Industry. The important point to understand is Microsoft Excel is the basis for any Analytical tool. Any big giant like McKinsey, Mu Sigma, American Express, etc. using advanced analytics ultimately works on Excel sheets for the data loading & internal communication. That’s why there is a steady increase in Excel Jobs &  Excel Training
Read more

WHY IS LISP NOT MORE POPULAR?

Image
LISP is a risky choice  for senior management. If things go wrong, no one is going to blame management for picking a popular object oriented language backed by a major corporation like Oracle or Microsoft. Its much easier to hire programmers with experience in popular, easy to learn languages. Even progressive companies willing to use a more powerful language usually don't choose LISP. This is because many of the newer languages try and compromise by borrowing powerful features from LISP, while staying easy to learn for the masses. Scala and Ruby follow this model. Bad programmers can pick them up quickly and keep writing the same mediocre code that they did in Java. Good programmers can take advantage of the more advanced features to write beautiful code. Parentheses are not the problem.  Haskell is an incredibly powerful and expressive language with a syntax similar to Python or Ruby and it hasn't been widely adopted for many of the same reasons as LISP.
Read more