| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I split a worksheet then have the 2 sections work independent
can I split a worksheet then have the 2 sections work independently of each
other? So if I manipulate cellss in the top section, it doesn't affect the bottom section? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can I split a worksheet then have the 2 sections work independent
No.
Insertions and deletions of rows in the top section will impact the row numbers in the bottom section. If row numbers are not important then you won't be impacted by it. Column insertions and deletions will impact both the sections... Unless you select the cells and then choose insert/delete and then choose Shift left/right option. "Nik" wrote: can I split a worksheet then have the 2 sections work independently of each other? So if I manipulate cellss in the top section, it doesn't affect the bottom section? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I split one column into 3 sections in excel | Excel Discussion (Misc queries) | |||
| Worksheet Sections | Excel Discussion (Misc queries) | |||
| How do I split a cell into two sections | Excel Discussion (Misc queries) | |||
| How do i split my column excluding the header into three sections | Excel Discussion (Misc queries) | |||
| Excel should allow independent zoom adjustment of split panes | Excel Discussion (Misc queries) | |||
Linear Mode
