ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert ROW above a cell containing data (https://www.excelbanter.com/excel-discussion-misc-queries/185304-insert-row-above-cell-containing-data.html)

GARY

Insert ROW above a cell containing data
 
How can I insert a ROW above a cell that contains data? (In my
spreadsheet, COL A has 985 cells but only 284 cells contain 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

Tyro[_2_]

Insert ROW above a cell containing data
 
Please stop posting the same question

Tyro

"GARY" wrote in message
...
How can I insert a ROW above a cell that contains data? (In my
spreadsheet, COL A has 985 cells but only 284 cells contain 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





All times are GMT +1. The time now is 07:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com