Excel hacks
Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more th...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly
2007.
|
| Edición: | 2nd ed |
| Colección: | Hacks series
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627007406719 |
Tabla de Contenidos:
- Excel Hacks, 2nd Edition; Contributors; Acknowledgments; Preface; Getting and Using the Hacks; How to Use This Book; How This Book Is Organized; Windows, Macintosh, and Earlier Excel Versions; Conventions Used in This Book; Using Code Examples; Safari® Enabled; How to Contact Us; 1. Reducing Workbook and Worksheet Frustration; 1.1.2. Structural Tips; 1.1.3. Formatting Tips; 1.1.4. Formula Tips; 1. Create a Personal View of Your Workbooks; 2. Enter Data into Multiple Worksheets Simultaneously; 1.3.2. Grouping Worksheets Automatically; 3. Prevent Users from Performing Certain Actions
- 1.4.2. Preventing Users from Printing a Workbook1.4.3. Preventing Users from Inserting More Worksheets; 4. Prevent Seemingly Unnecessary Prompts; 1.5.2. Prompting to Save Nonexistent Changes; 1.5.3. Stopping Excel&s Warning Prompts for Recorded Macros; 5. Hide Worksheets So That They Cannot Be Unhidden; 6. Customize the Templates Dialog and Default Workbook; 1.7.2. Using a Custom Default Workbook; 7. Create an Index of Sheets in Your Workbook; 1.8.2. Auto-Generate an Index Using VBA; 1.8.3. Link to the Index from a Context Menu; 8. Limit the Scrolling Range of Your Worksheet
- 1.9.2. Specifying a Valid Range1.9.3. Activating Only the Used Range; 9. Lock and Protect Cells Containing Formulas; 1.10.2. Data Validation; 1.10.3. Auto-Toggle Worksheet Protection; 10. Find Duplicate Data Using Conditional Formatting; 11. Find Data That Appears Two or More Times Using Conditional Formatting; 12. Tie Custom Toolbars to a Particular Workbook; 13. Outsmart Excel&s Relative Reference Handler; 14. Remove Phantom Workbook Links; 15. Reduce Workbook Bloat; 1.16.2. Clean Up Your Macros; 1.16.3. Honing Data Sources; 1.16.4. Cleaning Corrupted Workbooks
- 16. Extract Data from a Corrupt Workbook1.17.2. If You Cannot Open Your File; 2. Hacking Excel&s Built-in Features; 17. Validate Data Based on a List on Another Worksheet; 2.2.2. Method 2: the INDIRECT Function; 2.2.3. The Pros and Cons of Both Methods; 18. Control Conditional Formatting with Checkboxes; 2.3.2. Toggling Number Highlighting On and Off; 19. Identify Formulas with Conditional Formatting; 20. Count or Sum Cells That Meet Conditional Formatting Criteria; 21. Highlight Every Other Row or Column; 22. Create 3-D Effects in Tables or Cells
- 23. Turn Conditional Formatting and Data Validation On and Off with a Checkbox24. Support Multiple Lists in a ComboBox; 25. Create Validation Lists That Change Based on a Selection from Another List; 26. Use Replace... to Remove Unwanted Characters; 27. Convert Text Numbers to Real Numbers; 2.12.2. Using the TEXT Functions; 28. Extract the Numeric Portion of a Cell Entry; 29. Customize Cell Comments; 2.14.2. Extracting Comment Text; 30. Sort by More Than Three Columns; 31. Random Sorting; 32. Manipulate Data with the Advanced Filter; 33. Create Custom Number Formats
- 34. Add More Levels of Undo to Excel for Windows
