| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Any button to insert blank rows at specific interval?
Hi
I understand that the user could delete blank rows in a worksheet at one go by going to F5 Special Select blank rows and press delete to remove it. In the reverse, if I wish to insert empty rows at specific interval of 3 or 4 rows to a block of compact data (without any empty rows in beween), may I know if there is any key board steps for this ? At prersent I only can do it by assigning repeated even or odd number to the block of cell and then do a sorting after replacing the missing even or odd numbers. Illustration xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx Thanks Low A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Any button to insert blank rows at specific interval?
hi
to add a row or group of rows.... high light the row or group of rows. on the keyboard, press Ctrl + Plus keys. a row will be added below the cell pointer. to delete(remove) a row or group of rows.... high light any row or group of rows. on the keyboard, press Ctrl + minus keys. pressing the Ctrl + Plus key without high lighting the row, adds a cell pressing the Ctrl + minus key without high lighting the row, removes a cell regards FSt1 "Mr. Low" wrote: Hi I understand that the user could delete blank rows in a worksheet at one go by going to F5 Special Select blank rows and press delete to remove it. In the reverse, if I wish to insert empty rows at specific interval of 3 or 4 rows to a block of compact data (without any empty rows in beween), may I know if there is any key board steps for this ? At prersent I only can do it by assigning repeated even or odd number to the block of cell and then do a sorting after replacing the missing even or odd numbers. Illustration xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx Thanks Low A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Any button to insert blank rows at specific interv
The closes to a keyboard/mouse solution I can think of is as follows;
Select every third or fourth row... Right-click and choose Insert... it will insert a row before each selected row... If you select rows in groups of two you will get new rows in groups of twos... Otherwise you need to have a marcro and assign a short-cut to it. "FSt1" wrote: hi to add a row or group of rows.... high light the row or group of rows. on the keyboard, press Ctrl + Plus keys. a row will be added below the cell pointer. to delete(remove) a row or group of rows.... high light any row or group of rows. on the keyboard, press Ctrl + minus keys. pressing the Ctrl + Plus key without high lighting the row, adds a cell pressing the Ctrl + minus key without high lighting the row, removes a cell regards FSt1 "Mr. Low" wrote: Hi I understand that the user could delete blank rows in a worksheet at one go by going to F5 Special Select blank rows and press delete to remove it. In the reverse, if I wish to insert empty rows at specific interval of 3 or 4 rows to a block of compact data (without any empty rows in beween), may I know if there is any key board steps for this ? At prersent I only can do it by assigning repeated even or odd number to the block of cell and then do a sorting after replacing the missing even or odd numbers. Illustration xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx Thanks Low A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Any button to insert blank rows at specific interv
supplimental.
you can do the same thing with columns but selecting a column instead of a row. regards FSt1 "FSt1" wrote: hi to add a row or group of rows.... high light the row or group of rows. on the keyboard, press Ctrl + Plus keys. a row will be added below the cell pointer. to delete(remove) a row or group of rows.... high light any row or group of rows. on the keyboard, press Ctrl + minus keys. pressing the Ctrl + Plus key without high lighting the row, adds a cell pressing the Ctrl + minus key without high lighting the row, removes a cell regards FSt1 "Mr. Low" wrote: Hi I understand that the user could delete blank rows in a worksheet at one go by going to F5 Special Select blank rows and press delete to remove it. In the reverse, if I wish to insert empty rows at specific interval of 3 or 4 rows to a block of compact data (without any empty rows in beween), may I know if there is any key board steps for this ? At prersent I only can do it by assigning repeated even or odd number to the block of cell and then do a sorting after replacing the missing even or odd numbers. Illustration xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx Thanks Low A36B58K641 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Any button to insert blank rows at specific interv
Hi,
Thanks. Low -- A36B58K641 "FSt1" wrote: supplimental. you can do the same thing with columns but selecting a column instead of a row. regards FSt1 "FSt1" wrote: hi to add a row or group of rows.... high light the row or group of rows. on the keyboard, press Ctrl + Plus keys. a row will be added below the cell pointer. to delete(remove) a row or group of rows.... high light any row or group of rows. on the keyboard, press Ctrl + minus keys. pressing the Ctrl + Plus key without high lighting the row, adds a cell pressing the Ctrl + minus key without high lighting the row, removes a cell regards FSt1 "Mr. Low" wrote: Hi I understand that the user could delete blank rows in a worksheet at one go by going to F5 Special Select blank rows and press delete to remove it. In the reverse, if I wish to insert empty rows at specific interval of 3 or 4 rows to a block of compact data (without any empty rows in beween), may I know if there is any key board steps for this ? At prersent I only can do it by assigning repeated even or odd number to the block of cell and then do a sorting after replacing the missing even or odd numbers. Illustration xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx Thanks Low A36B58K641 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: Any button to insert blank rows at specific interv
Hi, Sheeloo,
Thanks Low -- A36B58K641 "Sheeloo" wrote: The closes to a keyboard/mouse solution I can think of is as follows; Select every third or fourth row... Right-click and choose Insert... it will insert a row before each selected row... If you select rows in groups of two you will get new rows in groups of twos... Otherwise you need to have a marcro and assign a short-cut to it. "FSt1" wrote: hi to add a row or group of rows.... high light the row or group of rows. on the keyboard, press Ctrl + Plus keys. a row will be added below the cell pointer. to delete(remove) a row or group of rows.... high light any row or group of rows. on the keyboard, press Ctrl + minus keys. pressing the Ctrl + Plus key without high lighting the row, adds a cell pressing the Ctrl + minus key without high lighting the row, removes a cell regards FSt1 "Mr. Low" wrote: Hi I understand that the user could delete blank rows in a worksheet at one go by going to F5 Special Select blank rows and press delete to remove it. In the reverse, if I wish to insert empty rows at specific interval of 3 or 4 rows to a block of compact data (without any empty rows in beween), may I know if there is any key board steps for this ? At prersent I only can do it by assigning repeated even or odd number to the block of cell and then do a sorting after replacing the missing even or odd numbers. Illustration xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx Thanks Low A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i insert blank rows between data that is thousands of rows | Excel Discussion (Misc queries) | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| How can I insert a blank row after every four rows in Excel? | Excel Discussion (Misc queries) | |||
| How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
| Insert blank rows repeatedly between every data row in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
