ms excel help

  1. S

    How to merge cells automatically as I type and how to assign tooltip to new customized button in ms excel?

    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...
  2. S

    How to remove the specific line from excel sheet?

    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...
  3. T

    Macro related problem....please help...

    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...
  4. B

    MS Excel help

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top