Quick trick to alternate rows of data

If you need to insert a blank row after every row of data, inserting rows one by one is extremely inefficient — how can you do this quickly?

  1. First insert a helper column next to the data.
  2. In the helper column enter a sequence starting at 1; for example, if there are 10 rows, enter 1–10.
  3. Then, beneath cell 26, enter the 1–10 sequence.
  4. Select the original data and the helper column, then sort by the helper column in ascending order.
  5. Delete the helper column.
  6. Completed
[Hide] Join our 'Office Suite Real-Time Support' free Facebook group to learn more about Office. View details
Easter promotion: April 19–22, 2019 — sign up for 12 months of real-time Office suite support and get 10% off! What to do when you encounter Office problems at work? Can't write Excel formulas and don't want to ask colleagues and reveal your Excel level? Just WhatsApp us! Service details:bit.ly/FyndproSupport

The End

, , ,

•

,
WhatsApp Support

CELL COLUMN COUNTIF Excel Excel formulas Excel functions FILTER FIND IF INDEX LEFT LOOKUP MATCH MAX Microsoft Excel MID Office suite PowerPoint RIGHT ROW SEQUENCE SUM SUMIF SUMPRODUCT Unique VLOOKUP Windows Windows 10 Word Find and Replace Line Break number formatting Text to Columns date calculation Time Flash Fill Conditional Formatting Column background removal wildcards data analysis data cleaning Error messages Array formulas Color

Comprehensive Technical Support Solutions

We provide a range of technical support solutions to meet your needs.
Explore our core services:

man and woman wearing headphones while working in the office

Real-Time Technical Support

Learn More

Get on-demand assistance with Microsoft Excel, Word and PowerPoint. Send your question via WhatsApp, and we will help you resolve it promptly.

serious diverse students looking at laptop

Online Learning Group

Learn More

Join our Online Learning Group Facebook page. Explore more than 200 tutorials and a comprehensive library of instructional videos at your own pace.

woman in yellow blazer doing a presentation

Corporate Training

Learn More

Build your team’s skills with tailored corporate training programmes. Our courses are designed around your organisation’s needs and equip employees with practical, up-to-date tools.