| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
select ever other line
is there a way to selct every other line for a copy and past pourpoe
not sahde every otehr line by select |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
select ever other line
My method:
Use a helper column lets say column A. In A2 enter 1 in A3 and copy down =IF(A4=1,"",1) Filter for a 1 on column A. Copy and paste what you see on the screen. Adapt to suit your scenario. " wrote: is there a way to selct every other line for a copy and past pourpoe not sahde every otehr line by select |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line Chart Format change on select | Charts and Charting in Excel | |||
| I want to select every 10th line of data in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
| xy plot line style change when I select "fixed maximum" | Charts and Charting in Excel | |||
| How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
| HOW TO SELECT EVERY OTHER LINE IN A WORKBOOK AUTOMATICALLY | Excel Discussion (Misc queries) | |||
Linear Mode
