Is there is any short cut key/method to copy and paste data in filter data in spreadsheet
12 Replies
Vikas Gupta
(Tax Executive)
(530 Points)
Replied 06 December 2013
1. Select the filtered data. For selecting filtered data, point your cursor to the first cell and then press 'Ctrl+Shift+right/down arrows'.
2. Copy this data by pressing 'Ctrl+C'
3. Move to the location where you want to paste this data and press 'Ctrl+V'
NOUFAL
(ACCOUNTANT)
(762 Points)
Replied 06 December 2013
If you want to get filtered data only from a filtered section pls do the this
1. filter the data, as that date must be visible (this is you want to delete) 2. Select the data and go to home in ribbon of excel and select the "find & select" button an click on "Go To Special" 3. Check visible cells only. This will now select only the visible cells that you wish to delete 4. Click delete>rows of sheet. ok
Read more at: /forum/filtered-row-delete-without-affecting-hidden-272301.asp#.UqHJzCc5mGY
Read more at: /forum/filtered-row-delete-without-affecting-hidden-272301.asp#.UqHJzCc5mGY
NOUFAL
(ACCOUNTANT)
(762 Points)
Replied 07 December 2013
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".
Mayur Dixit
(.)
(54 Points)
Replied 07 December 2013
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.
@VaibhavJ
(Believe!! Live your dreams!)
(33516 Points)
Replied 07 December 2013
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
@VaibhavJ
(Believe!! Live your dreams!)
(33516 Points)
Replied 07 December 2013
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
CA rahul
(BCOM(H) ACA)
(725 Points)
Replied 08 December 2013
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
Attached File : 107704 1258556 filter data.xlsx downloaded: 219 times
NOUFAL
(ACCOUNTANT)
(762 Points)
Replied 08 December 2013
see the attachment
Attached File : 734452 1258560 107704 1258556 filter data.xlsx downloaded: 215 times
CA rahul
(BCOM(H) ACA)
(725 Points)
Replied 08 December 2013
i see the file but data of Az state coming in Co State.
@VaibhavJ
(Believe!! Live your dreams!)
(33516 Points)
Replied 10 December 2013
Hi
See attached file & read instructions.
Thanks//VaibhavJ
Attached File : 112266 1259193 filtere data ca rahul.xls downloaded: 229 times
Recent Topics
Related Threads
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
