Get Excel 2013 To Recognize The Comma Delimiter In A CSV File

excel_comma_delimit
If you have MS Excel installed on your system, any CSV file you download is automatically associated with the program. Excel is more than capable of opening and editing a CSV file, the only problem is the way it reads the data in the file. By default, Excel is not set up to recognize the comma as a delimiting character. The result is, whenever you open a CSV file, the data looks all wrong. The data in rows is successively added to columns instead of staying in its CSV defined layout. It's hard to read and even harder to work with. Here's a simple way to get Excel to read and display the data correctly. Read More

Customize What Types Of Changes Are Tracked In MS Word 2013

word_track-changes
When I learned about the Track Changes feature in MS Word I felt like I'd discovered the secret of life. I've since used it for professional, academic, and personal documentation work. It's a pretty neat tool that makes collaborating on a document easier especially if the people you're working with are averse to trying out some of the online tools that support live collaboration like Google Docs. That said, MS Word tracks everything by default, every little thing. Entering so much as a space will show up with a red highlight which is great when you've got a long report to work on with different people. What's not so great is that formatting changes and  comments will appear as changes too when you may not want them to be tracked. Here's how you can customize what types of changes MS Word tracks. Read More

How To Cross Reference And Link Cells Between Different Excel Files

paste_special_excel
Linking two excel sheets so that one can read a value from the other is much easier than it sounds and it's a function that a lot of people need. No one has just one Excel file and while it is easy to add data from file to the other, keeping up with the changes so that they are reflected across all files is both time consuming and prone to error. The following little tutorial helps you link a cell from one Excel file to a cell in a different Excel file such that it updates itself. Read More

Copy Text Faster By Selecting A Collapsed Heading In MS Office 2013

copy_heading
A few days ago we covered a little tip on how to get text to collapse and expand on click in MS Word 2013. The trick to it is pretty simple and I originally thought it was useful when viewing a really long document. That isn't something small in terms of convenience especially if you've got a long document with lots and lots of sections in it but it turns out that a collapsed heading is really useful in another common scenario; copying and pasting text. Here's why. Read More

Get Text To Expand/Collapse On Click In MS Word 2013

heading_option_word2013
A good four years ago we wrote about hiding text in MS Word 2010 and the brief discussion on the post put forward a new question; users wanted to insert expandable/collapsible text in the word processor. Back in the 2010 version there was no easy way to accomplish this and for something that should be relatively simple, you would have had to resort to using Macros. In the end, they may not have done the trick in a very refined way. Such was the hasstle of it that we never found a viable and simple solution to it. Fortunately in Office 2013, the feature has been added and is very easy to use, if you know where to look for it. In this post, we're going to show you how to get text to expand/collapse and how to make it look a little refined as well. Read More

Get Custom Templates To Appear On The Start Screen In MS Office 2013

PP_2013_temp_ss
Microsoft provides a fairly large library of templates that users can download for free, for each of its productivity apps. Office also comes packed with a few templates and themes, and if you're looking for something exceptionally original, you can create your own templates or download, even buy them, online. In Office 2013, Microsoft added a start screen that shows popular templates or custom templates each time you launched the app. It makes  it easier to open templates instead of a blank presentation. There is just one little catch; if you download say a PowerPoint template, it doesn't show up on the start screen. Instead you have to browse to where it's downloaded every time you want to open it. This pretty much defeats the purpose of the start screen. The work around is pretty simple though so here's how you can get any template you've downloaded for an Office app to show up on its start screen. This works for templates for all Office 2013 apps. Read More

Disable MS Office 2013 Start Screen & Always Open Blank Documents

MS-office_ss_disable
MS Office 2013 is without argument the most polished face the productivity suit has ever had, to date. It's an obvious outcome of it being around for years and being improved upon. That said, I don't always like the new start screen in Office 2013 which stalls the actual program being launched. I use Word quite often and I'm still in the habit of launching it from the taskbar and immediately being able to start typing or at times, pasting text. The start screen is often an unnecessary extra step for me and at times very annoying. For anyone in the same boat, there is a simple solution to this problem and that is to disable the start screen. It's an option that can be exercised on a per-app basis for the Office Suit and is very easily reversible. Read More

Import Your MS Office Dictionary To A Different PC Or Fresh Install

MS_Office_dictionary
Switching to a new PC is a daunting task that means installing lots of of apps again, and setting things up the way you had them on your old system. Setting up a new PC to work like your old one isn't an easy task but what's more time consuming is when your apps have to learn from scratch what your preferences are, or rather when you have to teach them that. This isn't that hard for apps that have an online service working at their backend but when we're talking about an app that functions entirely on our desktop with no way to export and import settings and user preferences, we run into a problem. MS Office now has an online version but it doesn't do much by way of importing or exporting settings and this can be a problem when you have something like the dictionary you created on your old system over the years. Here is how you can port your MS Office dictionary, complete with every change you've ever made to it, from your old PC to a new one. Read More

