Excel Shortcuts Tips And Tricks – Excel 100 Most Useful Shortcut Keys: Get the list of 100 most useful shortcut keys that you should learn to master Microsoft Excel in no time.
Excel 100 Most Useful Shortcut Keys: All over the world, Microsoft Excel is used to analyze a wide range of data. It is one of the data analytics tools in the market that is used by large companies, small firms, school and college students and other users. Data in Excel is mainly in the form of rows and columns. This tool is often used to record and analyze data, perform mathematical operations and visualize structured data in charts and graphs. The reason behind its popularity is that it has many built-in features that make it easier for users to organize their data. Marvel Comic Character Do you know who was Marvel’s first superhero? Who is Ms. Marvel? Know About The First Asian Female Marvel Superhero Microsoft Excel 100 Most Useful Shortcut Keys While using Excel, you will get many keyboard shortcuts that will help increase your efficiency and productivity. Instead of accessing the toolbar with a mouse, you can perform significant functions with two or three keystrokes. Here is a comprehensive list of the most useful Microsoft Excel keyboard shortcuts that can help you become a spreadsheet master: Microsoft Excel Worksheet Keyboard Shortcuts Ctrl + N To create a new workbook. Ctrl + O To open a saved workbook. Ctrl + S To save a workbook. Ctrl + A To select all the contents of a workbook. Ctrl + B To make highlighted cells bold. Ctrl + C To copy cells that are highlighted. Ctrl + D To fill the selected cell with the contents of the cell immediately above. Ctrl + F To search for anything in a workbook. Ctrl + G To jump to a specific area with a single command. Ctrl + H To find and replace cell contents. Ctrl + I To italicize cell contents. Ctrl + K To insert a hyperlink in a cell. Ctrl + L To open the create table dialog box. Ctrl + P To print a workbook. Ctrl + R To fill the selected cell with the contents of the cell to the left. Ctrl + U To underline highlighted cells. Ctrl + V To paste everything that was copied. Ctrl + W To close the current workbook. Ctrl + Z To undo the last action. Ctrl + 1 To format the cell contents. Ctrl + 5 To put strikethrough in a cell. Ctrl + 8 To display the outline symbols. Ctrl + 9 To hide a row. Ctrl + 0 To hide a column. Ctrl + Shift + : To enter the current time in a cell. Ctrl + ; To enter the current date in a cell. Ctrl + ` To change the view from showing cell values to formulas. Ctrl + ‘ To copy the formula from the cell above. Ctrl + – To delete columns or rows. Ctrl + Shift + = To insert columns and rows. Ctrl + Shift + ~ To switch between showing Excel formulas or their values in the cell. Ctrl + Shift + @ To apply time formatting. Ctrl + Shift + ! To apply comma formatting. Ctrl + Shift + $ To apply currency formatting. Ctrl + Shift + # To apply date formatting. Ctrl + Shift + % To apply percentage formatting. Ctrl + Shift + & To place borders around the selected cells. Ctrl + Shift + _ To remove a border. Ctrl + – To delete a selected row or column. Ctrl + Space To select an entire column. Ctrl + Shift + Space To select an entire workbook. Ctrl + Home To redirect to cell A1. Ctrl + Shift + Tab To switch to the previous workbook. Ctrl + Shift + F To open the font menu under format cells. Ctrl + Shift + O To select the cells containing comments. Ctrl + Drag To drag and copy a cell or to a duplicate worksheet. Ctrl + Shift + Drag To drag and paste copy. Ctrl + Up Arrow To go to the top cell in a current column. Ctrl + Down Arrow To jump to the last cell in a current column. Ctrl + Right Arrow To go to the last cell in a selected row. Ctrl + Left Arrow To jump back to the first cell in a selected row. Ctrl + End To go to the last cell in a workbook. Alt + Page Down To move the screen to the right. Alt + Page Up To move the screen to the left. Ctrl + F2 To open the preview window. Ctrl + F1 To expand or collapse the ribbon. All To open the access keys. Tab Move to next cell. Alt + F + T To open the options. Alt + Down Arrow To enable filters for cells. F2 To edit a cell. F3 To paste a cell name if the cells have been named. Shift + F2 To add or edit a cell comment. Alt + H + H To select a fill color. Alt + H + B To add a border. Ctrl + 9 To hide the selected rows. Ctrl + 0 To hide the selected columns. Esc To cancel an entry. Enter To complete the entry in a cell and go to the next. Shift + Right Arrow To expand the cell selection to the right. Shift + Left Arrow To expand the cell selection to the left. Shift + Space To select the entire row. Page Up/Down To move the screen up or down. Alt + H To go to the Home tab of the Ribbon. Alt + N To go to the Insert tab in the ribbon. Alt + P To go to the Page Layout tab in the ribbon. Alt + M To go to the Formulas tab of the Ribbon. Alt + A To go to the Data tab of the Ribbon. Alt + R To go to the Review tab in the Ribbon. Alt + W To go to the View tab of the Ribbon. Alt + Y To open the Help tab in the Ribbon. Alt + Q To quickly jump to search. Alt + Enter To start a new line in a current cell. Shift + F3 To open the Insert Function dialog box. F9 To calculate workbooks. Shift + F9 To calculate an active workbook. Ctrl + Alt + F9 To force calculation of all workbooks. Ctrl + F3 To open the name manager. Ctrl + Shift + F3 To create names from values in rows and columns. Ctrl + Alt + + To zoom into a workbook. Ctrl + Alt + To zoom out in a workbook. Alt + 1 To turn on Autosave. Alt + 2 To save a workbook. Alt + F + E To export the workbook. Alt + F + Z To share your workbook. Alt + F + C To close and save the workbook. Alt or F11 To turn key hints on or off. Alt + Y + W To know what’s new in Microsoft Excel. F1 To open Microsoft Excel Help. Ctrl + F4 To close Microsoft Excel. Shortcuts make our lives easier in many ways, and if you’re a Microsoft Excel user, using the above keyboard shortcuts will definitely make your life easier while analyzing data on a spreadsheet or workbook. So try practicing these shortcuts to master Excel. Also try these brain teasers: Which direction is the bus going? What shape will be the opposite of the + in the cube? Count the number of triangles in the 5-pointed star Complete the series by identifying the missing number Identify the words inside the boxes through hidden clues. Can you move just 1 match to correct the equation? Guess which glass will be full first Identify the missing number from the matrix Oxford Challenge – Identify the identical prism. Count the number of squares on the chessboard Guess the number in the space where the car is parked in 30 seconds Which glass has more water? Guess how many holes there are in the t-shirt
Excel Shortcuts Tips And Tricks
Get the latest general knowledge and current affairs from all over India and world for all competitive exams.
The 54 Excel Shortcuts You Really Should Know
(Note: Keyboard shortcuts will work for the 2016 versions of Excel, including Mac; those were the versions tested. And many of the search options in Excel 2016’s Data tab come from the Power Query add-in for Excel 2010 and 2013. So if you have Power Query
Excel tips and tricks, excel spreadsheet tips and tricks, 101 excel tips and tricks, easy excel tips and tricks, advanced excel tips and tricks, ms excel tricks and tips, best excel tips and tricks, excel shortcuts and tricks, excel tips and shortcuts, microsoft excel tips and tricks, excel tips and tricks pdf, excel tips and tricks 2016