Archive for October, 2010

Another Windows Tip: Paste Special

Monday, October 25th, 2010

Today, we’re going to follow up our last post about opening Excel documents in their own windows with another tip on working with Microsoft Windows and Microsoft Office (specifically Word and Outlook).  This one has to do with pasting data into either a Microsoft Outlook email or a Microsoft Word document.  As you may know, sometimes it is necessary to copy material from the internet, another document, or some other source and paste it into the Word document or Outlook email you’re working on.  We certainly do a good bit of that here at Aries Multimedia since email is the primary way we communicate with clients.

If you copy data from one location and try to paste it into either Word or an Outlook email, you’ll notice that, by default, the data retains its formatting.  If you copy from a web page, Word and Outlook try their best to make the data look the same in your document or email as it does wherever it comes from. In our experience, we would much rather have the data look like the destination document rather than the source document.  Microsoft provides for this through the “Paste Special” command.

The “Paste Special” command is located on the Home toolbar in Word and the Message toolbar in the Outlook email editor.  If you click on the arrow under the “Paste” button, you’ll get the “Paste Special” menu.  At this point, you can choose to paste your data as “Unformatted Text” and the data will be formatted like the rest of the destination document or email.  This is more difficult and involves more steps, however, than the simple Ctrl+V keyboard shortcut.  In order to speed things along, we have made pasting as Unformatted Text the default.

If you want to make pasting as unformatted text your default, just click on the Office button in the upper left of the screen and click on “Word Options” (Word) or “Editor Options” (Outlook Email Editor).  Click on “Advanced” and scroll to “Cut, Copy, and Paste”.   Here, you have the option to Keep Source Formatting (the default option) or “Match Destination Formatting”.  I have changed all of my values to “Match Destination Formatting”.  Now, with the Ctrl+V keyboard shortcut, whatever we paste into Word or Outlook looks exactly like the rest of the document or message.  This is one of those small fixes that has ended up saving us a good bit of time.

Open Excel Files in Their Own Windows!

Friday, October 22nd, 2010

Many of our clients use Microsoft Windows and Microsoft Office.  We recently came across an interesting hint for using Microsoft Excel that we would like to pass along.  We use Excel for everything from loading new e-commerce products onto our customers’ websites to performing sophisticated statistical analyses of e-commerce customer data.  As an aside, if you would like to talk to us about doing any of this for your yet-to-be-developed or already existing e-commerce site, drop us a line.   As you might imagine, when we are doing this kind of work for customers, we often have many Excel files open at once.  If you look down at your task bar, however, you only see one one “Excel” tab listed.  This is because, by default, Excel opens each file within one single “instance” of the Excel  program.  We often like to have each file opened up in its own instance.  This has the advantages that you can look at files side-by-side across multiple monitors and you can see exactly what you have open on your task bar.  If you want to do this, you can find out here (credit where credit is due) or just follow these steps:

  1. Open Windows Explorer (you can do this pretty easily by pressing the “Windows” button and the letter “E” at the same time on your keyboard)
  2. Click on any folder
  3. Click “Tools”
  4. Click “Folder Options”
  5. Click the “File Types” tab
  6. Scroll down to the extension “XLS” and click on it
  7. Click “Advanced”
  8. Highlight “Open” and click on “Edit”
  9. Uncheck the “Use DDE” check box
  10. Change the “Application used to perform action” field to
    “C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” “%1″
  11. Click OK
  12. Repeat steps 6-11 for the XLSX file extension if you are using Office 2007+

That’s it!  This relatively simple 12 step process will allow you to open Excel files in their own windows!

ieiMedia

Thursday, October 21st, 2010

This summer was an interesting one at Aries Multimedia, and we have a flurry of new projects coming online soon that we’re excited to tell you about.  The first one is the new web site for ieiMedia, LLC.  This company organizes and runs study abroad programs in multimedia journalism.  Many of the study abroad course instructors are versed in WordPress, and therefore we used WordPress to design the site.  The site features a user-managed photo gallery and a user-managed scrolling quote WordPress plugin.  We hope all of the students and instructors enjoy the new ieiMedia site.  Do you know some WordPress basics but need help developing a professional-looking site using WordPress?  Contact us and we can help you out!