Clear The Recent Files List In MS Office Apps

recent_files_MS_Office
MS Office keeps a list of recently accessed files for each app in its Office suite. It's super useful if you're working on different files at the same time, and constantly switch between which one is open. Not only does it make it easier to locate a file you want to open, but it also makes the list accessible within other dialog boxes in the respective app so that you can link to it etc. As useful as the list is, it does lose its utility when it starts showing documents that you no longer need to access. Here's how you can clear the list and start a fresh one in any Office app. Bear in mind that the process is different for MS Office 2003 - 1020, and different for Office 2013. Read More

Hiding The Mini Toolbar In Office 2013

Word Options
Microsoft got a lot of heat with Windows 8 and loyal Windows users were disappointed with the company's attempt at innovation since it ended up sacrificing two of the most iconic features of the OS but Microsoft and its products aren't all a result of trial and error. Take a look at Office 2013 and you can see the company gets a lot of things right in just the one go. The Office productivity suite has everything you could ever need to make a solid well-formatted document, spreadsheet, or presentation. What's more is that it also features many auto-fill options and helpful pop-ups to make formatting and composing a document or presentation easier. That said, one of the chief annoyances is the Mini Toolbar that pops up in all office apps when you select text. For some, this might be helpful but it appears over the text and there isn't an easy way to dismiss it. You can  however, disable it, if it annoys you. Here's how. Read More

Remotely Control Word, Excel & PowerPoint From Windows Phone With MS Office Remote

Microsoft-Office-Remote-for-Windows-Phone-3.png
Microsoft Office has been the productivity suite of choice for many over decades, and is still going strong among its fans and those simply stuck with it alike, especially in the corporate sector. One major use of the suite is for presentations, but it isn’t always too convenient to manage the slides through the PC itself while giving a presentation. There are many tools out there to remotely control your presentations, both in form of dedicated hardware as well as apps for popular mobile platforms out there. If you are using  a Winodws Phone device, you no longer have to rely on any third-party tools for the purpose, as Microsoft has just released an official Office Remote app for Windows Phone that lets you remotely control Word, Excel and PowerPoint right from your phone. Read More

Disable Typing Animation In All Office 2013 Applications [Tip]

3.jpg
If you’ve started using the new Office 2013 (or version 15, as some may call it), you might have noticed the new typing animation. As you type, the animation is pretty obvious to note. Some may term it as a modern and contemporary addition to the flavor of the new Microsoft Office Suite while others would simply get annoyed. It is for such people that we present a registry hack to get rid of the fancy typing animation. This hack has a reversible effect and if you feel the need to revert to the default graphics, you are just a click away. Moreover, this will apply not only to Microsoft Word, Excel, PowerPoint and the like, the impact would hold for the entire suite. Through this post, we are in no way undermining the typing animation, but only presenting an alternative for the annoyed ones, out there. Read More

What’s New In Microsoft Outlook 2013? [Review]

Microsoft-Office-Outlook-2013-Preview
Microsoft recently announced the next version of Office suite – Office 2013 (codenamed Office 15). Steve Ballmer, the current CEO of the Redmond giant, unveiled Microsoft Office 2013 Consumer Preview, in San Francisco, but as of now, Microsoft is calling the new version as Office 365 Consumer Preview, and has made it available as Home, Small Business and Enterprise editions. This is the first time in history that the Office suite is designed by keeping desktop and touchscreen devices in mind, particularly when Windows 8 is just months away from its GA launch. One of the most powerful and frequently used applications in Office, is the Outlook. Outlook 2013, akin to other programs in the suite, has received much love from the developers, and now looks more polished and elegant. Basically, it’s the same old Outlook with an improved functionality, aesthetics and ergonomics. We decided to do a brief overview of the new Office Suite, and an in-depth review of the new features, changes and enhancements that are made to MS Outlook. Read More

What’s New In Microsoft PowerPoint 2013? [Review]

Microsoft-Office-Powerpoint-2013-Preview
With the release of Windows 8 GA on the horizon, Microsoft has unveiled the next version of their second biggest product, the Microsoft Office 2013. Right now, it is only the Consumer Preview, however, it provides ample basis for users to form an idea about what the final version will bring to the computing world. Graced with the same Metro style UI of Windows 8, the design and functionality of Microsoft Office 2013 has been streamlined to work with both PC’s and Tablet devices. Even though, at first glance it appears to be a lot different than its predecessor, it is essentially the same product, with a few tweaks and enhancements added here and there. The main focus has been on improving document sharing using the SkyDrive cloud service, and using it to access and edit them from remote locations. In this article, we will look at the enhancements of the old features and addition of new ones in the Microsoft PowerPoint 2013. Read More

What’s New In Microsoft Word 2013? [Review]

