| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split a table into two
i need to split a long table into shorter ones so that i can print on one
sheet and the table to remain linked. am using 2003 excel and only way have found so far is to copy and paste picture link but this is long winded and a pain to line up profesionaly. any help thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split a table into two
Have you thought about keeping the data in one location and using
data|filter|autofilter to show what you want (and hide what you don't want). Then print from there. Lovis wrote: i need to split a long table into shorter ones so that i can print on one sheet and the table to remain linked. am using 2003 excel and only way have found so far is to copy and paste picture link but this is long winded and a pain to line up profesionaly. any help thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2nd split | Excel Discussion (Misc queries) | |||
| Split table into smaller tables & into different worksheets each | Excel Worksheet Functions | |||
| Split box | New Users to Excel | |||
| Split cell as we do in table in word | New Users to Excel | |||
| Split a Value | Excel Discussion (Misc queries) | |||
Linear Mode
