Be Challenged
There is one week left to enter the current challenge of the month. In Episode 483, see this month's challenge is how to calculate a ...
From: MrExcel3
Added: 16 years ago
Views: 3
4,997 ratings
Results for “MrExcel3”
About 595 results
Dueling: Unwind Selection
A dueling podcast: how to unwind a rectangular selection to a single column. Mike & Bill weigh in with differing methods in ...
From: MrExcel3
Added: 16 years ago
Views: 100
30,554 ratings
Filtering Criteria
Use the Advanced Filter with a criteria. Episode 237 will show you how.
From: MrExcel3
Added: 16 years ago
Views: 25
2,582 ratings
Open a Copy
Open a copy of a workbook to make sure you don't accidentally overwrite the original file. Episode 120 will show you how.
From: MrExcel3
Added: 16 years ago
Views: 12
39,852 ratings
Ctrl Shift Enter
Learn about super-powerful amazing formulas that you can access if you know the secret keystroke combination! Episode 223 ...
From: MrExcel3
Added: 16 years ago
Views: 23,551
20,634 ratings
Recent Records
How can you find the most recent record for each customer? The method I proposed in Episode 614 is not the fastest way. Richard ...
From: MrExcel3
Added: 16 years ago
Views: 19
39,212 ratings
Delete Objects
There is a secret icon that will let you select all of the items on the drawing toolbar. Episode 363 shows you how.
From: MrExcel3
Added: 16 years ago
Views: 20
41,619 ratings
Filter Recent II
In today's podcast, I address the same question from podcast 614, but assume that the dataset can not be sorted. This requires a ...
From: MrExcel3
Added: 16 years ago
Views: 12
12,290 ratings
Repeating Characters
If you need to fill a cell with a character, either with or without numbers, there are a couple of interesting alternatives. Episode 574 ...
From: MrExcel3
Added: 16 years ago
Views: 13
12,563 ratings
Unprotect Green Cells
Today, the questioner asks how to unprotect the green cells. There isn't any good way to do this in the Excel user interface, so in ...
From: MrExcel3
Added: 16 years ago
Views: 6
10,879 ratings
Removing Duplicates
Excel 2007 offers powerful new features for removing duplicates. Episode 415 shows how you can find the unique values in a list ...
From: MrExcel3
Added: 16 years ago
Views: 16
487 ratings
Data Entry
Today's podcast shows a better way to do data entry. Rather than having to change the Move Selection After Enter Direction, you ...
From: MrExcel3
Added: 16 years ago
Views: 10
42,196 ratings
Adaptive Menus
In Excel 2000-2003, if you open a menu and only see a third of the menu items, then you still have Adaptive Menus turned on.
From: MrExcel3
Added: 16 years ago
Views: 14
3,041 ratings
More Precedents
Use the Formula Auditing tools to find all of the precedents. Episode 204 shows you how.
From: MrExcel3
Added: 16 years ago
Views: 22
25,367 ratings
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 ...
From: MrExcel3
Added: 16 years ago
Views: 16
2,482 ratings
Sparse Copy
My favorite trick is to double click the fill handle to copy a formula. But, this requires the column to the left to have no blanks cells.
From: MrExcel3
Added: 16 years ago
Views: 21
24,227 ratings
Filter Most Recent
Alicia and George have sent in similar questions; George asks how can I filter a data set to one record per customer? Alicia had a ...
From: MrExcel3
Added: 16 years ago
Views: 54
35,904 ratings
Indeterminate Substitution
Robbie calls in today to ask how to add a hyphen at an unknown position in each cell. For example, whenever Excel finds a ...
From: MrExcel3
Added: 16 years ago
Views: 15
7,130 ratings
Comment Yourself
Leave yourself helpful notes in the spreadsheet. All of the 16 million cells in an Excel spreadsheet can contain a formula and a ...
From: MrExcel3
Added: 16 years ago
Views: 23
47,188 ratings
Filling Blanks
While yesterday's podcast talked about using the Fill Handle, there are times when there are methods faster than using the fill ...
From: MrExcel3
Added: 16 years ago
Views: 7
8,291 ratings