Format Data Labels in Excel: Overview You can format data labels in Excel if you choose to add data labels to a chart. To format data labels in Excel, choose the set of data labels to format. To do this, click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon. Then
Insert a Picture Placeholder in Publisher: Overview You can insert a picture placeholder in Publisher into a publication page. When you insert a picture placeholder in Publisher, you allocate space in a page for a picture you can insert later. To insert a picture placeholder in Publisher, click the “Insert” tab in the Ribbon.
Trace Error in Excel: Overview Trace Error in Excel lets you trace arrows back to cells referenced by a formula if it displays an error. The Trace Error tool is available when auditing a worksheet within a workbook. Note that the formula cell that you select must contain an error to use the Trace Error
Use Find and Replace in Publisher: Overview You use Find and Replace in Publisher to replace text for which you search with replacement text. To use Find and Replace in Publisher, click the “Home” tab in the Ribbon. Then click the “Replace” button in the “Editing” button group. Doing this then opens the “Find
Navigating Worksheets in Excel: Overview Navigating worksheets in Excel lets you view different worksheets in a workbook. To move from one worksheet to another, click the worksheet name tab of the worksheet to view. The worksheet name tabs appear in the lower-left corner of the workbook. You can also use keyboard shortcuts to
Use the Rulers in Publisher: Overview This lesson shows you how to use the rulers in Publisher. You can use the rulers in Publisher to help you make precise measurements. They can also help you place objects into the publication pages in the desired positions. The rulers in a Publisher publication appear at both
Custom Font Schemes in Publisher: Overview You can create custom font schemes in Publisher to use in your publications. To create custom font schemes in Publisher, click the “Page Design” tab in the Ribbon. Then click the “Fonts” drop-down button in the “Schemes” button group. Then select the “Create New Font Scheme…” command from
Format a PivotTable in Excel: Overview You can apply preset styles to format a PivotTable in Excel. To format a PivotTable in Excel, click into any cell in the PivotTable. Then click the “Design” tab of the “PivotTable Tools” contextual tab within the Ribbon. Then click the desired style to apply from the listing