how i open another sheet in the same workbook without closing?

K

kamrul

i want to open another sheet in same workbook and link between the sheets in
same workbook. how can i do it? while opening the workbook having several
sheets, how wo open the other sheet in same workbook without closing the
workbook?
 
G

Gr8 Dane

If you want to have two open copies, with either same or dif sheets displayed:
1) Click on Window tab on upper portion of Screen, then click New Window.
2) The new (2nd) window of your current Sheet should default open, go back
to Window up top and now click, Compare Side by Side with (whatever your
title is).
3) From here, you can do an over/under viewing of both windows, or a
side/side viewing. You can also view one sheet on one window and another
sheet in other window at the same time.
 

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

Merge Multiple workbook sheets into one workbook 0
Start sheet in a workbook 2
How to create absolue path link to another workbook (Excel 2003) 1
how do i link one sheet to another sheets cell of the same workboo 1
Link one worksheet in a workbook to another worksheet in same work 1
Excel, assign cells in multiple worksheets from one sheet 1
formula between two workbooks 1
Special Pasting a work book with many sheets and formulas 2

Top