Join 3,512 readers in helping fund MetaFilter (Hide)

45 posts tagged with excel and word. (View popular tags)
Displaying 1 through 45 of 45. Subscribe:

Linking Excel data to Word docs: Portability?

I'm using Excel and Word 2007. Created Excel docs, created Word docs, certain cells in the Excel docs have data that must be embedded in the Word docs. This has been discussed here before, but only the method of creating these links (which was my method) but I'm just checking to see if anybody knows how to make this work when you move the document. All the links appear to be hardcoded absolute links to the Excel doc. Works fine on my PC, breaks on yours. Any way to get this functionality to be portable? [more inside]
posted by stupidsexyFlanders on May 22, 2014 - 3 answers

iPad iDiot

Help me turn my iPad into a work productivity tool. [more inside]
posted by sardonyx on Feb 17, 2014 - 10 answers

What is proficiency in Excel and Word?

What do you need to know to be "proficient" in Excel and Word? [more inside]
posted by ichomp on Jan 19, 2014 - 14 answers

MS Word / Excel 2011 for Mac catalog merge mystery

I have a batch of mixed-format data including long-form text fields, hyperlinks, number and plain text in an Excel doc. I have assembled a Word catalog merge file intended to allow me to proof the data manually. There are 42 records. On merge, the output document results in what appears to be the correct number of pages and records. However, records 28-42 do not appear to place any data in the destination document. [more inside]
posted by mwhybark on Apr 15, 2013 - 1 answer

Converting lots of little excel into word?

ExcelFilter: I have a whole bunch of excel files. More than 100 of them. Each file has about one page of print area, but some in portrait and others in landscape. They are mostly text in cells; not a lot of formulas being used. I would like to (1) merge all these files into one Word document; (2) have a page break so that each file (more or less) is one page; and (3) do it with a minimum of cutting and pasting. Opening everything as a PDF and viewing in Preview is also an option, but less optimal since I'll certainly need to adjust some formatting and page breaks. Maybe on publisher? Is anything like this possible? Or do I need to do it page-by-page? What would you do? I'm on a Mac 10.8.2.
posted by RandlePatrickMcMurphy on Nov 19, 2012 - 9 answers

Seeking on-line training in MS Office

Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
posted by dg on Sep 4, 2012 - 8 answers

Pie chart in Word with dollar amounts?

How to make a pie chart in Word with dollar amounts, not percentages? [more inside]
posted by zardoz on Aug 30, 2012 - 5 answers

How to prevent accepted tracked changes from carrying over into an excel + word + outlook email to 50 people?

Hi everyone, Hoping someone can help me sort this problem ... It's a excel + microsoft word document + mail merge to outlook email to 50 people. I am trying to help someone out - this is is as it just as it was described to me: Track changes were accepted and turned off and the email looked as it should - so off went 50 customized emails. ..unfortunately the sent email then shows that all the emails are sent showing all of the tracked change revision markings! Sorry if this is too vague. Thanks for your efforts :)
posted by anewnormal on Nov 30, 2011 - 3 answers

Good help forum for Office 2010?

Can anyone recommend a good, well-trafficked forum for Microsoft Office (particularly 2010) questions? Seems like this should be eminently Googleable, but maybe because there are so many of them, I'm not finding the one that is the one. Thanks!
posted by The Dutchman on Mar 19, 2011 - 7 answers

How can I link to specific places in a variety of documents?

How can I create a web-based table of contents that links to specific places within a diverse collection of documents? [more inside]
posted by kirkaracha on Mar 17, 2011 - 4 answers

Microsoft Acess Charts dead-end.

Microsoft Access 2007 - how on earth do I cut / copy / export / do anything with my Pivot Chart, besides print it? [more inside]
posted by Jimbob on Nov 23, 2010 - 12 answers

Replacing the Microsoft Office "Ribbon" With a Menu

Microsoft Office 2007 filter: Can you recommend a program/plugin (or the like) which will replace the "ribbon" interface with a traditional menu interface? Free is ideal, but for-pay is okay, too. Running Windows XP. Thanks.
posted by Conrad Cornelius o'Donald o'Dell on Nov 7, 2010 - 4 answers

Copying Word tables into Excel without splitting cells into multiple rows

