Table of Contents
What is Microsoft Office Excel?
It is one of the most popular Microsoft Office software programs that has been used by a max of people who have small database management.
Excel is easy to use and manage your day-to-day activities towards your daily routine, Small business, Data analysis, Automate your calculation process, reporting, quotation, Calendar, Service Invoice, Project Tracker, Gantt project chart, Weekly Timesheet, Make a List, Track my task, Daily Schedule, Monthly college budgets, Online sale track, workout Log, WorkPlan Timeline, and much more. If you are new to Microsoft Excel then you can purchase or download Microsoft Office Complete Setup or you can purchase Microsoft Excel only on Microsoft Official website.
Sample Microsoft Excel Sheet
Below are some sample Microsoft Excel sheets that you can download for free.
- Workplan Timeline
- Personal monthly budget spreadsheet
- Blank daily calendar
- workout log
- Personal Inventory
- Gift Planner
Since Microsoft Excel has been used broadly by the organizer as well as personally too. We should know its shortcut keys that will help us some of the time while maintaining our Excel sheet.
Microsoft Excel Keyboard Shortcuts Keys
F2 – It is used to edit the selected cell.
F3 – It is used to paste a cell name if the cells have been named.
Shift + F2: It is used to add or edit an Excel cell comment.
Ctrl + a – Select all
Ctrl + c – Copy
Ctrl + x – Cut the selected data
Ctrl + v – Paste the copied or cut data in an Excel sheet.
Ctrl + f – To find any specific data (text, search). It will open the search box then you have to enter the text and hit enter and Excel automatically searches that term in the entire Excel sheet and give the result.
Ctrl + h – To replace any specific data or text with new data.
Ctrl + b – To make a font bold of any data.
Ctrl + i – To make the font in Italics
Ctrl + d – To fill down the cell with the above cell value.
Ctrl + u – To underline any data in the row or column
Ctrl + p – To display the print dialogue box to make further process to print.
Ctrl + r – It is used to fill the row cell to the right with the contents of the selected cell
Ctrl + s – This Excel keyboard shortcut key is used to save an Excel workbook.
Ctrl + t – It is used for displaying the create table dialogue box.
Ctrl + w – It is used to close the selected workbook in an Excel sheet.
Ctrl + y – In order to repeat the last command or action, In case there is any.
Ctrl + z – To perform undo action. It will execute the last command/action that you performed in the Excel workbook.
Ctrl + f5 – To restore Windows size in XL.
Ctrl + f3 – To open the Name Manager dialog box.
Ctrl + f6 – To jump into the next Excel workbook windows.
Ctrl + shift + f6 – To jump into the previous workbook window.
Ctrl + Shift + 4 – To apply your local currency (dollar, Rupee, etc) sign format.
Ctrl + f9 – It is used to minimize workbooks.
Ctrl + f11 – In order to open Visual Basic for Applications (VBA).
Ctrl + shift + f1 – In order to jump to the previous windows.
Ctrl + Shift + l – To apply the auto filter in the open worksheet.
Ctrl + o – To open Workbook.
Ctrl + 1 – To open the cell format dialog box.
Ctrl + 7 – To show or hide the product cell.
Ctrl + 5 – To strike out the selected cells or you may say selected rows and columns.
Ctrl + _ – To remove the outline border.
Ctrl + ‘ – To copy the value of the above cell.
Ctrl + Space – This Excel shortcut key is used to select the entire column.
Ctrl + Shift + @ – To apply the time format on the selected cell.
Ctrl + Shift + Space – This Excel shortcut key is used to select the entire Worksheet or you may say select entire rows and columns.
Ctrl + Shift + 5 – To apply the % or asterisk format in the selected cell.
Ctrl + Shift + 6 – To apply the exponential format as well as caret format.
Ctrl + Page Up/Down – To move between the open Excel Worksheet.
Ctrl + Home – This is used to go to the beginning of the open worksheet.
Ctrl + End – This shortcut key is used to go to the end of the open worksheet.
Ctrl + Alt + v – To paste the special character in the Excel sheet.
Ctrl + shift + tab – To jump to the previous workbook or active to the previous workbook in an Excel sheet.
Ctrl + Shift + Arrow – To select the cell.
Ctrl + Shift + t – It is used to convert a range into a table.
Ctrl + Shift + ; – To enter the current time based on your system time.
Ctrl + ; – To enter the current date in the form of DD-MM-YYYY.
Ctrl + Arrow – To move the end or edge of the current data region or you may say cell or column.
Ctrl + n – To create a new workbook sheet in Microsoft Office.
F4 – It is used during the implementation formula, It helps to adjust reference type, abs to a relative, or else repeat the last action.
Ctrl+;/: – In order to insert the current in your worksheet.
Ctrl + “/’ – This shortcut copies values from the cell above to the current cell.
Shift + f2 – It is used to edit a cell comment.
Alt + f8 – To open the macros in excel sheet.
Alt + +/= – To do an auto sum of selected cells and place values in the cell beneath.
Ctrl + Shift + $/4 – To do format as currency in the current cell.
Ctrl + Shift + $/7 – It applies to outline borders to selected cells.
Ctrl + Shift + !/1 – To apply comma formats in the current cell.
Ctrl + Shift + ! – To apply the number format in the selected cell. e.g.: 3.00
Ctrl + Shift + 9 – It is used to unhide the row in the open Excel worksheet.
Shift + Ctrl + f – To activate the font drop list.
Shift + Ctrl + P – To activate the font size drop-down list.
Ctrl + Shift – To remove an outline border from the selected cell.
Ctrl + Shift + F3 – In order to create names from values in the Excel rows and columns.
Ctrl + Shift + * – To select the current region around the active cell ( The cell data area is enclosed by blank rows and blank columns). In case you have PivotTable, it selects the entire PivotTable report.
Ctrl + Shift + : – To enter the current time on the selected cell.
Ctrl + Shift + “ – To copy the value from the cell above the active cell into the cell or the Formula bar.
Ctrl + Shift + = – In order to insert columns and rows in the workbook.
Ctrl + Shift + & – To apply the outline border to the selected Excel cells.
Ctrl + Shift + ~ – Used to apply general order format.
Ctrl + Shift + ^ – To apply the exponential format to the selected cell.
Ctrl + Shift + # – To apply date from in the form of DD-MM-YY. e.g: 21-Jan-24
Ctrl + Shift + $ – It is used to apply a currency format with the two decimal places ( negative numbers in parentheses).
Ctrl + Shift + % – To apply the percentage format without decimal places.
Ctrl + Shift + 0 – To unhide the column in the current Excel worksheet.
Ctrl + Shift + o – To select all the cells that have the comments.
Ctrl + 6 – It is used as an alternate between hiding objects, displaying objects, and displaying placeholders.
Ctrl + 8 – If you want to display or hide the outline symbols this key works for you.
Ctrl + 9 – To Hide the selected rows on your workbook.
Ctrl + 0 – To Hide the selected column on your workbook.
There are many more Excel keyboard shortcuts available we keep updating this list. Even you can also suggest if you have any other list so we can keep updating our list. Please comment on the missing one.
FAQs
Q. 1. What are the Excel shortcut keys?
Ans: There are many shortcut keys for excel. You can find major excel shortcut keys in this post.
Q. Can you add keyboard shortcuts to Excel?
Ans: Yes, You can create keyboard shortcuts into Excel. In order to do that you have to go under these settings. File Tab -> Quick Access Toolbar category -> Drop Down Menu -> Select Command -> Click add.
Q. What is Ctrl N in Excel?
Ans: This shortcut is used to open a new document or Workbook in Microsoft excel.
Comments
comments