Posts

How to Embed Flash in Excel (Office Applications)

Export Excel 2007 Charts to Powerpoint 2007 Slides

Difference between SUMIF and SUMIFS Function: Excel Formulas & Functions

Calculate Business Working Days between two dates (Excluding Saturdays and Sundays)

Select or Color Alternate Even/Odd Columns

Select or Color Alternate Even/Odd Rows

Change Polarity or Number Sign

Convert Numbers to Text (To Append or Prefix Zero)

Convert Numbers appearing as Text to their Values (Number Format) (Remove Green Sign)

Convert Formulas to Values

SuperScript or Subscript the First or Last Character of Text in Selected Range Cells

Rainbow color the Text

Extract Alphabets (Remove Digits) from Selected Range

Extract Digits (Remove Alphabets) from Selected Range

Reverse the text in selected cells (Mirroring/Plain Encryption of Text)

Use of Random Function (Rnd) and Select Case statement

Delete or Remove Event Macros, VBA Code and Module

Force Save and Unsave of Workbooks

Invert the Selection

UnProtect all WorkSheets in the WorkBook

Protect all WorkSheets in the WorkBook

Sort all worksheets on the basis of Sheet names

Color all sheet tabs in the workbook

Delete/Remove Blank/Empty Worksheets

Insert 'n' number of worksheets in Active workbook

Copy Excel Worksheets to Microsoft Word

Change Picture or Image Location

Color only a part of cell using Macro or REPT Function

Excel Formulas & Functions: How to use VLOOKUP Function?

Delete/Remove Blank/Empty Rows/Columns

Access Search Engines on Browser (Internet Explorer) using VBA/Excel

Excel Add-ins and Products Downloads