I need help copying a table from Word to Excel in Office 2007. Where there are hard returns within a cell in the Word table, Excel splits the table cell into multiple rows. I need Excel not to split cells in the Word table into multiple Excel rows. At the same time, I need to retain the paragraphs that appear within the Word table cells - that is, I can't just get rid of all those hard returns; the formatting must be preserved. My Google-fu is failing me rather seriously. Is there any way to do this?
posted by Dasein on Oct 18, 2010 - 8 answers

help me Excel

Passing an MS Office test with flying colors. [more inside]
posted by anonymous on Jul 26, 2010 - 12 answers

Copy & pasting from Excel into Word

Is there a way to insert into a text string in Excel a "hard enter" so that when a series of rows of text are copied into Word that it automatically incorporates paragraph breaks between them? [more inside]
posted by notcostello on Jun 29, 2010 - 5 answers

Help me help Word and Excel play nicely together.

I'm trying to paste some text from Excel into Word. Normally when I do this, I select Paste Special > Unformatted Text so my stuff doesn't display as a table. But this time, the Excel text is already formatted with a ton of bold, italics, and underlining, and I don't know how to retain that formatting while still ditching the table. Help? [more inside]
posted by anderjen on Jun 10, 2010 - 5 answers

Have paragraphs. Want just the hyperlinks. In Excel.

Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel? [more inside]
posted by randomname25 on May 19, 2010 - 10 answers

Can you reccomend me a good Excel 2007 Book?

Can you reccomend me a good Excel 2007 Book? I'm currently studying a foundation degree in Renwable Energy in the UK, and am struggling with Excel 2007. A general book would be handy, but the main topic I'm really struggling with is 'visual basic', so it would need to include detailed information on how to use that and the coding system of Excel. Can anyone reccomend a good book to get that would include information relative to that?
posted by sockpim on May 5, 2010 - 9 answers

Can you recommend online tutorials for Excel, Word, and MS Access?

Can you recommend online tutorials for Excel, Word, and MS Access? [more inside]
posted by helios410 on Feb 10, 2010 - 8 answers

Word 2007 formatting question

How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside. [more inside]
posted by jujube on Dec 17, 2009 - 15 answers

Looking to up my presentation skills in NYC

I'm looking for a job doing presentation graphics (in law firms, possibly financial firms); this is about 30% of my current job at a law firm. I'm one of very few "experts" at my firm which isn't very technologically advanced in this area, so I'm afraid that my skills won't cut it in the outside world. I need advice on how to upgrade my skills. [more inside]
posted by kenzi23 on Sep 30, 2009 - 2 answers

How do I copy the contents from Excel to Word without the formatting?

Does anyone know how to remove the formatting (for lack of better expression) column borders that accompany text when I paste it from Excel to Word? I've checked both Word & Excel help to no avail, probably because I can't frame the question very well. Thanks.
posted by holdenjordahl on Sep 9, 2009 - 8 answers

Can Outlook attachments change themselves?

Is it possible for an email attachment in Outlook to 'update' itself from a network drive? My attachment is not the same now as it was when I first received and viewed it. [more inside]
posted by youngergirl44 on Jul 7, 2009 - 14 answers

How can I download only Open Office Writer instead of the whole suite?

Can I download only OpenOffice Writer? [more inside]
posted by ptsampras14 on Jun 18, 2009 - 4 answers

Making a monthly events calendar using seat-of-the-pants design!

I need to make a template for an in-print events calendar, and I'm not sure what the best way to approach this project is. Advice please! [more inside]
posted by soviet sleepover on May 5, 2009 - 2 answers

Mac Address Book to Microsoft Excel?

My main computer is a Mac (iBook) and I use the Address Book and Apple Mail. I also manage the email list for a group, and I need to be able to export the list of email addresses to either Excel (preferably) or Word. I haven't figured out how to do that. [more inside]
posted by bibbit on Apr 13, 2009 - 2 answers

How can I study for the OPAC?

Has anyone taken the Office Proficiency Assessment and Certification (OPAC) test recently, or have documentation on what exactly it tests for in Word and Excel? [more inside]
posted by limeswirltart on Mar 6, 2009 - 3 answers

How do I get Word and Excel to work together?

I need MS Excel and Word to play together nicely. I can do what I need to in Word, and I can do what I need to in Excel; it's the Relationship that's Complicated. Maybe I need workflow advice? Basic knowledge? Please, please keep reading. [more inside]
posted by cheeken on Feb 5, 2009 - 14 answers

