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 3D Maps in Excel: Overview You can easily create custom 3D maps in Excel. When you create a new scene in a 3D Maps tour, it is associated with a map. By default, the “World Map” is used for most scenes. However, you can also create custom 3D maps from image files, if
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
Make Columns in Publisher: Overview You can make columns in Publisher to aid in the layout of a publication page. You can then add text boxes over the column guides you create in the page to produce newsletter-style layouts. When you make columns in Publisher, you can also add rows to a publication page.
Create a PivotChart in Excel: Overview You can create a PivotChart in Excel to show the data from an associated PivotTable in a graphic format. You can create a PivotChart in Excel either independently from or along with an associated PivotTable in Excel. Alternatively, you can also add a PivotChart to an existing PivotTable
Create a Custom Page Background in Publisher: Overview Create a Custom Page Background in Publisher: How to Apply or Remove a Page Background You can create a custom page background in Publisher using the “Fill Effect” formatting also applied to shapes and pictures. To display the available default page background choices, click the “Page