To do that, follow these steps...
- Select the formula cell/cells.
- Right click on one of the selected cells and choose Copy or press Ctrl+C to copy the selection.
- Right click in A1 and choose paste icon with 123 over it i.e. paste as Values. Or select the cell A1 and press the keys Alt,E,S,V and hit Enter.
To generalise a bit. To copy selected cell/range
with Ribbon
-by mouse: click Copy button
- by keyboard: press sequentially Alt,H,C,C
with context menu
-by mouse: right click and in appeared menu click Copy button
- by keyboard: press context menu button (near the right Ctrl on keyboard), navigate by Arrow Down to Copy icon, Enter
with keyboard shortcut
- Ctrl+C; or
- Ctrl+Ins
(with keyboard shortcuts keep pressed first button and release it after all next buttons were pressed sequentially)
To past value into target cell/range
with Ribbon
-by mouse: expand menu under Paste button and click on 123 icon; or
expand menu under Paste button, click on Paste Special, select Values, click Ok
- by keyboard: press sequentially Alt,H,V,V
with context menu
-by mouse: right click and in appeared menu click on on 123 icon
- by keyboard: press context menu button , navigate on 123 icon by Arrow Down, Arrow Right, Enter
with keyboard shortcut
- Ctrl+V or Shift+Ins, press Ctrl to expand Quick access menu, navigate to 123 icon by Arrow Down, Enter
One more option is to add Copy and Paste Values icons to Quick Access Toolbar
and do operations with one click on them; or by keyboard Alt,N where N sequential position number of the icon in toolbar. I my case to paste values is Alt,9
Forgot something?
