While working on excels with tremendous amount of data, it is desired many a times to track if the current cell alignment is corresponding to right column or to make sure data is entered in a correct cell. This issue arises frequently when the excel worksheet is stuffed with loads […]
How to Remove Background from a picture in Office 2010
Published on :Background Removal is a new feature in Word, Excel, PowerPoint and Outlook that makes the process quick and easy for any picture. No expensive photo editing package required and no need to learn the cumbersome process of selecting and removing portions of the image. The Office Background Removal tool doesn’t […]
Creating A Hyperlink In Excel
Published on :An Excel hyperlink gives the reader quick access to related information in another file or on a Web page. In addition to being able to insert hyperlinks into cells, you can also insert them into specific chart elements. Links usually open web pages, but they can also lead to pictures, […]
Disable Read-Only Protected View in Office 2010
Published on :Office documents, presentations or spreadsheets being downloaded from Internet are open to any form of Macro viruses that may harm the system. Microsoft Office has always been susceptible to a variety of security threats, ranging from macro viruses to exploits of embedded vulnerabilities. Generally frequent updates, patches, and third-party security […]
Handy Shortcuts in Excel 2010
Published on :Covering a few of Excel keyboard shortcuts and a few other little tricks that helps work faster. F9 – Partial formula evaluation F9 is really helpful for debugging complex formulas, because it allows you to select smaller pieces of your formula and evaluating just that highlighted part. To try it […]
Enable and Add Text to Speech feature in Office 2010
Published on :In Office 2010, one of new features is an on-the-fly translation feature called Mini Translator. The Mini Translator allows you to translate single words or many paragraphs simply by hovering over the text that you want to translate. Mini Translator also includes the ability to Speak that text using Microsoft’s […]
Analyze data efficiently & quickly in Excel 2010 using Sparklines
Published on :Sparklines are a new kind of visualization in Excel 2010. They are small cell-sized graphics used to show trends in series of values by using line, column, or win/loss charts. Sparklines allow the viewer to see in a single cell information-dense graphics that greatly increase reader comprehension of the data. […]
Wrap text using Ribbon option in Excel 2010
Published on :Microsoft Excel 2010 comes with another handy feature which is used to wrap text in long lines. However, this feature was present earlier as well, but with Office 2010, Microsoft has made this feature into ribbon and much more easily accessible. Wrap text features makes all content visible in a […]
Change Orientation of cell Text in Excel 2010
Published on :Excel 2010 comes with a handy feature known as Orientation that can rotate your text to a diagonal angle and vertical orientation and many others. To change the orientation of a cell, click the selected text .and click orientation and select any orientation from there. Clicking the orientation button […]
Import Phone Contacts from Excel to Office Outlook 2010
Published on :Many of Phone manufacturers provides an option to save mobile phone contacts in a CSV (comma separated value) format or an excel sheet. If you are moving to a Windows phone you may have all your contacts in outlook. So here is a guide how to convert your mobile phone […]