how to copy and paste on excel and keep same format?
234028
Select the cell or cell range into which you want the formats pasted. Choose Paste Special from the Edit menu. Excel displays the Paste Special dialog box.
279577
['Simply, click on the sheet tab that you want to copy, hold the Ctrl key and drag the tab where you want it: ... ', "For instance, that's how you can make a copy of Sheet1 and place it before Sheet3: ... ", 'To copy a sheet, go to the Home tab > Cells group, click Format, and then click Move or Copy Sheet:']
91117
['Select your data and press Ctrl + C or right click to select copy form the context menu to copy it.', 'Then click a cell which you want to paste the data, and right click choose Paste Special > Keep Source Column Width icon, see screenshot:< /p>']
9108
['Select the cells that you want to copy For more information, see Select cells, ranges, rows, or columns on a worksheet. ... ', 'Click Home > Find & Select, and pick Go To Special.', 'Click Visible cells only > OK.', 'Click Copy (or press Ctrl+C).', 'Select the upper-left cell of the paste area and click Paste (or press Ctrl+V).']
44394
['Simply, click on the sheet tab that you want to copy, hold the Ctrl key and drag the tab where you want it:', "For instance, that's how you can make a copy of Sheet1 and place it before Sheet3:", 'To copy a sheet, go to the Home tab > Cells group, click Format, and then click Move or Copy Sheet:']
385913
Press CTRL+SHIFT+ the down arrow key to select the column. Click the Copy button from the Home tab on the ribbon. Click the bottom part of the Paste button on the toolbar, and then select the Paste Values button.
469079
From the "Home" menu, in the "Clipboard" section, click on the down arrow below "Paste". Select the "Keep Text Only" option. Only the text will be copied; no formatting will be changed.
437611
['Go to Edit > Clipboard > Paste.', 'Press CTRL+V .', 'Right -click and select Paste.', 'Click Paste on the Edit toolbar.']
416332
If you want to copy only the values, copy the data, go to the destination cell where you want the data to be copied, open the Excel Paste Special dialog box and select Values. This will only copy the data and not the formatting.
963640
['First off, open the specific Excel workbook.', "Then, double click on a sheet's name in sheet list at the bottom.", 'Next, press “Ctrl + C” to copy the name.', 'Later, create a text file.', 'Then, press “Ctrl + V” to paste the sheet name.']
173876
['Select the cell or range of cells that contains the data that you want to move or copy. ... ', 'On the Home tab, in the Clipboard group, do one of the following: ... ', 'Right-click the upper-left cell of the paste area, and then click Insert Cut Cells or Insert Copied Cells.']
77261
['Select the cell or range of cells.', 'Select Copy or press Ctrl + C.', 'Select Paste or press Ctrl + V.']
3143
['Highlight all the cells that you want to have the same text.', 'Type the text you want.', 'After typing the text, instead of pressing Enter, press Ctrl+Enter.']
675553
['SELECT THE INFORMATION YOU WANT TO COPY.', 'CLICK THE COPY BUTTON ON THE TOOLBAR. OR... SELECT EDIT + COPY FROM THE MENU. OR... PRESS CTRL + C.', 'SELECT THE DESTINATION WHERE YOU WANT TO PASTE THE INFORMATION.', 'CLICK THE PASTE BUTTON ON THE TOOLBAR. OR... SELECT EDIT + PASTE FROM THE MENU. OR...']
366668
['Select the cells that have dates that you want to convert and copy it.', 'Open a Notepad and paste it there. ... ', 'Now switch back to the Excel and select the cells where you want to paste these dates.', 'With the cells selected, go to Home –> Number and select the Text format (from the drop down).']
255963
['Open the table or spreadsheet you want to copy.', 'Select the cells you want, and then press CTRL+C to copy them.', 'Open Publisher.', 'Press CTRL +V to paste the cells. The copied table or spreadsheet appears in Publisher as a table.']
498740
You can copy rows, cells, formulas, hyperlinks, and hierarchy. Use either the right-click menu or the keyboard shortcuts Ctrl + C to copy and Ctrl + V to paste (Command + C and Command + V on a Mac).