Thousands Millions

A question from Texas about setting up a chart in Excel. The goal is to show a mix of points that contain thousands and/or millions. While typing the K or M abbreviations might seem like a good way to get the table to appear, it is not a good way to have numbers that you can chart. Episode 1155 shows you how to solve the problem.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Watermark - 1151 - Learn Excel from MrExcel Video Podcast

How can you add a watermark behind your spreadsheet? It is not obvious, but Episode 1151 shows you a couple of methods.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

[Color 53] - 1142 - Learn Excel from MrExcel Podcast

You can specify up to eight colors in the custom number format box. But wait...you can actually do all 56 colors from the Excel 2003 color palette! Episode 1142 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Increase Chart Font Size - 1131 - Learn Excel from MrExcel Podcast

Roger from Columbus Indiana passes along a cool trick for formatting all of the text in a chart at once. Episode 1131 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Opening Balance VLOOKUP - 1115 - Learn Excel from MrExcel Podcast

Brett from Australia asks how to format a date to include the words Opening Balance so that he can do a VLOOKUP into a report. The format is easy, the VLOOKUP is tougher. Episode 1115 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Custom Zones - 1064 - Learn Excel from MrExcel Podcast

In yesterday's netcast, I talked about using four zones in custom number formats for positive, negative, zero, and text. In Episode 1064, you will learn how to create your own zones for formatting.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Formatting Zones - 1063 - Learn Excel from MrExcel Podcast

LearnAccessByCrystal at YouTube asked for a podcast with information about the zones in a custom number format. In Episode 1063, an explanation of the four zones in a custom number format.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Link Formatting - 1057 - Learn Excel from MrExcel Podcast

Carrie from yesterday's podcast called in to say that the links are not working. It turns out that Carrie and Mike wanted to copy the cell shading of the linked cell and regular links don't do that. For Episode 1057, I go back to Excel 2003 to show where the Paste Picture Link is hidden.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Finding Cell Styles - 1053 - Learn Excel from MrExcel Podcast

If Jerry from podcast 1052 had been using cell styles to mark his input cells, he could have used advanced options in the Find dialog to clear all of the input cells. Episode 1053 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Clearing Input Cells - 1052 - Learn Excel from MrExcel Podcast

Jerry has a model with input cells and formula cells. He wants to copy the model for next month and clear out all the input cells. Episode 1052 will show you how to clear out the numeric input cells.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #997 - 150 to 1.5

Shanna sends in today's question. When she types three digits in a cell such as 150, the cell automatically changes to 1.5. Episode 997 takes a look at this bizarre problem and when this setting might actually be useful.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #996 - Center Across Selection

Rich wonders why you can not center across selection vertically. Episode 996 will show you two not-very-satisfying workarounds and asks if you have anything better.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #991 - Add Text 1

Don from Europe calls with today's question: How can I add some text next to a number and still keep the number "as a number" that will flow into future formulas. Episode 991 shows you a cool trick for achieving this effect.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #984 - Snaking Columns

You have a really long data set with all of the data in column A. When you print, you will be wasting 75% of the horizontal white space on the page. Is there any way to have the column A data snake through the other columns? It would be nice if there was a checkbox for this, but Episode 984 resorts to using INDEX, ROW and COLUMN!

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #938 - Excel Is Fun

If you like my videos, check out the YouTube channel EXCELISFUN. Mike Gel Girvin has an amazing collection of enthusiastic Excel Videos on YouTube. Also in Episode 938 - an improvement for episode 933: =MOD(ROW(),2) is equivalent to =MOD(ROW(A2),2)=1.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #935 - Creating Table Formats

In case 54x20 formats is not enough for you, you can design your own table format. Episode 935 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #934 - Table Formatting

The every-other-row formatting becomes simple in Excel 2007 using the Table functionality. Choose from 54x20 formats in seconds. Episode 934 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #933 WIIW - Conditional Formula

Excel 2003 used to offer an obscure conditional formatting option called Formula Is. It is still obscure in Excel 2007. Episode 933 will show you the ROW, MOD functions and a dynamic solution to formatting every other row.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #932 - Greenbar II

By the time I answered Lisa's question from yesterday, she had already formatted her spreadsheet, using a clever method that I would not have thought of. Episode 932 will show you how to format every other row using the fill handle.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

MrExcel's Learn Excel #931 - Greenbar Formatting

Lisa asks how to shade every other row in the worksheet. While there are several solutions, Episode 931 shows you how to use the old AutoFormat dialog to solve this problem.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 919 - Hiding Data

Jamie from Hampshire UK offers a better way for hiding data in cells. Rather than changing the font color to white, you can use this custom number format. Episode 919 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 915 - Partially Bold

Chuck has a spreadsheet where he has bolded the client name in a dozen cells. Unfortunately, only a portion of the cell is bolded and not the whole cell. The Excel 2007 Edit-Replace can not deal with this and changes the entire cell to bold. Episode 915 will show you a solution.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 887 - Keeping Pivot Formats

