How to Generate Transport or Delivery Challan E-Way Bill (Without Tax)

1. First =>Login on your Account of GST "https://ewaybillgst.gov.in/login.aspx"

2. Second=> Under e-Way bill option Click on "Generate New"

3. Third => Under e-Way bill option Click on "Generate New"

4. Fourth => Under subtype Option Select "Other" Option and Fill "Delivery Challan"

5. Fifth =>  Under Document Type Select "Delivery Challan"

6. Sixth => Fill the item details. After filling the amount of the product. Select IGST "0%".

7. Seventh=> Submit the E-Way Bill.

How to Insert the Degree Symbol in MS Word?

1. First of open Word File then Select where you want to place the degree sign

2. Second While holding down the Alt key, use the keypad to type “0176.” Release the Alt key, and the degree sign will appear.

3. Or you can copy directly below & Paste on your word file.

                 °

4. Done

How to compress Multiple Folders to Separate Archive (RAR)

1. First of all You need winrar Software.

2. Second Select the Multiple Folder which you want to Compress to Separate Archive

3. Then go to File Tab and Select "Put each file to separate archive".

4. Done

How to Deleting rows containing bold text in Excel

1.  First open VBS (Alt + F11)

2. Then Select Sheet and Paste Below Code 

3. Last Step Run Macro (F5).

4. That's it.

Sub del_rows_with_bold()    ' David McRitchie, 2005-09-01     Application.ScreenUpdating = False     Application.Calculation = xlCalculationManual     Dim Rcnt As Long, Ccnt As Long, r As Long, c As Long     Dim CurrCell As Range     On Error Resume Next     Rcnt = Cells.SpecialCells(xlLastCell).Row     Ccnt = Cells.SpecialCells(xlLastCell).Column     '-- check up to row 2 from the bottom     For r = Rcnt To 2 Step -1        '-- check all cells on row beginning at column 1        For c = 1 To Ccnt          If Cells(r, c).Font.Bold And Not IsEmpty(Cells(r, c)) Then             '-- Must be bold and have content             Cells(r, c).EntireRow.Delete             GoTo next_r         End If       Next c next_r:     Next r     Application.Calculation = xlCalculationAutomatic     Application.ScreenUpdating = True End Sub

How to Enable Dragging option in Excel

Display or hide the fill handle

By default, the fill handle and drag-and-drop editing is turned on in Excel so that you can drag the mouse to move and copy cells by doing the following:

• Move a cell or range of cells by positioning the mouse pointer on a cell or cell range border so that it changes to a move pointer and then dragging the cell to another location.
• Copy a cell or range of cells by holding down CTRL while you position the mouse pointer on a cell or cell range border so that it changes to a copy pointer and then dragging the cell or range of cells to another location.
• Drag the fill handle to copy data or to fill adjacent cells with a series of data.

You can turn this option on or off as needed by doing the following:

1. Click File > Options.
2. In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box.

Note: To help prevent replacing existing data when you drag the fill handle, make sure that the Alert before overwriting cells check box is selected. If you do not want Excel to display a message about overwriting non-blank cells, you can clear this check box.