When working with workbooks, sometimes there are hidden cells or columns. You have the option of copying all the cells or only the visible cells. By default, Kingsoft Spreadsheets copies all cells including hidden ones. If you want to prevent the hidden cells from being copied, follow the steps in this article to copy visible cells only. See how to hide rows or columns in Spreadsheets.
In default, hidden cells are copied:
Change Spreadsheets to copy only visible cells
Step 1: Select the data range you want to copy.
Step 2: Press Ctrl+G and then the Go to dialog box shows up.
Step 3: Select Visible cells only and click Go to.
Step 4: Copy data and paste. Thus the data won’t contain the hidden rows or columns.
No comments:
Post a Comment