 |
NavegaciónInicio de sesión
Ya sé Excel,
En líneaEn este momento hay 0 usuarios y 8 invitados en línea.
|
Allen Wyatt's Excel tipsRounding Religious Wars, Take TwoHow to round values half way between two boundaries is apparently a topic of contention in some sectors of the statistical world. This tip is the second part of a continuing discussion on this issue. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).) Read this ExcelTip:
Rounding Religious Wars, Take Two Inserting a Radical SymbolThe radical symbol is used frequently in some branches of mathematics. If you want to insert a radical symbol in a cell, here's how to go about it. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).) Read this ExcelTip:
Inserting a Radical Symbol Conditionally Formatting for Multiple Date ComparisonsThe Conditional Formatting capabilities of Excel are very powerful. Getting them to behave exactly as you expect can be a bit tricky, however. This tip describes one common pitfall when setting conditions, and it explains how to get around it. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip:
Conditionally Formatting for Multiple Date Comparisons Triggering a Macro for Drop-Down List ChangesExcel 97 has a bug that causes the Worksheet_Calculate event not to trigger when someone picks a value from a data validation drop-down list. This tip discusses the problem, along with some ways you can compensate for it. ((This tip works with Microsoft Excel 97.).) Read this ExcelTip:
Triggering a Macro for Drop-Down List Changes Counting the Number of Blank CellsDo you want to know how many blank cells are within a range? You can use the COUNTBLANK function, described in this tip, to get the answer. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip:
Counting the Number of Blank Cells Zooming In On Your WorksheetThe Zoom tool allows you to magnify what you are viewing on the screen. It can be a real boon for old eyes or detailed information. This tip explains the ways you can control the magnification applied to your worksheets. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).) Read this ExcelTip:
Zooming In On Your Worksheet Sizing Text Boxes and Cells the SameAdding text boxes to worksheets is a snap. At some point you may want to make sure that the textbox you are adding is exactly the same size as the cell (or cells) that it covers. This tip explains how to make this happen. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip:
Sizing Text Boxes and Cells the Same Disabling a Function KeyFunction keys are used to perform common tasks in Excel. If you want to disable one of the function keys, it's rather easy to do. Here's how to do it. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).) Read this ExcelTip:
Disabling a Function Key Task Pane Doesn't Appear ProperlyExcel 2002 and 2003 include a Task pane that provides quick access to common tasks. The Task pane is normally visible when you first start Excel. If it isn't, here's the reason why and what you can do about it. ((This tip works with Microsoft Excel 2002, and Excel 2003.).) Read this ExcelTip:
Task Pane Doesn't Appear Properly Using the CONCATENATE Worksheet FunctionWant to join snippets of text together in a cell? You can do this using the CONCATENATE worksheet function, as described in this tip. You can also use the ampersand operator, which is a shorthand method of using the worksheet function. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).) Read this ExcelTip:
Using the CONCATENATE Worksheet Function Using Multiple Test ConditionsWhen creating conditional formats, you are not limited to only one condition. You can create up to three conditions, all for the same cell or range of cells. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip:
Using Multiple Test Conditions Using Duplex PrintingDuplexing is the printing of information on both sides of a sheet of paper. Many printers will handle duplexing automatically, but you need to instruct Excel to take advantage of the feature. This is done by adjusting the properties of the printer itself, as described in this tip. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip:
Using Duplex Printing Inserting Worksheet Values with a MacroPlacing values into a cell with a macro is easy when you use the Value property. This tip demonstrates how you can use the Value property in your own macros. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip:
Inserting Worksheet Values with a Macro Getting Rid of Spaces in CellsGetting rid of stray spaces that clutter up otherwise empty cells can be a bother. This tip explains how you can use a couple of different techniques to make the task easier than it might otherwise appear. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip:
Getting Rid of Spaces in Cells Saving Information in a Text FileWhen writing macros, VBA includes quite a few different commands you can use to manipulate text files. This tip shows how easy it is to use some of those commands to save information into a text file. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).) Read this ExcelTip:
Saving Information in a Text File Independent Radio ButtonsRadio buttons are great for some data collection purposes. They may not be that great for some purposes, however, for the reasons described in this tip. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).) Read this ExcelTip:
Independent Radio Buttons Styles for Lines, Dashes, and ArrowsWhen you add lines or arrows to your worksheet, you can format those objects in a variety of ways. Excel allows you to modify the style, weight, and other attributes using the tools highlighted in this tip. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.).) Read this ExcelTip:
Styles for Lines, Dashes, and Arrows Conditional Formats that Distinguish Blanks and ZeroesConditional formatting is a great boon to Excel users. One use is that you can use it to highlight cells that contain zero values. However, if a cell is blank, Excel also considers that cell to be equal to zero. This tip explains how you should perform your conditional test to get only those cells containing an actual zero value. ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip:
Conditional Formats that Distinguish Blanks and Zeroes Every Second TuesdayThere are multiple ways that you can generate a list of every other Tuesday. This tip explores several of the fastest and easiest ways to do it--all without macros! ((This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.).) Read this ExcelTip:
Every Second Tuesday Turning Off Speech CapabilitiesThe speech capabilities added to Excel 2003 can be pretty cool--for some people. If you have the capabilities turned on, but your neighbor wants them turned off, then you'll need to inform him or her of how easy it is to toggle this feature. ((This tip works with Microsoft Excel 2003.).) Read this ExcelTip:
Turning Off Speech Capabilities |
EncuestaLo más vistoTemas nuevosÚltimos Envíos al blog
|
