Fulton Street Software

Social service is in our DNA

Work Smarter

A Calculating Trick! Insert an Excel Spreadsheet into MS Word

by

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!

 

 

Productivity Hacks: Keyboard Shortcuts to Save You Time

by

Data entry, emails, spreadsheets, documents…so much of our work is centered on our computers. As our pre-holiday gift to you, here are our top three keyboard shortcuts that are guaranteed to save you time and increase your productivity.

Get ready to dazzle your co-workers with these little-known shortcuts!

Productivity Hack #1 – Re-open Internet Tabs

“Oh no! I had 10 tabs open and closed the wrong one! Ugh, how do I get back to the site I need?”

This one is easy…simply click Control, Shift and the letter T (ctrl + shift + T).  The tab instantly reopens!

Productivity Hack #2 – Start a New Page

You’re creating or editing a document and want to start a new page. You hit the enter button repeatedly until a page break appears. But there’s an easier way…

Simply click Control and Enter (Ctrl + Enter)

Productivity Hack #3 – Change Indents on a Bulleted List

If you often work with bullet points or numbered lists in Word, this hack is for you. It is a simple way to move an item in a bulleted or numbered list up a level. For example, you type a list that looks like this:

  1. Heading one
    1. Point number one
    2. Point number two
    3. Heading two (oops, I accidentally indented this too far!)

To move “3.” back to become Heading item ‘2’, simply put cursor in front of the word ‘Heading’ after the ‘3.’ and click the ‘shift’ and ‘tab’. This moves the indent back to the left.

How cool is that? Stay tuned to this blog for more shortcuts, hacks, tips and tricks to turn you into an Excel Expert, MS Word Warrior, and all-around office rock star.