how to select a range of contents from a col which lies in between other columns

[sumesh56]

i have a worksheet in which column A:C contains slno,name etc. Col D contains numerical data.D4:D5 is col heading. D6:D41 contains numerical data. I want to copy the data from D6:D37 only. for this i tried the following but with negative result.
1.select cell D5.
2.press F5 and enter -to goto cell D37.
3. press control and shift and up arrow to select the upper cells. Excel selects from D37 to D4 whereas i want it to be from D37:D6.selecting D6 and then press control shift and enter keys takes me to the last cell with the data in the column, ie,D41.
how can i select only the required cells so that i can copy the content.selecting the first cell and then dragging the cross is not an expected answer to solve this issue.thanks.

[BB1972]

I want to copy the contents from D6:D37 only.
how can i select only D4:D37 and copy the data in those cells

I'm unsure whether you want D4 or D6 to D37...

on cell C37 press control shift and the up arrow to go upwards selecting.

I'm also unsure where C37 comes into this? If you want to copy the contents of a range of cells, highlight the range, by either single-clicking on the first cell and dragging the mouse to the last cell you want included, or by single-clicking on the first cell, and holding down the Shift button as you arrow down to the last cell you want included. Right-click and select "Copy", or Ctrl & C, to copy the contents of your highlighted cells.
Hope this helps.

[FDibbins]

click on D4, then hold down shift and use down arrow until you get to D37. CTRL C (copy), click where you want to copy, CTRL V (paste)

or

click on D4, look for the little handle on the bottom right of that cell, click and hold onthat handle with your mouse, and drag down. CTRL C (copy), click where you want to copy, CTRL V (paste)

[newdoverman]

To the left of the formula bar you will see a field that has a cell reference. Enter the range of cells that you want. In this case D7:D37 and then hit enter. That range of cells will be selected. Either click on the Home tab and Copy or use the keyboard shortcut Ctrl+C. Now you can paste the data where you want.

[sumesh56]

To the left of the formula bar you will see a field that has a cell reference. Enter the range of cells that you want. In this case D7:D37 and then hit enter. That range of cells will be selected. Either click on the Home tab and Copy or use the keyboard shortcut Ctrl+C. Now you can paste the data where you want.

thanks for the suggestion. it seems a good suggestion. it works. have a nice day.