peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Show Specific Info in Tabbed Excel UserForm

To show instructions to users in your Excel files, you can add comments or text boxes with notes.

 

Another option is to put the notes in an Excel Userform, and add a Help button on each worksheet. The button can open the Help form to a specific page, and show the relevant [...]

Excel AutoFilter By Typing Criteria

Someone emailed me for help with an Excel AutoFilter last week. He wanted to type the criteria onto a worksheet, and have the filtered results shown automatically. There are some built-in options for filtering by text, and keep reading to see a worksheet version that Roger Govier designed.

AutoFilter Search in Excel 2010

There is [...]

Preparing for an Excel Expert Exam

Have you ever written an Excel proficiency exam? Maybe you'll have some advice or tips for the person who wrote to me this week, asking for help with the Excel Expert 2007 exam. He's having trouble with the macros and custom functions that will be part of the test.

It's been a long time since [...]

Excel UserForm Data Entry Update

Someone emailed me this week, about a problem he was having with my sample Part Data Entry UserForm.

When I took a look at the workbook, everything seemed okay, and the code had been copied and altered correctly.

Then I noticed that there was a formatted Excel table on the data [...]

Excel Pivot Table from Multiple Sheets Update

If you have similar data on two or more worksheets, you might want to combine that data in a pivot table, to show the summarized results. Unfortunately, the pivot table from data on multiple sheets can be a disappointment.

Create a Pivot Table with Programming

A couple of years ago, Excel MVP, Kirill Lapin [...]

Show Personalized Excel Message Box

Uh-oh! It's almost Christmas and you haven't mailed any greeting cards yet. Don't worry, you can create a personalized Excel message box instead! That will warm your co-workers' hearts, and it saves paper and postage costs too.

Get the Application UserName

In Excel VBA, you can use Application.UserName to get the registration name for [...]

Auto Resize Excel Text Boxes

If other people will be using the Excel files that you build, it might help them if you add some instructions in a Text Box. After you add the text, drag the handles to adjust the Text Box size, so all the instructions are visible.

If you plan to edit the text occasionally, or [...]

Customize Excel Right-Click Menus

Do you ever right-click on something in Excel, and the command that you wanted to use isn't on that pop-up menu? For example, if right-click on a cell, there is no command to turn off the gridlines.

If you can't find the command on the right-click menu, you have to go to the Excel [...]

Sort Lottery Number Rows in Excel

One of the best features of Excel is that it's quick and easy to sort columns of data.

 

You can even sort data in an Excel row, left to right, by changing one of the sort options.

Sort Multiple Rows of Data With a Formula

In a comment on the Sort [...]

Excel Macro Name Conflicts

Last week I ran into an interesting problem, when trying to fix a macro button in a client's Excel file. I've created a simplified version of the workbook and button, to show you what happened.

The workbook had been converted from Excel 2003 to Excel 2010, and when the macro button was clicked, it showed [...]

Related Posts Plugin for WordPress, Blogger...