• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer

Fulton Street Software

Social service is in our DNA

  • About
    • Our Story
    • Board of Directors
    • Partners
    • Team
  • Modules
    • Multi-Services
    • Referral & Intake
    • Foster Care Activity and Status
    • Case Management
    • Resource & Home Member Management
    • Domestic Violence
    • Customized Form Data Collection
    • Financial Management
    • Reporting and Data Export
  • Services
    • Conversion & Implementation
    • Training
  • Testimonials
  • News
  • Contact
  • Request A Demo

productivity hacks

A Calculating Trick! Insert an Excel Spreadsheet into MS Word

December 19, 2018 by Fulton Street Software

Have you ever inserted a simple table in a Word document, only to enter numeric values and manually manipulate data? Or have you opened a separate spreadsheet only to re-key or copy the results into the table in your document? Do you ever struggle with column alignment or other formatting within Word? And how do you deal with the misaligned results when you paste the values from a spreadsheet into a Word document?

Did you know you can insert a functional Excel spreadsheet directly into your Word document? You can even apply formatting, colors, titles, and enter advanced formulas directly into the Word document!

Here’s how:

  1. Click on the insert menu and table item on the Word Ribbon and select Excel Spreadsheet.
  2. A spreadsheet will appear within your document
  3. Proceed to enter values and formulas as you would in Excel
  4. The Excel Ribbon and menu items appear when you double-click within the spreadsheet. You can format the rows, columns, and values as you would normally in Excel
  5. The non-printed cell borders still appear in the document as you continue to work
  6. When you print the document to a pdf or printer the formatted rows, cells, and columns appear perfectly

Your work just got easier!

 

 

Filed Under: Productivity Hacks, Work Smarter Tagged With: Excel, MS Word, productivity hacks

Primary Sidebar

Recent Posts

  • Integrating Your Data Management with EHR Systems
  • Asara Makes Audits Great Again
  • A Calculating Trick! Insert an Excel Spreadsheet into MS Word
  • Create Customized Data Collection Forms Like a Pro
  • Productivity Hacks: Keyboard Shortcuts to Save You Time

Search

Footer

Fulton Logo

Phone: 212.233.0702
Email: info@fultonsts.com

© fulton street software llc |  all rights reserved