Short videos show how to change hyperlinks to text, print all worksheets, create pivot table, create named table
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.
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.
It only takes a few seconds to create a pivot table in Excel. 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.
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.
For written instructions, see Creating Formatted Tables in Excel.
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
Last updated: December 28, 2016 1:05 PM
Contextures RSS Feed