• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

Excell

Is there a way to open two worksheets at the same time in Excel
0
akbiro
Asked:
akbiro
  • 5
  • 4
1 Solution
 
balatheexpertCommented:
you mean, in a single window, u would want to keep two sheets open? not possible..

but u can have those sheets in two diff files and open them in "restored" window state for any review/compare purpose if you want.

let me know if it helped.

thanks,
bala
0
 
akbiroAuthor Commented:
How do open a second restored window
0
 
balatheexpertCommented:
just open the first file in excel. click on the file's restore button (not the excel main restore button). go to file->open, open the second file, and do the same, now u can resize and arrange!!!

hope it helps!!
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
akbiroAuthor Commented:
Not sure I understand.
I have two worksheets in the same Workbook.  I want to open both worksheets.
0
 
balatheexpertCommented:
that's what i have told in the beginning! we cant keep two worksheets in the same file open!

u gotta have them in two diff files!!

actually what's the purpose of it? i assumed to review/compare some data manually or so!!
0
 
akbiroAuthor Commented:
I have a main worksheet.  The main worksheet consists of line totals that are a summary of details in several detailed worksheet.  So when I want to work on Sales, lets say, I go to the Sales worksheet and see all the details.  Once I have made my changes, the new totals show up in the Main worksheet.

I would like to see those changes on the detailed worksheets as they change the main worksheet!

But, I guess it is not possible.  Thanks
0
 
balatheexpertCommented:
then, have the reference to the main worksheet's total cells in the detailed work sheet itself.

ex:
you have totals in main!$A$1 and main!$B!1

in the detailed worksheet, somewhere near the place you enter the data, in blank cells, efer these cells and see if the result is getting changed.
formula:

=main!$A$1
=main!$A$1

hope it resolves... ;-)

Bala
0
 
akbiroAuthor Commented:
Thanks...I appreciate the suggestions, but I will just continue flipping back and forth...it is not that hard...

Appreciate your patience with me...have a good day!
0
 
balatheexpertCommented:
cool!! but i would suggest u can have references and keep on monitoring as u enter the values!!

you have a good day too!!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now