Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
datafilter Excel 2007
When using the datafilter in excel 2007 and changes that I make to the data,
the same changes are being made to the hidden cells. For example if I try to delete the visable rows it deletes all of the rows. If I try to use the fill down command it applies that formula to every cell in that column. Any and all help is appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
datafilter Excel 2007
I assume that you mean the AutoFilter.
Firstly instead of fill down use copy and paste to visible cells method. To do this:- Select individual cell to copy. Copy Select the range to paste; but don't paste at this stage. Click on Find & Select (far right of Home ribbon) Go To Special Select visible Paste As an added extra for you if you want to copy a range of visible cells. Select range of cells to copy. Click on Find & Select (far right of Home ribbon) Go To Special Select visible Copy Select the first cell of the destination Paste Regards, OssieMac "royal" wrote: When using the datafilter in excel 2007 and changes that I make to the data, the same changes are being made to the hidden cells. For example if I try to delete the visable rows it deletes all of the rows. If I try to use the fill down command it applies that formula to every cell in that column. Any and all help is appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
datafilter Excel 2007
I should have included that to delete rows is basically the same.
Select rows to be deleted Click on Find & Select (far right of Home ribbon) Go To Special Select visible Delete rows Regards, OssieMac "OssieMac" wrote: I assume that you mean the AutoFilter. Firstly instead of fill down use copy and paste to visible cells method. To do this:- Select individual cell to copy. Copy Select the range to paste; but don't paste at this stage. Click on Find & Select (far right of Home ribbon) Go To Special Select visible Paste As an added extra for you if you want to copy a range of visible cells. Select range of cells to copy. Click on Find & Select (far right of Home ribbon) Go To Special Select visible Copy Select the first cell of the destination Paste Regards, OssieMac "royal" wrote: When using the datafilter in excel 2007 and changes that I make to the data, the same changes are being made to the hidden cells. For example if I try to delete the visable rows it deletes all of the rows. If I try to use the fill down command it applies that formula to every cell in that column. Any and all help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Data Import to Excel Issue with Excel 2007 and Excel 2003 on same | Excel Discussion (Misc queries) | |||
Exporting Quickbooks 2007 to Excel 2007 | Excel Worksheet Functions | |||
Problems with my links to an excel 2007 file from a word 2007 file | Links and Linking in Excel | |||
Office 2007 Pro Plus 2007 (Beta) - getting small red and green arr | Excel Discussion (Misc queries) |