Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tes
 
Posts: n/a
Default HOW DO I PREVENT HIDDEN CELLS FROM DISPLAYING WHEN I COPY


  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Tes

select the range you want to copy, choose edit / goto / special - choose
visible cells only
then copy
then paste as normal

cheers
JulieD

"Tes" wrote in message
...



  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Using all caps is considered rude and posting the question in the subject
line likewise

http://www.cpearson.com/excel/newposte.htm

use gotospecial and visible cells only when copying


--

Regards,

Peo Sjoblom
`
"Tes" wrote in message
...



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
hidden cells Kev Nurse Excel Discussion (Misc queries) 7 February 24th 05 09:47 AM
Hidden cells ????? T.B. Excel Worksheet Functions 2 January 31st 05 07:01 PM
copy only non hidden cells Podgy Excel Worksheet Functions 1 December 8th 04 02:08 PM
Chart disappears when source data cells are hidden Disappearing charts Excel Discussion (Misc queries) 2 December 5th 04 03:24 AM
Calculating without including Hidden Cells LiquidFire Excel Discussion (Misc queries) 3 November 29th 04 08:35 PM


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

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

About Us

"It's about Microsoft Excel"