Two Sheets on One

  • Thread starter Thread starter minah
  • Start date Start date
M

minah

I have an excel file with two worksheets. I need to convert the file t
csv. Csv does not support multiple sheets. I would like to place th
second sheet on the same tab as the first so that I can view bot
sheets under one tab. The split screen LOOKS like it would work,
would like to have the screen split and have worksheet one on top an
worksheet two on the bottom, but the split screen obviously wont wor
because it does not treat the data separately. Is there a way t
accomplish what I am trying to do??

Thanks
 
Window / New Window - Then Window / Arrange / Horizontal

If you save it whilst it is like this then it will always open in 2 windows
until you kill one of them and save it again.
 
That does not work because it doesnt treat each window's data separatel
...if i make changes to one it auto changes the data in the othe
 
OK, sorry but I had thought you just wanted to be able to see the data - For
what you want now though you will need to copy and paste the data from one tab
to the other, then save as a csv file.
 
yes but how would i have one sheet in the top window and the other shee
in the bottom window? ist here a way to do this
 
Other than my first post, no. What the first post did was give you two
different views of the same file, so you could view/edit two different sheets at
the same time. They were not two separate files, it was the same file, so
changing data in one window will of course be reflected in the other IF you are
looking at the same sheet in each case. You can though look at two different
sheets using that method.
 
Back
Top