 |
NavegaciónInicio de sesiónEn lÃneaEn este momento hay 0 usuarios y 117 invitados en lÃnea.
|
Allen Wyatt's Excel tipsColorizing ChartsNeed to change the color of different parts of your chart? It's easy to do when you apply the technique described in this tip. Read this ExcelTip: Colorizing Charts Pixels in a Text StringDetermining the length of a text string is easy, but figuring out how many pixels are represented by those characters is quite difficult. Here's a discussion of why this difficulty exists. Read this ExcelTip: Pixels in a Text String Non-Tiled Background PicturesBackground images for a worksheet are automatically repeated over and over (tiled) by Excel. This tip describes a workaround you can use to minimize the distracting effect of tiling. Read this ExcelTip: Non-Tiled Background Pictures Editing Individual CellsNeed to edit the data within a cell? There are any number of ways you can perform the edit; this tip documents them all. Read this ExcelTip: Editing Individual Cells Shading Based on Odds and EvensYou can use conditional formatting to add shading to various cells in your worksheet. This tip shows how you can shade cells based on whether a value is odd or even. Read this ExcelTip: Shading Based on Odds and Evens Trimming Spaces from StringsNeed to get rid of extraneous spaces before or after the text in a string? VBA provides three different functions you can use to make the removal quick and easy. Read this ExcelTip: Trimming Spaces from Strings Inserting a Voice Annotation in Your WorksheetExcel can, once in a while, try to be a "multimedia program." Here's how you can add short sound files to your worksheet that can act as annotations. Read this ExcelTip: Inserting a Voice Annotation in Your Worksheet Picking Different Random Numbers from a RangeIt is not unusual to need to select two random items from a list. There are a couple of ways you can approach the task; the techniques discussed in this tip make the job quite easy. Read this ExcelTip: Picking Different Random Numbers from a Range Deriving Monthly Median ValuesWhen processing huge amounts of data, it can be a challenge to figure out how to derive the aggregate values you need. This tip examines how you can derive median values, month by month, from a huge amount of data. Read this ExcelTip: Deriving Monthly Median Values Displaying Negative Percentages in RedExcel includes quite a few different formats you can use for the information in a worksheet. One format that isn't as easy to set up is for negative percentages. This tip explains the two ways you can format those percentages so they appear red, just like you want. Read this ExcelTip: Displaying Negative Percentages in Red Printing a Range of PagesIf your worksheet, when printed, requires more than a single page to print, you may want to only print a range of the possible pages. Here's how to specify exactly which pages you want printed. Read this ExcelTip: Printing a Range of Pages Random Numbers in a RangeExcel provides several different functions that you can use to generate random numbers. One of the most useful is the RANDBETWEEN function, which allows you to generate a random number between a lower and upper boundary that you specify. Read this ExcelTip: Random Numbers in a Range Counting with Two CriteriaWhen you use Excel as a simple database program to store individual records, you may have a need to count the records which meet two criteria. There are a number of ways you can determine the desired count, as described in this tip. Read this ExcelTip: Counting with Two Criteria Removing Subtotals from Many PivotTable FieldsNeed to get rid of pesky subtotals from your PivotTables? It's easy to do by applying the macro highlighted in this tip. Read this ExcelTip: Removing Subtotals from Many PivotTable Fields Printing Multiple SelectionsNeed to print several portions of a worksheet all on a single piece of paper? Here's an easy way you can get what you need using just cut and paste. Read this ExcelTip: Printing Multiple Selections Renaming a WorkbookRenaming a workbook from within Excel can seem daunting, but it is actually quite easy. All you need to do is use the Open dialog box as described in this tip. Read this ExcelTip: Renaming a Workbook Automatically Numbering RowsAdding row numbers to a column of your worksheet is easy; you just need to use a formula to do it. Here's a quick look at a few different formulas that will do the trick. Read this ExcelTip: Automatically Numbering Rows Shortcut to Merge CellsNeed to merge a bunch of cells together on a regular basis? You'll love the two macros in this tip which can make short work of merging. Read this ExcelTip: Shortcut to Merge Cells Non-Printing ControlsDon't want your form controls to print out with your worksheet? Here's how to make sure that Excel excludes them from the printed page. Read this ExcelTip: Non-Printing Controls Advanced FilteringMany people know how to use AutoFilter, but there are times when you need some more filtering muscle. Here's how you can use Excel's advanced filtering capabilities to see only the parts of your data that you need to see. Read this ExcelTip: Advanced Filtering |
cargando...
Buscar en necesitomas.comExcelómetroTemas nuevosLo más vistoHoy: |
