Shift + F3 − Opens the Excel formula window. See all combinations mapped onto a virtual keyboard. For example, C6.į7 − Spell checks the selected text or document.į11 − Creates chart from the selected data.Ĭtrl + Shift + − Enters the current time.Īlt + Shift + F1 − Inserts New Worksheet.Īlt + 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. Here we discuss the 4 different shortcut keys to paste values in excel along with examples & downloadable template. Search and filter shortcuts to find what will speed up your workflow. You can do this by pasting values with Menu button + V shortcut. Excel has a wide range of keyboard shortcuts. The best and quickest method to access Paste Special feature is to use the keyboard shortcuts. Once we have the copied data in the clipboard, we can use the following shortcuts and use Paste Special feature in Excel: By using the Keyboard Shortcut Keys.
This is normally done by after copying cells, right-clicking to target cell and select Paste as Value from Paste Options menu. However, we must have copied something to paste. Our regular Ctrl + V shortcut will not do it. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.į5 − Goes to a specific cell. Therefore we need to paste them as values.
This quickly becomes cumbersome when you are doing more than a couple ranges in Excel or charts (at least. As you might already know, Paste special is a gateway to many powerful operations in Excel. Below is the list of all the major shortcut keys in Microsoft Excel.Ĭtrl + A − Selects all contents of the worksheet.Ĭtrl + I − Italicizes the highlighted selection.Ĭtrl + U − Underlines the highlighted selection.Ĭtrl + 1 − Changes the format of selected cells.Ĭtrl + 5 − Strikethrough the highlighted selection.Ĭtrl + P − Brings up the print dialog box to begin printing.Ĭtrl + F9 − Minimizes the current window.Ĭtrl + F10 − Maximize currently selected window.Ĭtrl + F6 − Switches between open workbooks or windows.Ĭtrl + Page up − Moves between Excel work sheets in the same Excel document.Ĭtrl + Page down − Moves between Excel work sheets in the same Excel document.Ĭtrl + Tab − Moves between Two or more open Excel files.Īlt + = − Creates a formula to sum all of the above cellsĬtrl + ' − Inserts the value of the above cell into cell currently selected.Ĭtrl + Shift + ! − Formats the number in comma format.Ĭtrl + Shift + $ − Formats the number in currency format.Ĭtrl + Shift + # − Formats the number in date format.Ĭtrl + Shift + % − Formats the number in percentage format.Ĭtrl + Shift + ^ − Formats the number in scientific format.Ĭtrl + Shift + − Formats the number in time format.Ĭtrl + Arrow key − Moves to the next section of text.Ĭtrl + Space − Selects the entire column.Ĭtrl + - − Deletes the selected column or row.Ĭtrl + Shift + = − Inserts a new column or row.Ĭtrl + ~ − Switches between showing Excel formulas or their values in cells.į3 − After a name has been created F3 will paste names.į4 − Repeat last action. Select Chart, Right-Mouse Click for Shortcut Menu, Select Paste Special Picture icon. In this video, well review shortcuts and commands for Paste Special.
#Keyboard shortcut for paste values for excel 2016 windows
If you are familiar with windows operating system, you should be aware of most of them. MS Excel offers many keyboard short-cuts.