Short cut key

If you want to get filtered data only from a filtered section pls do the this
 

Hi Noufal 

This is not working

Am really sorry Mr Rahul. In my reply dont follow the 4th instruction. because its for deleting the selected data.so you can copy and paste by simply "Ctrl + C" and "Ctrl + V".

Select the filtered data by pressing Alt+; and paste it anywhere you want. Pressing alt +; helfs in selection of data that is required and not unfiltered data.

Yes..

when data is Filtered you need to selcet only visible data.

You can select only visible data leaving asisde hidden daat by following step:

Step-1: Select data that you want to copy.

Step-2: Press Alt Key & ; Key or  Ctr + G then Aly + S then Y

Step-3: Press Ctr + C

Step-4: Press Ctr + V to paste data

Thanks//VaibhavJ

Also to select all data in filtered cell press when you are in any of cell of your filtered data ..

press Ctr + Shift + * key to selct data

press Ctr + C to copy data

press Ctr + V to paste data to destination cell.

Thanks//VaibhavJ

i think you have cleared this, ok?

Hi Noufal

please find the enclosd file . in this file i need to copy data of AZ  state from sheet 2 to sheet 1.please help

see the attachment

i see the file but data of Az state coming in Co State.

Hi

See attached file & read instructions.

Thanks//VaibhavJ