#1
|
|||
|
|||
how do I place text from an excel column in a default template
I am trying to place it in a default word document with an excel sheet from a column of text.
Who has a solution for this? I am a beginner with Exel and Words |
#2
|
|||
|
|||
I think you mean a default blank document. You do not want any text in the default Normal template.
Copy and paste? Do you want an Excel spreadsheet part in your Word document? Do you want the text that is in the column? What end result are you looking for? See also Mail Merge and Use mail merge for bulk email, letters, labels, and envelopes - Office Support |
#3
|
|||
|
|||
Quote:
Johan, you may want to play around with the different options for pasting Excel cells into Word. First, do you need to create a link to the Excel sheet so that if/when the data changes in Excel, you can update it into Word? I'm guessing not since you say it's text, but you do have that option. Do you want it to just be text, or become a table? See attached picture that shows the six things that pop up for me in Word 365. I'm guessing that either option 2 (use destination styles) or 6 (keep text only) might be what you're looking for, but you can copy your cells in Excel, go to your Word document, and right mouse click. You should see those paste options. You can try all six, one by one, and just Undo (CONTROL + Z keyboard shortcut) to go back and try the next one. As you mouse over those icons it will show you what they do. Ann |
#4
|
|||
|
|||
thanks gentlemen for your contribution.
Maybe I wasn't clear enough. This is what have. I make Quick Solution Cards for my company. the card describes a problem solution for the customer on one A4 . the problem is visible to the customer on a screen via key words . Now I have made a default template in words where I only have to insert the key words and save it I made a pivot table for all the problem reports. in the pivot table I linked each problem message to the relevant word file. My question is: Can I call up the default word template with a click on the keywords alarm message in the pivot table and where the keywords are inserted in the right place in the word document? Sorry for the long explanation. |
#5
|
|||
|
|||
Did you look at the links I provided?
|
#6
|
||||
|
||||
It sounds like you will need a macro to do this. You will need to post a sample Excel workbook and Word document (template) showing what you have currently. If it is clear where the keywords are and where they need to go then someone may be able to create the macro for you.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#7
|
|||
|
|||
Hello Charles.
I have looked at your Links , but this is not what i am looking for. Thanks for the answer. |
#8
|
|||
|
|||
How do I place text from anexecl column in a default word template
These are the Word templates and exel seartch document .
I hope it makes things clear . |
#9
|
||||
|
||||
There is no Word document attached to your post.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#10
|
||||
|
||||
Johan
Your question is still not clear. Your Excel file contains phrases and no connection to Word templates/files. It is not clear how you expect any of this to work. You posted an unrelated Word document to me which doesn't help at all. You will need to describe clearly how a 'user' will interact with your Excel and Word documents or provide examples that relate directly to the question you asked if you want help.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#11
|
|||
|
|||
So, when you click on the description in column B, you want it to open a Word file?
You can probably do this using hyperlinks. If the documents are all in a common shared drive/folder or on the web, you can make the Excel a hyperlink to that file. |
#12
|
||||
|
||||
I think that is a great suggestion from kilroyscarnival.
The keywords in your spreadsheet are really phrases so there isn't any point in trying to build a database and do a bunch of coding when people can just jump straight to the file with a non-code solution.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#13
|
|||
|
|||
Hello Kilroyscarnival >
I have try your example files and they work form me . Thanks |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing my Excel 2010 Blank/Default Template | revmwilson8 | Excel | 1 | 08-09-2016 02:57 AM |
Excel Default Template | kneghx | Excel | 1 | 05-13-2015 09:29 AM |
editing a number/text at one place and changes taking place wherever it appears | anurag.butoliya | Word | 1 | 06-14-2014 06:27 PM |
Excel 2010 default column width 8.09 | Jeff_J | Excel | 0 | 05-28-2013 11:56 AM |
Can you place an Excel Template in the Public Folders | gfkbob | Outlook | 0 | 01-09-2010 08:43 AM |