- #Microsoft excel 2011 how to do line of best fit full#
- #Microsoft excel 2011 how to do line of best fit plus#
Each sheet can be named (double-click in a tab to type a new name) and worksheets can be deeply connected with one another.
#Microsoft excel 2011 how to do line of best fit plus#
You can add additional worksheets to a workbook using the plus "+" sign at the bottom of the screen, and switch among them using the tabs. A workbook is a spreadsheet that is composed of one or more worksheets - by default, a new workbook opens with a single worksheet. If you don't want any existing template or Excel file, choose "Blank workbook."Īfter you're on Excel's main interface, let's take a quick look around and review some of the most common terminology.Īn Excel document is referred to as a workbook. That’s a shame because a floating list of workbooks would be useful in Excel.You can open a new workbook, or pin an existing one to your list of Recents for easy access. Unfortunately, it’s a modal dialog, meaning you can’t do anything else in Excel until you close that Window.
#Microsoft excel 2011 how to do line of best fit full#
Right-click on the left/right tab navigation arrows to see the ‘Activate’ window with its full list of visible tabs. Hidden workbooks can be made visible again from the ‘Unhide’ choice on the same menu. Great for data source connections, PivotTables for PivotCharts and other side-calculations. on a hidden workbook work normally, it’s just not visible on the tabs list. Maybe you don’t need all the workbooks on the list? Tabs can be hidden from the list by right-clicking and choosing ‘Hide’.
The vertical bar or dots divides the line between space for tabs and the horizontal scroll bar.ĭrag the divider to the right to make more room for visible workbooks. The most commonly used tabs could be grouped on the left. That’s not always possible – how can you make the word ‘Antihistamine’ shorter?įrom the ‘so easy you might overlook’ department is a reminder that workbooks can be rearranged (drag and drop). Shorter tab labelsĪt risk of insulting your intelligence, the labels can be trimmed.
Are you sure your screen is set to the maximum possible resolution? It probably is, but sometimes there’s a greater resolution available to fit more info on the screen.įor a shared workbook, you don’t know how other people will resize the worksheet on their computer … they could even open it on a smartphone! We have tips that will work no matter what screen the workbook is opened on. Obviously, the Excel window can be widened or maximized to fill the entire screen but that’s not always practical. We’ll start with some simple tips that are often given as full ‘solutions’ then move onto more practical options for navigating many tabs. The left-right arrows at left will move the tab list along, though clicking on the dots does the same thing. The three-dots at either end are the clue to the hidden tabs. Here’s the common problem with too many worksheet labels and not enough width. Here’s some tricks to fit more visible workbooks or workarounds when the tab list is way too long. Tabs in an Excel workbook can easily be hidden away on that single line.
0 kommentar(er)
