Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 117
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert cell data from one sheet to another arvinylPE Excel Discussion (Misc queries) 4 October 10th 07 10:39 PM
Formula or Macro to insert Data in Cell when having more than 7 Functions pwk Excel Worksheet Functions 4 January 22nd 07 07:12 PM
can excel insert rown based on variable data in a cell? SSBG Excel Worksheet Functions 1 August 6th 06 01:30 PM
Insert sheet, move to end, rename with cell data. [email protected] Excel Discussion (Misc queries) 2 October 11th 05 03:04 PM
Possible to insert cell data in the middle of line of text? Bob Smith Excel Worksheet Functions 6 July 29th 05 08:14 PM


All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"