| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data entry on filtered rows.
Excel 2007: I have a huge spreadsheet, and I want to be able to update the
filtered rows with information by typing in the top line and copying down. When I do this, the entered information is entered on all rows including the hidden rows. How can I just enter on the filtered rows only? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data entry on filtered rows.
Lisa,
Use Edit / Go To... Special Visible Cells only OK then use Ctrl-Enter Or add the Visible cells button to your commandbar. HTH, Bernie MS Excel MVP "Lisa954" wrote in message ... Excel 2007: I have a huge spreadsheet, and I want to be able to update the filtered rows with information by typing in the top line and copying down. When I do this, the entered information is entered on all rows including the hidden rows. How can I just enter on the filtered rows only? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data entry on filtered rows.
Thank you for your response. This is Excel 2007. There is no edit button on
the ribbon bar at the top. "Lisa954" wrote: Excel 2007: I have a huge spreadsheet, and I want to be able to update the filtered rows with information by typing in the top line and copying down. When I do this, the entered information is entered on all rows including the hidden rows. How can I just enter on the filtered rows only? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data entry on filtered rows.
Use Fn key F5 as your gotospecial key
Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 10:35:02 -0700, Lisa954 wrote: Thank you for your response. This is Excel 2007. There is no edit button on the ribbon bar at the top. "Lisa954" wrote: Excel 2007: I have a huge spreadsheet, and I want to be able to update the filtered rows with information by typing in the top line and copying down. When I do this, the entered information is entered on all rows including the hidden rows. How can I just enter on the filtered rows only? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data entry on filtered rows.
Hi,
I do not face this problem. I filtered a range with A in the column and then typed Z in the first cell. Now when I copied and pasted, the values were pasted on the A's only. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Lisa954" wrote in message ... Excel 2007: I have a huge spreadsheet, and I want to be able to update the filtered rows with information by typing in the top line and copying down. When I do this, the entered information is entered on all rows including the hidden rows. How can I just enter on the filtered rows only? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I extract the first entry in a filtered list? | Excel Worksheet Functions | |||
| Referncing Rows of Filtered Data | Excel Worksheet Functions | |||
| Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How to number rows after data has been filtered? | Excel Discussion (Misc queries) | |||
Linear Mode
