 
|
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 [...] 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 [...] 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 [...] 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 [...] 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 [...] 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 [...] 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 [...] 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 [...] 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 [...] 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 [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
