Search Contextures Sites
Custom Search

 

More Excel Videos

Excel Videos - Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

 

Excel Quick Tips Videos 04

How to change hyperlinks to text, print all the worksheets, and more tips.

Change Excel Hyperlinks to Text 

Print All Sheets in an Excel Workbook  

Create a Quick Pivot Table in Excel 2007  

Format a Table in Excel 2007 

Change Excel Hyperlinks to Text

When you type a website or email address in Excel, a hyperlink might be automatically created. To change the hyperlinks to normal text, you can paste them as values. This Excel Quick Tips Video shows you the steps.

For more ways to convert Excel hyperlinks to text, see Prevent Hyperlinks, in the Excel FAQs.

Print All Sheets in an Excel Workbook

Instead of printing worksheets individually, you can select all the sheets, and print them at the same time.

For more Excel tips, see Excel Tips and Tutorials.

Create a Quick Pivot Table in Excel 2007

It only takes a few seconds to create a pivot table in Excel 2007. In this 12 second video, I select a cell in an Excel table of sales data, click a button on the Ribbon, click OK, and add a couple of fields to the new pivot table.

For written instructions, see create a pivot table in Excel 2007.

Format a Table in Excel 2007

In Excel 2007, you can format a list of data as an Excel Table. This will make sorting and filtering easier, and is very efficient as the source for a Pivot Table.

In this Excel Quick Tips Video, you'll see the steps for creating a formatted Excel Table from a list in Excel 2007.

For written instructions, see Creating Formatted Tables in Excel 2007.

More Excel Videos

Excel Videos - Index

Names

Paste Special

Create UserForms

Mouse Shortcuts

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: August 7, 2016 2:06 PM