ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003 - how to arrange sheets side by side? (https://www.excelbanter.com/excel-programming/356142-excel-2003-how-arrange-sheets-side-side.html)

Rich

Excel 2003 - how to arrange sheets side by side?
 
Hello,

I have done this before in earlier versions of Excel. But how do you
arrange worksheets side by side (or top and bottom) so you can view more than
one worksheet in the workbook in the same workspace?

Thanks,
Rich

Dave Peterson

Excel 2003 - how to arrange sheets side by side?
 
Window|New Window (probably)
window|arrange|horizontal (or vertical)
and check windows of active workbook

When you're done, click on the window you don't want and hit ctrl-w to close it.

Rich wrote:

Hello,

I have done this before in earlier versions of Excel. But how do you
arrange worksheets side by side (or top and bottom) so you can view more than
one worksheet in the workbook in the same workspace?

Thanks,
Rich


--

Dave Peterson

Rich

Excel 2003 - how to arrange sheets side by side?
 
Nevermind. I figured it out - goto Windows/New Window as many times as you
want sheets in view.

"Rich" wrote:

Hello,

I have done this before in earlier versions of Excel. But how do you
arrange worksheets side by side (or top and bottom) so you can view more than
one worksheet in the workbook in the same workspace?

Thanks,
Rich



All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com