window sizing in Excel

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have two spreadsheets that have long names, and they
names are the same until the very end. I want to copy one
worksheet from one workbook to the other. When I right
click on the worksheet tab, select Move or Copy, I get a
window asking where I want to move or copy to. So far so
good, my problem is that I can't see the full names of the
two open workbooks because the window isn't big enough,
and you cannot scroll.

How do I view the full file names in the windows?

It's the same thing with most selection windows, they
cannot be resized.
 
I've never seen a way.

But did you know that you can Window|Arrange your workbooks so that both are
visible. Then click and drag the worksheet tab to the other workbook (to move)
or ctrl-click and drag to copy.

And if you really had to, you could copy it to a new workbook, then close that
"source" workbook and move it to the other workbook.

(I think I'd go with ctrl-click and drag after arranging the workbook.)
 
Back
Top