Automating monkeywork in Excel and Word

Automation Filter: How can I automate the insertion of data from a spreadsheet into a Word report template? [more inside]
posted by McBearclaw on Jan 6, 2009 - 8 answers

I see you've used Microsoft Word before.

How do I get 'rock hard' Microsoft Office skills? [more inside]
posted by greytape on Oct 29, 2008 - 8 answers

Importing Excel spreadsheet data into to Word

How can I make readable Word tables out of a large Excel spreadsheet? [more inside]
posted by lunchbox on Jul 6, 2008 - 7 answers

Creating a personalized form letter

Help me create custom documents out of pre-written paragraphs in Word. [more inside]
posted by bove on Dec 7, 2007 - 5 answers

Question on converting numbers into formatted text with Excel.

Question on converting numbers into formatted text with Excel. [more inside]
posted by Optimus Chyme on Nov 7, 2007 - 5 answers

Fun New Product at Work

The management at the company I'm working for has sold a couple customers on a product that we as the worker-bees have yet to produce. That being said I view this more as an opportunity to do something new than as a huge hassle, assuming we can figure out a convenient way of producing said product. So I was hoping the great and wonderful MeFi might have a couple suggestions they might throw my way. [more inside]
posted by bernsno on Sep 17, 2007 - 3 answers

How do I get my table rows to stay clumped in fives?

How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]
posted by bokinney on Mar 12, 2007 - 7 answers

Mailmerge Filter (how to create separate docs)

I'm doing a code review and I'm keeping track of my findngs on an Excel spreadsheet. I need to generate reports that show vital details about the source code file being reviewed. Unfortunatley, as far as I can tell, MS Word 2003 generates one Word doc that has all oft he merged content in one file. How do I get it to create separate documents? [more inside]
posted by apark on Nov 17, 2006 - 8 answers

excel/word online tutorial

My girlfriend is going for an interview where she will be tested on Microsoft Word and Excel. Is there an online tutorial where she can take some sample tests or run through some applications? We've googled a few, but they seem to stop at beginner levels and to be rather cumbersome. Just wondered if anyone had some first hand knowledge of a site to head to. Regards/p &k
posted by patrickje on Nov 16, 2006 - 5 answers

How to correctly export columnar labels from Word into Excel?

A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file. [more inside]
posted by empyrean on Jun 6, 2006 - 6 answers

“Eventually, all things merge into one, and a river runs through it.”

Complex Excel to Word merge question is the [more inside]
posted by anastasiav on Apr 6, 2006 - 10 answers

How do I find a reliable person to do some computer work for me?

I need some computer work done for me and I'm not sure how to find someone to do it. [more inside]
posted by ikkyu2 on Mar 6, 2006 - 14 answers

Creating a Directory with Word and Excel?

Is there a quick way to create a mail merge directory in Word from an Excel spreadsheet, broken down by a specific field (department, category, etc.)? This seems like a Microsoft 101 question, but the built-in Help doesn't seem to address this specifically, and online help from Word 2002 gets into code I can't even begin to understand. [more inside]
posted by pzarquon on Sep 7, 2005 - 1 answer

Mass Cyrillic to Latin translation in Excel?

I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand. [more inside]
posted by michaelkuznet on Sep 1, 2005 - 5 answers

Office of OS 9 Macros not working too well in OS 10.4

When I try running long complex macros in MS Word for OS X, created in Office for Mac OS 9.2, some of the macros are freezing/crashing. Perhaps even worse, the macros don't seem to be failing at the same point each time I try to run them. [more inside]
posted by ParisParamus on Jun 15, 2005 - 1 answer

Bibliographies in Excel

I'm working on my MA thesis and so have an enormous jumble of books, articles, and references kicking around. I am looking for an easy way to manage this. [more inside]
posted by synecdoche on May 4, 2005 - 31 answers

Why does pasting excel charts into word cause the word file to become gigantic?

Is there a way to cut'n'paste charts from Excel into Word, without generating huge Word files? I've tried varieties of paste, 'paste special,' and so on, and I can't figure out why an Excel file of charts that's several hundred KB, always turns into a Word file that's at least several MB. I guess I'm missing something obvious, but have no idea what it is.
posted by carter on Jun 24, 2004 - 8 answers

Page: 1