Welcome to the nineth post of this series. Hope you are enjoying this series. Click here to read to navigate to go to special.
What are visible cells?
How often you filter the data in your spreadsheet? How often you hide some rows or columns from your data? I know your answer. Quite a number of times...Correct? If your answer is yes then read on and answer some more questions patiently.
How often you want to select and copy only the data you filtered and how often you want to select and copy only the rows / columns that are visible (excluding the hidden rows and columns)? This option is for you if you have failed copying this data and ended up pasting the whole set of data instead of only the filtered / visible data.
When you filtered data it means you have hidden the data that is not required to you. When you are selecting data when filter is on, then it means you are also selecting the data that is hidden in the range you are selecting. So, first we need to select the visible cells only.
Select the cells that you want to copy. Go to special. Select visible cells only. You are now only selected the visible cells. Simply copy the data and copy to the location you like and perform further analysis.
Keyboard shortcut
Ctrl+g, Alt+s+y or
Alt+;
Share your experience:
Hope you are enjoying this series.
Do you use this option more often? Share your experiences. Have another tip do this stuff? Also, do not forget to leave your comments on this post. I learn a lot from you all. I’ll be posting soon, tenth post of this series “Go to Special – Select Data validation and Conditional formats”.
Links related to this series:
Go To Special Series. Select Precedents and Dependents
Go To Special Series. Select Last Cell
No comments:
Post a Comment