| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to hide infromation in Excel?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to hide infromation in Excel?
You could set the font color to white
-- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Sarah" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to hide infromation in Excel?
Another suggestion is to do a filter on the spreadsheet and when using the
filter check the the rows you want to see and then you should be able to copy and paste this to another spreadsheet. I tried it for you and it works. "Sarah" wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to hide infromation in Excel?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
