can I split a worksheet then have the 2 sections work independent

  • Thread starter Thread starter Nik
  • Start date Start date
N

Nik

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting Worksheet 2
Independent column widths 4
row sections... 0
worksheet split programmatically? 1
Finding dynamic maxima 8
MULTIPLE PRINT AREA 3
Excel should allow at least 2 vertical and horizontal splits. 1
Split individual cells? 2

Back
Top