Excel – how to remove or separate numbering in cells

How to remove empty rows in Excel

  1. Ctrl + G
  2. Alt + S (go to special)
  3. select “blanks” + enter
  4. ctrl + – (to shift cells up)

How to remove number / numbering in Excel

  1. Copy the exact content WITHOUT the numbering, and paste it to the cell right next to it
  2. Data > Flash Fill