inserting row
How can I insert a row above a cell that contains data?
In the following example, I want to insert another row above cells A3, A5, A11 and A14. row col A 1 111021001-7 2 3 112411015-2 4 5 116141013-4 6 7 8 9 10 11 116151002-5 12 13 14 118103010-7 |
inserting row
Select the row above which you want to insert a row, right click and select
insert. Then buy a book on Excel, read it and enjoy! Tyro "GARY" wrote in message ... How can I insert a row above a cell that contains data? In the following example, I want to insert another row above cells A3, A5, A11 and A14. row col A 1 111021001-7 2 3 112411015-2 4 5 116141013-4 6 7 8 9 10 11 116151002-5 12 13 14 118103010-7 |
inserting row
I know how to insert rows but, considering there are 5,000 cells in
COL A but only 1,200 that contain data, is there a formula that I can write to do this less manually? =============================== On Apr 27, 8:39 pm, "Tyro" wrote: Select the row above which you want to insert a row, right click and select insert. Then buy a book on Excel, read it and enjoy! Tyro "GARY" wrote in message ... How can I insert a row above a cell that contains data? In the following example, I want to insert another row above cells A3, A5, A11 and A14. row col A 1 111021001-7 2 3 112411015-2 4 5 116141013-4 6 7 8 9 10 11 116151002-5 12 13 14 118103010-7 |
inserting row
Select column A
Edit|Goto|Special|Constants (assuming that these are not formulas) insert|Row (in xl2003 menu system) GARY wrote: How can I insert a row above a cell that contains data? In the following example, I want to insert another row above cells A3, A5, A11 and A14. row col A 1 111021001-7 2 3 112411015-2 4 5 116141013-4 6 7 8 9 10 11 116151002-5 12 13 14 118103010-7 -- Dave Peterson |
All times are GMT +1. The time now is 09:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com