Compress Excel Workbooks/Reduce File Size

It is a question these days if Excel workbook file size could be limited so that it doesn’t increase in MBs.  Most of the users just care about feeding in data/copy pasting them/formatting them. But none really cares to remove unwanted cells/default formatting in every sheet which causes the file size to increase. Following list […]

Multi-book desktop shortcut – Open Workbooks Simultaneously

Say, if you are preparing annual report say, AR.xlsx and there are four quarterly report files named Q1, Q2, Q3 and Q4 that you need to open and work with all these five files simultaneously. To do so, try to open them once from their individual locations one by one wherever they are saved.  Then, […]

Help about MS Office Help Window


Fun with Excel Charts – India Map

The below India map has been created using Excel Chart.

Fun with Excel Charts – Designs

Can you try these in Excel Charts?

40 Deadly Shortcut Keys in Excel

Key What it does Home Beginning of the row CTRL+Home Beginning of the region CTRL+End End of the region Shift + F11 Insert new worksheet Ctrl+Enter Fill the selected cell with current entry Ctrl+Delete Delete till end of line Ctrl+Delete Fill down Ctrl+R Fill right Ctrl+F3 Define a name Shift + F3 Paste a function […]

Office 2007 Compatibility Issues – _xlfn prefix error in Excel 2003

Problem: When you try opening and Excel 2007 file in earlier version of Excel, you will notice an _xlfn prefix is displayed in front of a function in a formula. When the formula is calculated, it displays the #NAME? error value. Cause: Microsoft Office Excel workbook contains a function that is not supported in the […]

Office 2007 Compatibility Issues – Uninitialized ActiveX controls will not be opened in this version of Excel

I have been working with Office migration from version 2003 to 2007/2010. I faced quite a few problems in my earlier stages and it took lot of time to figure out the exact solution for some simple problems. So, thought it would be useful for someone who also involved in the migration. Problem: Macro enabled […]

VLookup Function

Function Description: Vlookup stands for ‘Vertical’ lookup. This function searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. Syntax: VLookup(lookup_value, table_array, column_index_number, range_lookup) in simpler terms we can also say VLookup(ItemtoFind, RangetoFind, ColumntoPickValueFrom, SortedorUnsorted) Example: A B […]