Define Validation Rules to Permit / Allow only Correct Data Entries in MS Excel Tables
Sometimes the values or the entries in a worksheet of an Excel file may not be inputted according to the required specifications. You can avoid it by defining validation rules for worksheet entries and can restrict an entry to particular, allowed values. Thus, the data entries entered into your MS Excel document can be allowed [...]
Create PDF from Office Applications – Save a Word or Excel File as PDF / XPS
Adobe’s PDF has established itself as a cross-platform document format. Even MS-Office can work with it directly. It is expensive to create PDF files from Adobe Acrobat Professional. Here is a small plugin for Microsoft Office allows you to save a Word or Excel file directly as a PDF or XPS. There are methods to [...]
How to Calculate Faster in Excel using Goal Seek
Excel has a lot of functions which make your life easier. One such feature is Goal Seek. It can be used to help you speed up your calculations. Goal Seek is part of a suite of commands sometimes called what-if analysis tools. When you know the desired result of a single formula but not the [...]
How to Use Multi-Lined Custom Formats in Excel Cells
Formatting cells to suit your requirement in Excel is one of the easiest tasks to perform. Excel is flexible enough to let you customize formats to suit your needs as well. But what if you require two lined custom formats in Excel? You can use the wrap text feature of Excel but that depends on [...]
How to Assign / Define Names To Formulas in Excel – Use Formulas Easily
Formulas are very much useful in Excel Sheets to calculate complex equations easily. Microsoft Excel has no way to paste commonly-used formulas. You can make your formulas more accessible by assigning names to your formulas. This tip will let you use any of your excel formulas by just using the defined name in the space [...]
How to Add Pictures or Texture Fill to Auto Shapes in Excel
The Auto shapes in Excel 2007 can be made to look more interesting and personalized by changing the shape fill of the image. Adding pictures to your shapes gives a new look and feel to it. Besides adding pictures you can also change the stroke color of the shape and also fill gradient effects and [...]
Differentiate Data In Excel without Sorting – Value Based Shading
If you need to differentiate between data without sorting it, you can do it with ease in Excel 2007. Using the "Conditional Formatting" rules in Excel 2007, you can easily segregate even numbers from the odd numbers in your data. This is called Value based Shading which means adding color to specific value types. With [...]
Function Key – Keyboard Shortcuts of Microsoft Excel
Keyboard shortcuts are always best way to do your tasks quickly. There might be situations where you are in a hurry to complete your work, and are delayed especially when you heavily rely on the mouse to perform mundane yet essential tasks. These simple yet essential keyboard shortcuts can come to your rescue at such [...]
How to Search Online using MS- Excel – Perform Research on Any Topic
Would you like to research stock quotes, find definitions to complex words and even search for encyclopedia entries? You can do all this and more by using MS Excel. Using this tip, you can search online for anything you like from Excel Window. This will be useful if you don’t want to switch tabs every [...]
LikeOffice Excel Utility – Feature Rich Addon to Simplify your Work
LikeOffice Excel Utility is an Excel Addon which simplifies your work. It has got many features which will lets you do complicated tasks easily. Once installed it creates a new LikeOffice item to the menu in Excel 2003 or a new LikeOffice tab is added to the ribbon in Excel 2007. The features in the [...]
How to Show Formulas and Calculated Results in Excel
You can customize your Excel spreadsheets to display only formulas instead of results. This can be especially helpful when you are creating a report or conducting analysis of documents from the data computed by someone else. However, it will serve little or no purpose if you have either just the formulas or only the data. [...]
Office Tab – Tabbed Browsing in Ms-Office – Word, Excel, Powerpoint
Office Tab is a small add-on which will bring tabbed browsing to Microsoft office. Generally every new word document or excel worksheet or powerpoint slide we open opens up in a new window and this occupies a lot of space on taskbar and also its hard to manage all the windows. With this application, you [...]
