Other useful shortcut keys Frequently used shortcuts This table lists the most frequently used shortcuts in Excel. To do this Press Close a workbook. Ctrl+W Open a workbook. Ctrl+O Go to the Home tab. Alt+H Save a workbook. Ctrl+S Copy selection. Ctrl+C Paste selection. Ctrl+V Und...
Keyboard shortcuts that begin with Ctrl will still work in Microsoft Excel 2013. For example, Ctrl+C still copies to the clipboard, and Ctrl+V still pastes from the clipboard. Most of the old Alt+ menu shortcuts still work, too. However, you need to know the full sho...
Cut Cells Using Mouse Drag and Drop Cut Partial Cell Value Using Keyboard Shortcut Keyboard Shortcut to Cut Cell Value (or Range of Cells) Let’s first start with the simplest and the most common way of cutting a cell value in Excel – a keyboard shortcut. Control + X Below are the ...
In Excel, to use the Superscript, the user has to follow the combination of the below keys as Excel does not have any default shortcut defined for this. Ctrl +1, and then, Alt + E→ Enter Steps to Use Superscript Using Keyboard Shortcut First, double-click on the cell and select onl...
There are many Excel keyboard shortcuts, but we focus here only on those you might actually use regularly. In some cases there is more than one shortcut for a given action or command. While there are several shortcuts that can be used to apply number formats, these default formats are ra...
Type in a function name within a cell and then press this keyboard shortcut to insert argument names and parentheses to the right of the function name Ctrl+B Ctrl+2 Apply or remove bold formatting Ctrl+C Copy selected cells, or any other selected object such as a chart ...
When you need to edit the data you’ve entered, you can select, insert, and copy data easily using these shortcuts. Keyboard Shortcuts for Formatting Cells Using the following shortcuts, you canformat the datainside your cells from bold or italic to a currency or percentage. ...
You can indent to the left or to the right in a cell. In this short Excel tutorial, I will show you how to indent In Excel. There is a button to do that right there in the ribbon, and you can also use a keyboard shortcut (if you are more comfortable with that). So let’s ...
Move left or right to another tab of the Ribbon, respectively. TAB to get to the desired tab, and then LEFT ARROW, RIGHT ARROW Display the shortcut menu for the selected command. ENTER Move the focus to each command on the Ribbon, forward or backward respectively. TAB, SHIFT+TAB Move ...
Number Formatting Shortcut Keys Apply currency format Ctrl+Shift+$ Apply date format Ctrl+Shift+# Apply general format Ctrl+Shift+~ Apply number format Ctrl+Shift+! Apply percentage format Ctrl+Shift+% Apply time format Ctrl+Shift+@Borders Shortcut in Excel Add border outline Ctrl+Shift+& Add...