There is no way to view multiple sheets from one workbook

G

Guest

It would be nice if there was the ability to view multiple sheets from the
same workbook. Currenlty, you are forced to work on each sheet individually,
but often I'd like to be working on Sheet 1 while viewing Sheet 2 - of the
same workbook (as an example).

A Work Around? Yes, I have one: create a new worksheet, copy the sheet
you'd like to view into this new worksheet.
 
J

Jason Morin

You can create new windows (Window > New Window) and then
arrange them (Window > Arrange) so you can view multiple
sheets of the same wb simultaneously.

HTH
Jason
Atlanta, GA
 
B

Bernie Deitrick

k,

The actual way to do this is to use View | New Window then View |
Arrange.... windows of activeworkbook checked, then horizontal or vertical.

HTH,
Bernie
MS Excel MVP
 
G

Gord Dibben

kstub

You gotta be careful when stating "there is no way" when posting to these
Excel groups<g>

Gord Dibben Excel MVP
 

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
Protecting workbook sheets 3
list sheets in workbook 3
Viewing Multiple Sheets from Same Workbook 3
Need to merge worksheets - Excel 2003 0
Summary from multiple sheets 1
Link one worksheet in a workbook to another worksheet in same work 1
consolidate workbooks to worksheets in one workbook? 1

Top