How to Highlight / Flash Cell Contents of Excel Files using Macros
If you have certain data in MS Excel cells that needs to be highlighted and brought attention to, merely changing its font attributes may not always serve the purpose. You can try some simple macros to make your cell contents flash instead. First you need to define a cell style. To do so, carry out […]
How To Compare Excel Spreadsheets
Microsoft Excel is a powerful package to manage numbers, and comparing Excel spreadsheets is always a huge task if you are not good with it. So, here is free tool with which you can compare Excel spreadsheets, individual ranges as well as other Excel files. Excel Compare is amazingly user friendly and just at the […]
Determine the Last Day of the Month Easily using Integrated Function in Excel
You often need to check the last day of a particular month for due dates and deadlines. You want to automate this determination of the right date in order to avoid any errors caused due to leap years, for example. The table function ‘EOMONTH’ helps in calculating the correct date. In the older versions of […]
How to Save and Apply Filter settings Quickly in Excel
Microsoft Excel has effective filter functions for evaluation of table data. Separate filters can also be set for individual columns. This may be good, but you have to set the criteria newly each time after editing the data. Now that’s tedious. Though there is no evident function to save the filter settings, a user-defined view […]
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 […]
Older Posts »