Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 overwriting Hidden Rows
Hi There - Hope somebody can help me. I have new pc with MS Office 2007
installed from manufacturer. In Excel 2007 when I filter on particular rows and wish to change their value and copy that down through the other filtered rows I find that it also overwrites the "hidden" row values. I got my install disks and ran repair and no joy and then did an uninstall and reinstall but still no joy. Can anybody help please? -- Fionn |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 overwriting Hidden Rows
Thahnk you Roger will try that but if you could remember patch location would
be great -- Fionn "Roger Govier" wrote: Hi Fionn There is a patch for fixing this problem, but i can't remember it's location at present. In the interim, don't use Autofilter. Remove Autofilter, then choose Insert tabTablemy Table has headers. Use the dropdowns that are automatically created in all Tables Apply Filter, make your change and copy down. -- Regards Roger Govier "Fin" wrote in message ... Hi There - Hope somebody can help me. I have new pc with MS Office 2007 installed from manufacturer. In Excel 2007 when I filter on particular rows and wish to change their value and copy that down through the other filtered rows I find that it also overwrites the "hidden" row values. I got my install disks and ran repair and no joy and then did an uninstall and reinstall but still no joy. Can anybody help please? -- Fionn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
How to paste rows in 2007 without overwriting data? | Excel Discussion (Misc queries) | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) |