Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 05, 07:25 PM
KyWilde
 
Posts: n/a
Default pasting data over hidden cells

I need to paste data over hidden columns in a row. How can I do this?

  #2   Report Post  
Old May 20th 05, 09:08 PM
bj
 
Posts: n/a
Default

Select what you want to copy and control v or whatever to copy it.
Hylight the area you want to past to
<edit<goto<special select visible cells and paste.
I have only done this a couple of times, so I don't know if it work for
everything.
"KyWilde" wrote:

I need to paste data over hidden columns in a row. How can I do this?

  #3   Report Post  
Old May 20th 05, 09:19 PM
KyWilde
 
Posts: n/a
Default

BJ - thanks for responding. That doesn't seem to work though b/c it gives me
the error that my paste area is not the same size as what I am copying b/c it
is still counting the hidden cell region. I know this works for copying
data, but I need to paste over it. And more ideas?

Thanks,
Kyrsten

"bj" wrote:

Select what you want to copy and control v or whatever to copy it.
Hylight the area you want to past to
<edit<goto<special select visible cells and paste.
I have only done this a couple of times, so I don't know if it work for
everything.
"KyWilde" wrote:

I need to paste data over hidden columns in a row. How can I do this?

  #4   Report Post  
Old May 23rd 05, 01:35 PM
bj
 
Posts: n/a
Default

I appologise, I could have sworn I have done this, but it doesn't work for
me now.

If you have to do it a bunch, you may need to write a macro to do it,
unless someone else can come up with a method ???

I am not sure what the best macro would be.



"KyWilde" wrote:

BJ - thanks for responding. That doesn't seem to work though b/c it gives me
the error that my paste area is not the same size as what I am copying b/c it
is still counting the hidden cell region. I know this works for copying
data, but I need to paste over it. And more ideas?

Thanks,
Kyrsten

"bj" wrote:

Select what you want to copy and control v or whatever to copy it.
Hylight the area you want to past to
<edit<goto<special select visible cells and paste.
I have only done this a couple of times, so I don't know if it work for
everything.
"KyWilde" wrote:

I need to paste data over hidden columns in a row. How can I do this?



Reply
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
Combining data (numeric format) in multiple cells into one cell (t GNAC SID Excel Discussion (Misc queries) 2 February 7th 05 04:09 PM
extract data from cells Nicole L. Excel Worksheet Functions 2 February 2nd 05 08:54 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Averaging only cells with data Randy Lefferts Excel Discussion (Misc queries) 9 November 30th 04 08:02 PM


All times are GMT +1. The time now is 11:52 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017