Instructions to copy data from Excel to Word retain the format
Sometimes at work you want to convert table data from excel to word, but when the copy to word is formatted or exceeds the frame in the word. The following article details how to copy data from excel to word to keep the format.
Step 1: Open the Excel file containing the data to copy -> Highlight the data you want to copy -> Right-click and select Copy .
Step 2: Open the Word file you want to insert data from Excel -> place the cursor at the position you want to paste -> on the HOME tab -> Paste -> Paste Special .
Step 3: A dialog box appears, select Paste -> Microsoft Excel Worksheet Object -> OK .
1. In case you want to paste quickly and keep the format
Right-click -> Choose the 1st, 2, 3, 4 . features of Paste Special .
You can choose Paste to keep the format using features 1, 2, 3 . And you manipulate editing right on the pasted paste.
2. Get only the textual content to Paste
Select the 6th feature Keep Text Only (T) .
3. Paste with image format and you can not manipulate, edit the data just pasted
Use the fifth Picture feature (U) .
Above are some ways to copy data from Excel to Word hoping you will apply this feature often.
Good luck!
You should read it
- How to copy from Word to Excel, Powerpoint stays the same format
- Instructions on how to copy charts from Excel to Word
- MS Excel 2003 - Lesson 3: Manipulating data in spreadsheets
- Instructions on how to copy formulas in Excel
- How to Convert Word to Excel
- Instructions for copying or moving Worksheet in Excel 2013
- How to copy from Excel to Word without frames
- Quick formatting of words appears many times on Word
May be interested
- How to copy from Excel to Word without frameswhen copying data from excel to word, the software will default to the data accompanying the frame. so in case you just want to copy the data without the accompanying frame?
- How to transfer tables from Word to PowerPointhow to copy tables from word to powerpoint to keep formatting, font words, table lines ...?
- How to use PDF Anti-copy to protect PDF filespdf anti-copy is software that protects pdf files, preventing the ability to copy all data, even when converting pdf files to word or excel.
- Copy, copy data in Excelwith similar data or formats, instead of having to enter them all in turn, copying (copying) data in excel is very necessary. using the methods of copying data, you can quickly copy data, formulas, formatting ...
- how to fix error cannot copy data in Excel filesin the process of using the computer, there will be times when we encounter an error that we cannot copy data in excel. the cause may be that the computer has a virus, the clipboard is not working, and therefore the copy command (ctrl + c) and the paste command (ctrl + v) are not working.
- Instructions for formatting data in Excelexcel spreadsheets support a variety of data types for cells in the worksheet: numeric, percentage, date, time, fraction, etc., with different data, you should format the data type correctly. for that data box. so when calculating or processing data
- Tips for copying fast and efficient paragraph formatting in Wordto save your time and effort, you can use format painter to copy the text format without having to edit it again.
- Instructions on how to format data in Excelinstructions on how to format data in excel 2013. 1. format text. 1.1 font format, type, font size: - select the data to format - home - font - quickly select the font, font size, type as shown: where: + b (bold): type c
- MS Excel 2003 - Lesson 2: Format spreadsheet datatipsmake.com will guide you how to format data in excel 2003, detailing font options, data types, how to align data in cells, spreadsheets.
- MS Excel 2007 - Lesson 4: Working with dataexcel allows you to move, copy and paste cells and text fields through cut and paste or copy and paste.