EXCEL SHORTCUT KEYS

-
Hello guys, welcome back to AVERAGETALKS. Today I am going to share some useful shortcuts keys for MS-Excel with you. As you know MS excel is the most widely used and popular spreadsheet tool which is used by most of the business enterprises and educational institutions. Excel provides lot of functions and operations which can be used in daily task. But some time, it can be time consuming because of large entries of data. In this scenario, here comes excel shortcut keys which can be very useful and time saving. So, here are some shortcut keys for all you lazy folks out there:-



       Shortcut Keys                                          Function 

Ctrl+ASelect all contents of a worksheet.
Ctrl+BBold all cells in the highlighted section.
Ctrl+DFill Content of the selected cell on top to bottom. CTRL + D (i.e. Ctrl+ Down)
Ctrl+FSearch current sheet.
Ctrl+GGo to a certain area.
Ctrl+HFind and replace.
Ctrl+IPuts italics on all cells in the highlighted section.
Ctrl+KInserts a hyperlink.
Ctrl+PPrint the current sheet.
Ctrl+RFill Right.
Ctrl+SSaves the open worksheet.
Ctrl+UUnderlines all cells in the highlighted section.
Ctrl+VPastes everything copied onto the clipboard.
Ctrl+WCloses the current workbook.
Ctrl+XCuts all cells within the highlighted section.
Ctrl+YRepeats the last entry.
Ctrl+ZUndo the last action.
Ctrl+1Changes the format of the selected cells.
Ctrl+2Bolds all cells in the highlighted section.
Ctrl+3Puts italics all cells in the highlighted section.
Ctrl+4Underlines all cells in highlighted section.
Ctrl+5Puts a strikethrough all cells in the highlighted section.
Ctrl+6Shows or hides objects.
Ctrl+7Shows or hides the toolbar.
Ctrl+8Toggles the outline symbols.
Ctrl+9Hides rows.
Ctrl+0Hides 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+EnterFills the selected cells with the current entry.
Ctrl+SpacebarSelects the entire column.
Ctrl+Shift+SpacebarSelects the entire worksheet.
Ctrl+HomeMove to cell A1.
Ctrl+EndMove to last cell on worksheet.
Ctrl+TabMove between Two or more open Excel files.
Ctrl+Shift+TabActivates the previous workbook.
Ctrl+Shift+AInserts argument names into a formula.
Ctrl+Shift+FOpens the drop-down menu for fonts.
Ctrl+Shift+OSelects all of the cells that contain comments.

Shift+InsertPastes what is stored on the clipboard.
Shift+Page UpIn a single column, highlights all cells above that which are selected.
Shift+Page DownIn a single column, highlights all cells above that which are selected.
Shift+HomeHighlights all text to the left of the cursor.
Shift+EndHighlights all text to the right of the cursor.
Shift+Up ArrowExtends the highlighted area up one cell.
Shift+Down ArrowExtends the highlighted area down one cell.
Shift+Left ArrowExtends the highlighted area left one character.
Shift +Right ArrowExtends the highlighted area right one character.
Alt+TabCycles through applications.
Alt+SpacebarOpens the system menu.
Alt+BackpspaceUndo.
Alt+EnterWhile 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.
F1Opens the Help menu.
F2Edits the selected cell.
F3After a name has been created, F3 will paste names.
F4Repeats 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.
F5Goes to a specific cell. For example, C6.
F6Move to the next pane.
F7Spell check selected text or document.
F8Enters Extend Mode.
F9Recalculates every workbook.
F10Activates the menu bar.
F11Creates a chart from selected data.
F12Save as.
Shift+F1Opens the “What’s This?” window.
Shift+F2Allows the user to edit a cell comment.
Shift+F3Opens the Excel formula window.
Shift+F5Brings up a search box.
Shift+F6Move to previous pane.
Shift+F8Add to selection.
Shift+F9Performs calculate function on activesheet.
Ctrl+F3Open Excel Name Manager.
Ctrl+F4Closes current Window.
Ctrl+F5Restores window size.
Ctrl+F6Next workbook.
Ctrl+Shift+F6Previous workbook.
Ctrl+F7Moves the window.
Ctrl+F8Resizes the window.
Ctrl+F9Minimize current window.
Ctrl+F10Maximize currently selected window.
Ctrl+F11Inserts a macro sheet.
Ctrl+F12Opens a file.
Ctrl+Shift+F3Creates names by using those of either row or column labels.
Ctrl+Shift+F6Moves to the previous worksheet window.
Ctrl+Shift+F12Prints the current worksheet.
Alt+F1Inserts a chart.
Alt+F2Save as.
Alt+F4Exits Excel.
Alt+F8Opens the macro dialog box.
Alt+F11Opens the Visual Basic editor.
Alt+Shift+F1Creates a new worksheet.
Alt+Shift+F2Saves the current worksheet.

Comments

Post a Comment

Popular posts from this blog

THE BORING PHONE!!!

-
Image
Smartphones industries is growing rapidly. Smartphone companies are busy in giving tough competition to each others.  they want their users to use more and more of their products or upgrading  to their latest products.and here comes a new smartphone company who wants their users to "less use their phone". Nowadays, people are spending more and more time with their phones, which causes lack of other activities such as outdoor sports, socializing, or reading a book. Kids are often exposed to internet, social media and other video sharing platforms such as YouTube at a very early stage resulting lack of mental and social growth of  child  and teenagers are getting very much attracted towards social media without even realising their actual use which can results in tensions and depression. You come home after a long and tired day, but then also you get emails on your phone from work which can exhaust you. So, from all these aspects came the idea of "THE BORING PHONE"
Read more

YouTube Vanced - Advance and Free YouTube

-
Image
YouTube has gain popularity over the period and yet it's popularity is increasing day by day. People just love watching YouTube as it is available on almost all digital devices including your phone, laptop and TV etc. But sometimes watching videos on YouTube can be irritating due to Ads . Ads are the primary business model of YouTube and you can't just skip through them easily. But what if there is a way to do so. Yes, you heard it right you can advance your YouTube watching experience with the help of an App called " YouTube Vanced". It function same as the original YouTube app but without those irritating ads and with more customized features. The app comes with lots of advance features such as background play, PIP mode, Download option (only for selected Videos) and many more features. The only con of this application is that you cannot login to your google account directly but you have to install a plugin app " Microg". Just install  the
Read more

Outgoing Calls are now not free for JIO users!!!

-
Image
Yes,you heard it right. Reliance Jio has published a notice on its official website  for every JIO user regarding outgoing calling charges. As per the notice users now  have to pay 6 paise per minute for every outgoing call which is made to a non Jio user. According to JIO, these charges are mandatory as per TRAI's rules. However these charges are in effect since 2017. Previously Jio was paying these charges from their own pocket, as they were the new player in the market. But now Reliance Jio has decided to charge these fees from their users. Now, you need to buy an additional top up voucher for outgoing calls to non jio users. However your existing jio plans will remain active.  Read the Official statement from Reliance Jio... Source-  Click here
Read more