Copy Multiple Rows/Columns in Worksheet Section with few Col

baliangn · Mar 13th, 2002, 01:17 PM

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

Mar 13th, 2002, 01:36 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 01:17 PM	#1
baliangn Join Date: Mar 2002 Location: Glenn Balian Posts: 3	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

Mar 13th, 2002, 01:36 PM	#2
Guest Posts: n/a	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.