Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Select the entire range and press Alt+; (this is the shortcut key to select visible cells only). Now when you copy and paste, only te visible cells would be copied -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Sarah" wrote in message ... I am trying to hide information in Excel. I hid the row I wanted to hide. I can see hidden row when copy and paste information in new excel file. Is there a way to hide information? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I stop Excel from formating my infromation as a Date? | Excel Discussion (Misc queries) | |||
i need to extract infromation from other sheets in workbook to ma. | Excel Worksheet Functions | |||
Transferring infromation from worksheet to web tool. | Excel Discussion (Misc queries) | |||
Using paste link infromation in cell to hyperlink to source cell? | Excel Worksheet Functions | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |