View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default How do I open multiple worksheets each in its own tab

gerschwynne wrote:
I'm trying to open multiple Excel files and have them all appear in the same
workbook with each sheet in its own tab, but the Open command puts everything
into its own window instead of adding it to the a new tab in the existing
window. I can manually create a new tab and copy and paste the contents of
another sheet into it but there must be an easier way!!!


Why didn't you put all the worksheets in one big Excel file in the first
place? Your computer memory limits how many worksheets there can be in a
workbook.

Bill