| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add a blank row after each existing row?
Jim - amazing solution. Thanks!
"Jim Cone" wrote: You can do that by sorting a helper column. In a adjoining blank column, auto fill it with numbers from 1 to 200. Directly below the new data, autofill another 200 rows with numbers from 1.1 to 200.1. (just enter 1.1 in the first cell and 2.1 in the next cell and fill down) Sort by the new column, clear the new column. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Stephanie" wrote in message I have a set of data (200 rows /8 columns). I need to insert a blank row after each row of data... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a blank in Data Validation List? | Excel Discussion (Misc queries) | |||
| Counting blank cells until value is reached | Excel Worksheet Functions | |||
| Setting Purely BLANK Cell | Excel Worksheet Functions | |||
| CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Hybrid Mode
