Posted to microsoft.public.excel.misc

Victor Delta[_2_] Victor Delta[_2_] is offline

external usenet poster

Posts: 199

Pasting into a filtered sheet

I have an Excel spreadsheet where some of the rows are not visible as they
are auto-filtered out.

I have a column of 20 cells from another sheet that I want to paste in to
cells in the top 20 visible rows of the first sheet. However, whenever I try
this using Paste or Paste Values, it fills the top 20 cells including the
invisible rows.

Is there any way I can just paste into the visible rows please?

TIA

V

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pasting filtered rows	Annie	Excel Discussion (Misc queries)	1	October 3rd 06 07:47 PM
filtered pasting	BorisS	Excel Discussion (Misc queries)	9	July 9th 06 06:43 PM
Pasting on Filtered Data Sheets without pasting onto hidden cells	CCSMCA	Excel Discussion (Misc queries)	1	August 28th 05 01:22 PM
Pasting onto filtered cells	Mediaexcel	Excel Worksheet Functions	1	October 27th 04 10:29 PM
Pasting onto filtered cells	Mediaexcel	Excel Worksheet Functions	1	October 27th 04 05:44 PM

All times are GMT +1. The time now is 04:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us