Excel

Resolved · Low Priority · Version 365

Mon 25 Apr 2022, 12:16 Delegate Helen said...

Helen has attended:
Excel Intermediate course

Excel

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

Mon 25 Apr 2022, 15:12 Trainer Marius said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips