| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i insert a row every five lines in excel
I have an extremely large excel spreadsheet, filled with names and addresses,
which is 5 rows, to make the spreadsheet more readable, i would like to insert a line every five rows. Is this possible, with out doing it manually. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i insert a row every five lines in excel
=IF(MOD(ROW(),6)=0,"",OFFSET(A$1,ROW()-1-INT((ROW()-1)/6),0))
does it on Col A when entered in Col B. "Yogibear" wrote: I have an extremely large excel spreadsheet, filled with names and addresses, which is 5 rows, to make the spreadsheet more readable, i would like to insert a line every five rows. Is this possible, with out doing it manually. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Deleting Lines in Excel | Excel Discussion (Misc queries) | |||
| How do I change a data series from bars to lines in an Excel char. | Charts and Charting in Excel | |||
| insert a JPEG into EXCEL 2002 | Excel Discussion (Misc queries) | |||
| Add more lines and more columns in Excel | Excel Worksheet Functions | |||
Linear Mode
