freezing worksheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Freezing worksheets

Freezing worksheets

resolvedResolved · Low Priority · Version 2003

Akhtar has attended:
Excel Intermediate course
Excel Advanced course

Freezing worksheets

How can I display multiple worksheets on the screen?

RE: Freezing worksheets

Hi Akhtar,

Thank you for your question.

This question was re-assigned to me.

You cannot display multiple worksheets within a workbook at the same time.

However you can view multiple workbooks by opening the files first and then using the command Window, Arrange..., Tiled.

I hope this answers your question.

Regards

Simon

RE: Freezing worksheets

Hi Akhtar

How are you today, sorry i haven't got back to you before now

You can do viewing of multi workbooks at the same timewhat you need to do first is keep open the files then go to the window menu and click arrange you will then get the choice of how to arrange them

Hope this sort things out, if not reply to this post


If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn


 

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips


Server loaded in 0.08 secs.