LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
PL PL is offline
external usenet poster
 
Posts: 58
Default Inserting blank rows

Hi

I have 10 consecutive rows of data. I wish to insert a blank between each of
these 10 rows, is there a formula or method I can use to do this quickly? I
don't wish to manually insert the rows.

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting blank rows plus using Sum Bill95051 New Users to Excel 3 April 8th 09 07:38 PM
Inserting Blank rows between items JB Excel Discussion (Misc queries) 6 June 5th 08 01:06 PM
Inserting blank rows in Excel. kwm5321 Excel Discussion (Misc queries) 3 December 1st 06 12:19 AM
Inserting Blank rows after every row upto 2500 rows Manju Excel Worksheet Functions 8 August 22nd 06 12:54 PM
Inserting Blank Rows Macro? Michael Saffer Excel Worksheet Functions 2 November 9th 04 06:23 PM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"