how to copy and paste in excel without changing the number?
70373
Press F2 (or double-click the cell) to enter the editing mode. Select the formula in the cell using the mouse, and press Ctrl + C to copy it. Select the destination cell, and press Ctl+V. This will paste the formula exactly, without changing the cell references, because the formula was copied as text.
2529
['Select the range of data you want to rearrange, including any row or column labels, and either select Copy. ... ', 'Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose.']
896569
['Enable the Clipboard pane with clicking the anchor at the bottom-right corner of Clipboard group on the Home tab. ... ', 'Select the range of cells you will move to a single cell, and copy it with pressing the Ctrl + C keys in a meanwhile.']
1294939
['Sheets("Monthly Snapshot").Select.', 'Range("L7").Select.', 'ActiveCell.FormulaR1C1 = _', '"=CONCATENATE(""=SUM(I$5:I"",(Control! R21C3+4), "")/SUM(H$5:H"",(Control! R21C3+4), "")-1"")"', 'Range("L7").Select.', 'Selection.Copy.', 'Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _', ':=False, Transpose:=False.']
419709
['Select the cell with the desired format and press Ctrl+C to copy its content and formats.', 'Select the entire column or row that you want to format by clicking on its heading.', 'Right-click the selection, and then click Paste Special.']
437611
['Go to Edit > Clipboard > Paste.', 'Press CTRL+V .', 'Right -click and select Paste.', 'Click Paste on the Edit toolbar.']
250452
['Open your Excel spreadsheet.', 'Hold down Command (Mac) or Control (Windows).', 'Select multiple cells in the same row or column.', 'Click the Home tab.', 'Click Copy on the top-left of the toolbar.', 'Select where you want to paste.', 'Click Paste on the top-left of the toolbar.']
140920
To include multiple cells, click on one, and without releasing the click, drag your mouse around adjacent cells to highlight them before copying. To paste to a cell, single-click on the cell where you'd like to paste in the information and press Ctrl + V (or right-click on the destination cell and select Paste).
929769
['Highlight the cells with the special formatting.', 'Tap and hold the highlighted selection.', 'Select Copy.', 'Go to the cells into which you want to copy this formatting.', 'Tap and hold the selection/cell.', 'Select Paste Special.', 'Select Paste Format Only.']
23950
['Select the cells or ranges you wish to copy.', 'Select the “Home” tab.', 'Select “Copy” in the “Clipboard section.', 'Select the cell you wish to paste your values to.', 'Select the lower half of the large “Paste” button. From the extended menu that appears, select “Values“.', 'Select “OK“.']
963830
['Select the cell(s) from which you want to copy the comments and press Ctrl + C to copy those cells.', 'Select the destination cell, or the upper-left cell of the target range.', 'Press the paste special shortcut (Ctrl + Alt + V), and then press C to paste only comments.', 'Press the Enter key.']
471473
['Step 1: highlight the column or cells you want to copy and paste.', 'Step 2: Press Ctrl + C to copy column.', 'Step 3: Press Ctrl + V to paste.']
979189
['Select the cells that you want to move or copy. ... ', 'On the Home tab, in the Clipboard group, do one of the following: ... ', 'Select the upper-left cell of the paste area.']
253518
Now when you copy a cell or range, you can just use Alt+4 (assuming the new button is the fourth in the Quick Access Toolbar) to paste wherever you want and keep the destination formatting. In Excel 2013, use the ordinary Ctrl+V shortcut, then press Ctrl, then press M.
735635
Then switch to another sheet, select the upper-left cell of the destination range and press Ctrl + V to paste the copied range. For the copied data to update automatically as soon as the original data changes, you can copy information from one Excel sheet to another by using formulas.
444990
['Select the result in the worksheet.', 'And then press the shortcut keys “Ctrl + C” on the keyboard to copy the range.', 'Now click another cell in the worksheet.', 'Next press the shortcut keys “Ctrl +V” to paste those cells.']
459359
Just insert 500 in any empty cell. Copy this cell (Ctrl+C). Select all cells where you want subtract this value and press Ctrl+Shift+V. Select "Subtract" and "OK".