| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing external data
How do I insert an entire row beyond the data range when importing external
data? My problem is the adjacent data does not get a row inserted. The data range properties appear to only insert an entire row within the data range. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Importing external data
TLR
Click on the Data Range Properties button on the External Data Toolbar. There are three option buttons near the bottom. Select the one that says "Insert entire rows..." See here for pictures http://www.dicks-blog.com/archives/2...rties-options/ -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com TexasLakeRat wrote: How do I insert an entire row beyond the data range when importing external data? My problem is the adjacent data does not get a row inserted. The data range properties appear to only insert an entire row within the data range. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing External Data | Excel Discussion (Misc queries) | |||
| Importing External Data | Excel Discussion (Misc queries) | |||
| Importing External Data | Excel Discussion (Misc queries) | |||
| Importing External Data | Excel Discussion (Misc queries) | |||
| Importing external data | Excel Programming | |||
Linear Mode
