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

excel

ResolvedVersion 365

Helen has attended:
Excel Advanced course

Excel

How to have two different sheets of the same spreadsheet on extended screens

RE: Excel

Hello Helen,

Thank you for your question. To show two different sheets from the same workbook on two screens, you first need to go to the View tab. Here, click 'New Window' in the Window group.

This will open a second window of the same workbook. You are able to select any of the tabs in both windows. You can also drag one of the windows to an extended screen if your Windows project mode is set to Extend.

I hope this helps.

Kind regards
Marius Barnard
STL

Mon 2 May 2022: Automatically marked as resolved.

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.