Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IS THERE A WAY TO INSERT MORE THAN ONE ROW AT A TIME IN A WORKSHE
Is there a way of inserting multiple blank rows in between multiple rows of
data at once. So that the rows of data have identicalal rows of spacing. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IS THERE A WAY TO INSERT MORE THAN ONE ROW AT A TIME IN A WORKSHE
1 - in an unused column, enter sequential #s for the current data,
(1,2,...50) 2 - Copy the whole range of #s 3 - If you want to insert x blank rows, paste the numbers x times below the current data. So if you want to insert 2 blank rows, in cell J51 (for example) paste the values, then again in cell J101 paste the values. You'd now have 1,2,...,50,1,2,...,50,1,2,...50. That is, 3 sets of #s from 1-50. (If you had 200 rows you'd have 3 sets of #s from 1 to 200). 4 - select all your data, and sort by this column of numbers (J in this example). Clear column J and you're done! From my book, This isn't Excel, it's Magic, page 111. http://www.iil.com/iil/excelmagic. Bob Umlas "Chris" wrote in message ... Is there a way of inserting multiple blank rows in between multiple rows of data at once. So that the rows of data have identicalal rows of spacing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Any quick key to insert current Date and Time? | Excel Discussion (Misc queries) | |||
Insert spinning button with time format in Excel 2000? | Excel Discussion (Misc queries) | |||
Insert Row-First time user | Excel Discussion (Misc queries) | |||
I need to know how to insert my information, time and tides in ex. | Charts and Charting in Excel |