query destination field

A

albert

How do you change a destination field of a query in Excel? I have the data from the query being sent to cell A4 but need it to go to cell A1.

I tried the "edit query" option but with no luck
 
D

Dick Kusleika

albert

I think you can just delete Rows 1:3 and it will adjust accordingly.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

albert said:
How do you change a destination field of a query in Excel? I have the data
Click to expand...
from the query being sent to cell A4 but need it to go to cell A1.
 
D

Debra Dalgleish

Select the sheet that contains the query results
Click the dropdown arrow in the Name box, to the left of the Formula bar
Select the query range, e.g. Query_from_MS_Access
Drag the selected range so the top left cell is in A4
 
Top