Split Panes in Excel: Overview To split panes in Excel when viewing a large worksheet, use the “Split” command in Excel. This command lets you split the Excel worksheet into different panes. Each pane contains its own horizontal and vertical scroll bars. Therefore, you can scroll each pane separately to view information from different
Change the Chart Type in Excel: Overview After creating a chart, you can change the chart type in Excel. Alternatively, you can also choose a different sub-type of the same general chart type you first selected. Either way, note that if you change the chart type, you may lose custom formatting you have applied
Remove Cell Formatting in Excel: Overview You can remove cell formatting in Excel to clear all the currently applied cell formatting. Removing cell formatting is also called clearing cell formatting. Doing this lets you remove cell formatting that causes problems from selected cells. When you remove cell formatting in Excel, it does not affect
Insert Slicers and Delete Slicers in Excel: Overview You can easily insert slicers and delete slicers in Excel. In Excel, slicers visually filter data within Tables, PivotTables, PivotCharts, and Power Pivot tables and charts. To insert a slicer into a worksheet, select one of these types of objects within a worksheet. Then click “Insert”
The Ribbon in Publisher: Overview The Ribbon in Publisher is the main tool you use to perform tasks. It lets you perform all the commands available in the program. The Ribbon in Publisher is divided into tabs. These tabs contain different button groups of commands. You can access the commands in each button group
Format Error Bars in Charts in Excel: Overview You can format error bars in charts in Excel if you add them to a chart. To format error bars in charts in Excel, first choose the set of error bars to format. To do this, click the “Format” tab within the “Chart Tools” contextual tab.
Delete a Page in Publisher: Overview You can delete a page in Publisher by selecting the page to delete in the Navigation Pane when viewing publications. Then click the “Delete” button in the “Pages” button group on the “Page Design” tab within the Ribbon. If using a “Two-Page Spread” layout, then select an option
Remove a Watermark in Word: Overview This lesson shows you how to easily remove a watermark in Word. A watermark is simply an image or text that appears underneath the primary text in a document. Watermarks often display additional information or instructions regarding the primary content. For example, you may see a “DO NOT