|
|
Search
Contextures Sites
|
||
|
|
|
|||
Contextures Inc., Copyright © 2009.
All rights reserved.
Search Contextures Sites
Search Contextures Sites
Excel Quick Tips Videos 04
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.
Contextures Inc., Copyright © 2009.
All rights reserved.
Search Contextures Sites
Last updated: January 6, 2010 10:25 PM
