How to remove empty rows in Excel
- Ctrl + G
- Alt + S (go to special)
- select “blanks” + enter
- ctrl + – (to shift cells up)
How to remove number / numbering in Excel
- Copy the exact content WITHOUT the numbering, and paste it to the cell right next to it
- Data > Flash Fill