Agar ap ki sheet isi pattern ki hai matlab 3 columns by 2 rows then:
1. Press Alt+F11 to Open Visual Basic for Applications.
2. Insert-->Module
3. Paste this code into that Module
Code:
Sub Merge()
Selection.Range("C1").Value = Selection.Range("C1").Value + Selection.Range("C2").Value
Selection.Range("A2:C2").ClearContents
Selection.Range("A2").Select
End Sub
4. Press Alt+Q to return to Excel Worksheet.
5. Press Alt+F8 to open Macro Dialog Box.
6. Click Options and set you hotkey like... Ctrl+m
7. Click OK and then Press [Esc].
ab jab bhi rows ko merge karna ho un cells ko select karain jaisay ap k screenshot main "B6 : D7" ki range hai. phir Ctrl+m press karain and you are done.
Bookmarks