Nancy sends in a cool tip to solve some of the frustrations from Episode 875 -- Excel changing the column widths of a pivot table as you choose new values from a page field. In Episode 887, I will take a look at how to solve this problem.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 879 - Icon Sets II

Excel 2007 offers a new visualization called an Icon Set. I usually hate this feature, because my numbers are right justified and the icons are left justified. However, in Episode 879, Joanna from Columbus, Ohio offers a cool tip to get the numbers and icons next to each other.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 875 - Conditional Pivot Formatting

Neville from Germany sends in a good suggestion for overcoming pivot formatting problems from Episode 865. By using conditional formatting on the underlying worksheet, Neville comes up with a way to make sure that the total rows are always highlighted in a pivot table. Episode 875 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 868 - Clearing Input Cells

Donna from Colorado asks how to clear all of the input cells from a model. In today's Where Is It Wednesday Episode 868, we take a look at how to select only the numeric constants. Also - following up on 858 - Copy as Picture, 860 Resizing Header Logo, 863 Protect Sheet.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 858 - WIIW - Copy as Picture

In our Where Is it Wednesday podcast, we go looking for a command that most people never would have been able to find in Excel 2003! If you want to send a perfect copy of a formatted spreadsheet in an e-mail, you could use Snag-It or PrtScrn, but by holding down the shift key, you can find a hidden Copy as Picture command in Excel 2003. Episode 858 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 802 - Mailbag

Episodes 790, 795, 797, and 798 generated a lot of e-mail. We will review different ways to create split cells, copy without borders, and type months and years. Episode 802 will show you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 797 - Filling 1 without formatting

Back in Episode 795, I asked about the best way to fill 1, 2, 3 without copying the formatting. 3 different approaches to solve this problem will appear in Episode 797. Even if you don't have this issue, you will learn some surprising things about the fill handle's behavior.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 790 - Split Cell

Kathy asks how to type numbers in a diagonally split cell. Episode 790 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 761 - Toolbar Customization

In Episode 761, a look at three cool custom icons you can add to your toolbar in Excel 2007 or 2003. See how easy it is to use Select Current Region, Select Visible Cells, and Set Print Area.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 759 - Border Color

There is a way to set the default border color that is used when you use the Borders dropdown. Episode 759 shows you how. Also, a look at the new Podcast DVD.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 729 - 2003 Icon Sets

Chris from Scotts sends in a cool trick today...how to set up an icon set in Excel 2003. Episode 729 takes a look at how to set up this trick.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 724 - Custom Number

I used an old custom number formatting trick in yesterday's podcast. Today, we take a look at more possibilities using custom number formats. Episode 724 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 694 - Double Greenbar

As a follow-up to yesterday's podcast, we'll take a look at how to customize the formatting used in the Excel 2007 table formatting. Episode 694 shows you how.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 693 - Easy Greenbar

Excel 2007 offers easy greenbar formatting using the table functionality. While the table functionality offers amazing tools that we'll discuss on another day, today's Episode 693 looks at the few clicks necessary to format a range with alternating row formatting.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Episode 555 - Thousands Display

Need to convert a report or a chart to display in thousands or millions? Episode 555 shows two different methods to achieve this result.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 547 - Strikethrough a Portion

Today, Bob calls in with a question. He has an Excel spreadsheet where someone managed to cross out only part of a cell. For example, someone crossed out the original due date and then keyed a new due date in the same cell and the new date does not have the strikethrough formatting applied. Episode 547 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 521 - Show Positives

Dermot sends in today’s question; a spreadsheet is showing zeroes as a dash, and positive numbers with a plus sign! It turns out that the custom number format has four zones, where you can specify different formatting for positive, negative, zero, and text values. Episode 521 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 425 - Table Formatting

Six accent colors x 7 options x 20 themes x your imagination leads to thousands of different formats that you can apply to a table with a single click. Episode 425 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Episode 414 - Joining Dates

If you try to use the concatenation character to join text with a date, you will not get the results that you expected. Episode 414 shows you how to modify the formula to properly format the date.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 413 - Mini Toolbar

Get quick access to all of the text formatting commands by moving your mouse towards the completely invisible mini toolbar! (Who at Microsoft comes up with this stuff?) Episode 413 shows you how to get the shy mini toolbar to appear.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Episode 369 - AutoShape Text

Create cool headlines by adding text to your autoshape and then formatting it using the drawing toolbar. Episode 369 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 357 - Date Differences

You have two dates in Excel and want to find the elapsed years and months. The solution is to use an ancient function from the days of Lotus 1-2-3. Episode 357 shows you how to use the function, as well as a cool formatting trick to show years and months in the same cell.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 344 - Border Details

The complete guide to applying borders to a selection. Learn what all of those icons actually do on the borders tab. Episode 344 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 343 - Double Underline

Tricks for adding a double underline to your cells. Episode 343 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Episode 342 - Without Borders

Do you get annoyed when you copy a formula and the borders get copied along with the formula? Episode 342 shows you a cool trick to prevent the borders from being copied as you extend a formula.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!