Copy Multiple Rows/Columns in Worksheet Section with few Col

[baliangn]

There is a way to copy a spreadsheet section containing multiple rows/columns to a portion of a worksheet without the same number of rows/columns. I can't find the command anywhere and it is not a simple copy past function.
Would you please help.
Thanks,
Glenn: glenn.balian@fmr.com

 

[Guest]

If I understand your question, you can hide the rows and columns that you do not want to copy, select the section and go to:

Edit->GoTo->Special->Visible Cells

This will select just the visible cells in your section, then paste.