LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How do I paste in sorted area?

I sort the column (from drop-down list) and what omits some cells in that
column. Then I want to paste something into that sorted area (except from
omitted cells) but the program pastes it also in these omitted cells not in
the sorted area that I wanted; I.E. if sorting hid rows 3-to-9, when I'm
pasting certain data, it's being paste also in those rows 3-9.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
can you select paste area before copying data Roz2459 Excel Discussion (Misc queries) 4 January 29th 09 02:22 PM
error: "the copy area & the paste area are not the same size & sh Janis Excel Discussion (Misc queries) 1 September 7th 07 10:58 PM
Question about different paste area sizes Sam Excel Discussion (Misc queries) 5 June 7th 06 06:16 PM
in excel paste images to specific cells that can be sorted tss Excel Discussion (Misc queries) 0 April 26th 06 02:12 AM
Allow for COPY/PASTE in the "Comment" area Hoggy Excel Worksheet Functions 0 May 20th 05 03:19 PM


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"