How to open Excel workbooks in new windows (open multiple windows)?
Collaborate for free with an online version of Microsoft Excel. Save spreadsheets in OneDrive. Share them with others and work together at the same time. Microsoft Excel is one of the most versatile and useful programs in the Office suite. It doesn't matter if you need Excel templates for budgeting the next fiscal year, tracking your business inventory, planning out meals, or creating a fantasy football draft sheet, there are plenty of Microsoft Excel templates for you.
Microsoft Excel, spreadsheet application launched in 1985 by the Microsoft Corporation. Excel is a popular spreadsheet system, which organizes data in columns and rows that can be manipulated through formulas that allow the software to perform mathematical functions on the data. Screenshot of Microsoft Excel. © 2010 Microsoft Corporation. In response to the coronavirus (COVID-19) situation, Microsoft is implementing several temporary changes to our training and certification program. Demonstrate that you have the skills needed to get the most out of Excel by earning the Microsoft Office Specialist: Excel Associate.
In this tutorial, we will show you how to open Excel workbooks in different windows steps by steps.
Open Excel workbooks in new windows with holding Shift key and clicking in Taskbar
For the usage of lowest versions of Excel, with holding the Shift key and clicking the Excel icon in the Taskbar, you can open Excel workbooks in multiple windows.
1. Firstly you need to open a workbook in advance, and then hold the Shift key on the keyboard.
Microsoft Excel Invoice Template
2. Click the Excel icon in the Taskbar. See screenshot:
Then a new blank workbook is opened. If you need to edit the new opened workbook, just edit and save it. Otherwise, you can open another workbook you have created before in this new workbook window.
3. Click File (Office button) > Open from your new created workbook just now, In the Open dialog box, find and select the workbook and then click the Open button.
Then you can see the workbooks are opened in two separate Excel windows. You can repeat the above steps to open more Excel windows.
Open Excel workbooks in new windows with Start menu
Besides the above method, you can open Excel workbooks in new windows with Start menu. Please do as follows.
1. Click the Start button to show the menu. Type Excel in the Search box, then click Microsoft Excel in the Programs section. See screenshot:
2. When a new blank workbook opened, please click File (Office button) > Open, In the Open dialog box, find and select the workbook you want to open and then click the Open button.
3. To open multiple workbooks you want, you just need to repeat the above steps one by one.
Open Excel workbooks in new windows with creating shortcut
The last method for opening Excel workbooks in new window is to create a shortcut. Please do as follows.
1. Open the Office folder in your computer with following paths.
In Excel 2010: C:Program FilesMicrosoft OfficeOffice 14
In Excel 2007: C:Program FilesMicrosoft OfficeOffice12
2. In the opened Office folder, find the EXCEL icon, right click it and then select Create shortcut from the right-clicking menu. See screenshot:
3. Then a Shortcut prompt box pops up, click the Yes button.
4. Then an Excel shortcut is placed on the desktop. Double click it, and a new Excel window will be opened. Then you can click File (Office button) > Open to open the workbook that you need.
5. If you need to open multiple workbooks in new windows, you should repeat step 4 to open them one by one.
Note: For Excel 2013, the workbooks are opened in different windows by default.
Open Excel workbooks in new windows with Office Tab
In this section, I will show you a handy applications – Office Tab. With the Open In New Window feature of Office Tab, open workbooks in new windows is not a problem anymore.
1. After installing Office Tab, open the workbooks you want. Then you will see all workbooks are opened in an Excel window as tabbed browsing status.
2. If you want to open a specific workbook in a new window, please right click this workbook tab, and then click Open In New Window in the list. See screenshot:
Then the selected workbook is opened in a new window as below screenshot shown:
Tip.If you want to have a free trial of this utility, please go to Click for free trial of Office Tab first, and then go to apply the operation according above steps.
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range..
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Microsoft Excel Invoice Template
- To post as a guest, your comment is unpublished.if you do send to desktop you can avoid the pop-up asking you to put the shortcut on the desktop
- To post as a guest, your comment is unpublished.Thanks for your information guys, very very usefull
In Microsoft Excel, you can improve the readability of your dashboards and reports by formatting your revenue numbers to appear in thousands. This allows you to present cleaner numbers and avoid inundating your audience with overlarge numbers. To show your numbers in thousands, highlight them, right-click, and select Format Cells.
After the Format Cells dialog box opens, click the Custom option to get to the screen shown in this figure. Adobe flash gratis italiano.
In the Type input box, add a comma after the format syntax.
After confirming your changes, your numbers will automatically appear in the thousands place!
The beautiful thing here is that this technique doesn't change the integrity or truncate your numeric values in any way. Excel is simply applying a cosmetic effect to the number. To see what this means, take a look at this figure.
The selected cell has been formatted to show in thousands; you see 118. But if you look in the formula bar above it, you'll see the real unformatted number (117943.605787004). The 118 you are seeing in the cell is a cosmetically formatted version of the real number shown in the formula bar.
Custom number formatting has obvious advantages over using other techniques to format numbers to thousands. For instance, many beginning analysts would convert numbers to thousands by dividing them by 1,000 in a formula. But that changes the integrity of the number dramatically.
When you perform a mathematical operation into a cell, you are literally changing the value represented in that cell. This forces you to carefully keep track of and maintain the formulas you introduced to simply achieve a cosmetic effect. Using custom number formatting avoids that by changing only how the number looks, keeping the actual number intact.
If needed, you can even indicate that the number is in thousands by adding to the number syntax.
This would show your numbers like this:
You can use this technique on both positive and negative numbers.
After applying this syntax, your negative numbers also appear in thousands.
Need to show numbers in millions? Easy. Simply add two commas to the number format syntax in the Type input box.
Microsoft Excel Indir
Note the use of the extra decimal places (.00). When converting numbers to millions, it's often useful to show additional precision points, as in