Microsoft-Office-Word-2013-Preview
With the recent launch of Office 15 at a media event, new trends have surely been set. The flurry of Windows 8, its metro user interface and a clean and resourceful look has brought in criticism from around the world, but the overall balance is being seen in Microsoft's favor, as it embarks upon technology integration, cloud-connectivity, and modern, touch-friendly outlook. In what follows, we will inform you exactly where Microsoft Word 2013 from the Office 15 Suite aims to reform your experience with documents. It is surely time to embrace text-flow, PDFs, collaborations, and the world wide web through a resourceful Office App Library for the better. A cleaner discussion thread and Microsoft SkyDrive integration promise a unique experience for the novice as well as advanced users. Read More

What’s New In Microsoft Excel 2013? [Review]

Microsoft-Office-Excel-2013-Preview
Some say that Office 15 is merely a polished look of the previous version, but a deep analysis of the Suite proves otherwise. Yes, times are changing and Microsoft is adapting with the new world by imparting a metro user interface initiated with Windows 8 and carried on in the new Office preview. With the modern feel and easy navigation experience acknowledged, cloud-based services using Microsoft SharePoint and SkyDrive allow you to collaborate like never before. Moreover, documents can be accessed on all devices from the mainframe to the touch-phone. A sleek and responsive workspace allows you to achieve productivity at a new peak. In this post, we will discover the new features in Microsoft Excel 2013 ranging from the new sharing options to Office Apps. Data organization has been simplified using Flash Fill, data analysis has been equipped with Quick Analysis and charting is now much more effective owing to the new Recommended charts option. Read More

OutlookAdressBookView: View & Export Outlook Address Books’ Contacts In HTML/CSV Format

OutlookAdress.png
Developed By Nirsoft, OutlookAddressBookView is a portable application for Windows that is designed to read contact information from all Outlook Address books and display the details in separate fields, allowing you to easily export the contact list(s) in XML and CSV, HTML and tab separated file format. Unlike Outlook plugins that require you to launch Outlook for performing address book-related tasks, this application doesn’t launch Outlook in the background to import the contact entries. It supports both IMAP and Microsoft Exchange account, and has the ability to read additional contact information for configured Exchange account such as Address Type, Contact Created/Modified Time etc. Just like other Nirsoft’s utilities, it enables users to export only selected entries from the list to local/remote location. You also have the option to view the complete contact information of specific contact in a separate dialog. More details after the break. Read More

ContactSync: Sync Specific Outlook Contacts Groups With Network Users

contact-sync-main.png
Want to share specific Outlook Contacts group across the network users, but don’t want the fuss of having to manually pick and send contact cards from Address Book and send them to connected users? Meet ContactSync, an ingeniously simple, yet powerful Outlook 2010 add-on that lets you effortlessly share a specific contact group with anyone connected to your network. It is basically developed to let users easily share their business contacts with their co-workers and keep their shared contact groups synced all the time. It allows you to change the shared contact group, add, remove and edit contacts and replace the currently synced shared contact category with any contact group of your choice. In addition, ContactSync implements duplicate conflict resolution technique for de-duplication of shared contacts. When you share a contact, it immediately looks for contact with similar name and email address to prevent saving duplicate entries in shared contact group. It also uses FileAs and Email fields identify the same contact. Read past the jump for details. Read More

Split Outlook 2010 Storages / Email Account Folders By Size & Year [Addin]

split-storage-1.png
Like previous MS Outlook versions, Outlook 2010 saves each email account related files and folders including mailboxes in PST file, which can be used with any Outlook version to quickly restore the account mail items and folders. Although Outlook lets you associate PST files with new/existing email accounts, it often stops responding when large PST files are imported. If you’re planning to move or create backup of PST files, we recommend using Split Storage to split Outlook / email account storages into small PST files by Year and specified Size. It’s basically an add-in for Outlook 2007 and Outlook 2010, which allows you pick the email account storage and spilt it according to your requirements. Additionally, it creates new PST files, and splits storages while copying the data from the specified storage into a new PST. Since it only reads the data from existing PST files, it doesn’t make any changes to PST/OST archives. Read More

OutlookParameterGUI: 30 Switches To Run Outlook In Required Mode

outlookparameterGUI-main.png
Since Outlook supports a variety of plugins, add-ons and other third-party tools’ connectors, it’s highly prone to PST/OST file corruption and other like attacks. Finding out problems with PST, OST and old email archive files isn’t easy, and takes a lot of time as well as effort to identify the root cause of the issue. Sometimes, Outlook stops responding due to the presence of incompatible add-ins, and this not only makes it difficult to find the add-ins, but also to permanently delete them. If you often encounter fatal errors, add in exceptions etc while using Outlook 2010, you probably need to install OutlookParameterGUI to easily identify the issues. The application is meant for launching Outlook with different switches. It supports a total of 30 widely used command line switches for Outlook.exe file, which are used to identify and troubleshoot Outlook-related problems. Instead of using a command line tool to invoke Outlook.exe with a certain switch, you could this application to select the required switch to launch Outlook in required mode. Read More