Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy information and skip hidden cells?
Just looking for some help to copy visible information from one page to
another without including hidden information. Example: Copy rows 1-10 excluding 7,8 which are hidden. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy information and skip hidden cells?
Select the range
edit|goto|special|visible cells only edit|copy off to the other sheet edit|paste If you have formulas that you want to keep, I think you'll have to copy|paste each visible area separately. unfrgvn82 wrote: Just looking for some help to copy visible information from one page to another without including hidden information. Example: Copy rows 1-10 excluding 7,8 which are hidden. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy information and skip hidden cells?
Try highlighting the area and using Ctrl ; (the keyboard shortcut to select
visible cells only). Copy and paste as normal and you should just get the visible cells. -- Thanks, MarkN "unfrgvn82" wrote: Just looking for some help to copy visible information from one page to another without including hidden information. Example: Copy rows 1-10 excluding 7,8 which are hidden. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy information and skip hidden cells?
Sorry, I need to correct my first post - the keyboard shortcut should read
Alt ; -- Thanks, MarkN "unfrgvn82" wrote: Just looking for some help to copy visible information from one page to another without including hidden information. Example: Copy rows 1-10 excluding 7,8 which are hidden. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy multiple cells between worksheets | Excel Discussion (Misc queries) | |||
Can i "filter" in excel by words in Bold? | Excel Worksheet Functions | |||
Macro-Copy various cells in sheet1 into next available row in sheet 2 | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
How do I use countif across non-adjacent cells? | Excel Worksheet Functions |