ms excel help

Friends, I want that when i type in excel sheet it should merge the cells automatically. For example as I start typing from cell no A1 and continue typing to cell no E1 then the range from A1 to E1 should automatically be merged. Moreover I want to assign tooltip to the new customized buttons...

I have merged two ranges in excel sheet, but it is leaving one line between the merged area of the both ranges. I wish to remove this line but could not succeed. I have adopted many ways but everything failed. I am attaching the image of excel sheet showing which line I want to remove. Please...

hi i hv created a macro for a wrkbook involving three sheets. the first being the master sheet the second is a pivot table sheet. now by the macro i aim to automate the process of selecting the data from the pivot table sheet and copy it to the third sheet and then format this data to a preset...

Hi, I have a excel spreadsheet which has order in one column and event1 and event2 in two other columns.One order can have multiple events.In the given spreadsheet. When an order has muliple events, then except first record, all other cells of order column is NULL. I want to populate those null...