|  

» My Bookmarked Tips

My Tips is a feature that allows you to bookmark your favorite tips on our website. Simply click on the icon when viewing a tip to bookmark it.

. You may later access the bookmarked tips by clicking on the My Tips tab.
. The tips will be bookmarked for all future visits to our website.


Delete Tip from MyTips Summarize data according to criteria from the data table using Sumif formula, Offset formula and Combo Box in Microsoft Excel
Delete Tip from MyTips Delete a module using VBA in Microsoft Excel
Delete Tip from MyTips Calculating Absolute Difference between Two Time Values
Delete Tip from MyTips Calculating Canadian Mortgage Payments
Delete Tip from MyTips Using Different Functions to Consolidate Lists
Delete Tip from MyTips Counting the Number of Dates with Matching Month Criteria
Delete Tip from MyTips Calculating Total Time Worked on a
Delete Tip from MyTips Mail the Activeworkbook using VBA in Microsoft Excel
Delete Tip from MyTips An Improved Custom Random Numbers Function
Delete Tip from MyTips Add and Save new Workbook using VBA in Microsoft Excel
Delete Tip from MyTips Grouping the Date Field by Number of Days
Delete Tip from MyTips Count by color using VBA in Microsoft Excel
Delete Tip from MyTips File names and folder names using VBA in Microsoft Excel
Delete Tip from MyTips Mail sheet(s) to one or more people using VBA in Microsoft Excel
Delete Tip from MyTips Adding Continuous Page Numbers While Printing
Delete Tip from MyTips Sorting by Columns
Delete Tip from MyTips Adding the Custom Views Icon to the Excel Menu Bar
Delete Tip from MyTips Retrieving the Value of the First Nonblank Cell in a List
Delete Tip from MyTips Returning the Entire Contents of the Row Containing the Highest Math Grade
Delete Tip from MyTips Give a non-Excel look by Hiding the Active Menu And Using Full Screen using VBA in Microsoft Excel
Delete Tip from MyTips Rounding Numbers to Thousands with Hundreds as a Decimal
Delete Tip from MyTips ”Desprender” Paletas desde la Barra de Herramientas
Delete Tip from MyTips Move row into worksheet after entry of worksheet name into row using VBA in Microsoft Excel
Delete Tip from MyTips Export data from Excel to Access (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Validating text entries in Microsoft Excel
Delete Tip from MyTips Creating a custom Report Manager by writing a short VBA program in Microsoft Excel
Delete Tip from MyTips Access the Private module of a Worksheet Object while in Excel
Delete Tip from MyTips Create worksheets from a list of names using VBA in Microsoft Excel
Delete Tip from MyTips Copying and Pasting Validation list only in Microsoft Excel
Delete Tip from MyTips Control Word from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Preventing Moving to the Next Cell After Typing
Delete Tip from MyTips Automating the Insertion of the Euro Symbol
Delete Tip from MyTips Prevent a UserForm from closing when the user clicks the x-button using VBA in Microsoft Excel
Delete Tip from MyTips Copy a row or rows from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Data Field That Calculates Percentages from One Item of the Row Field
Delete Tip from MyTips Avoiding False Results when Counting Dates Matching Specified Criteria
Delete Tip from MyTips Copying/Moving a Cell(s) Between Sheets/Workbooks
Delete Tip from MyTips Eliminating Negative Values from Date Subtractions
Delete Tip from MyTips The Best Shortcut Keys in Microsoft Excel
Delete Tip from MyTips Find the minimum positive value in Microsoft Excel
Delete Tip from MyTips Sizing Charts with the Window in Microsoft Excel.
Delete Tip from MyTips Autoexpanding a Date Type Chart using Microsoft Excel
Delete Tip from MyTips Counting Values that Appear Only Once in
Delete Tip from MyTips Reemplazando Ceros con signos “-“ en el Formato Numérico
Delete Tip from MyTips Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
Delete Tip from MyTips Transposing a Column into Successive Rows of a Specified Length
Delete Tip from MyTips Change all cells in a range to values using VBA in Microsoft Excel
Delete Tip from MyTips Copying the Subtotals Summary
Delete Tip from MyTips Finding the Number of Days in a Given Month
Delete Tip from MyTips Changing the Number of Files Shown in the Recently Used File List
Delete Tip from MyTips Determine if an application is available using VBA in Microsoft Excel
Delete Tip from MyTips Identifying Numeric Values within a Range Formatted as Text
Delete Tip from MyTips Adding the Path Address to the Header/Footer
Delete Tip from MyTips Selecting a Column(s) or Row(s) Using Keyboard Shortcuts
Delete Tip from MyTips Sum the largest two numbers in range in Microsoft Excel
Delete Tip from MyTips Retrieving Values from another Excel Workbook Using Text References
Delete Tip from MyTips Moving to the Last (or First) Cell in a Range
Delete Tip from MyTips Seleccionando Rápidamente un Rango de Celdas
Delete Tip from MyTips Changing the Cell Formatting from Date to Number
Delete Tip from MyTips Printing a PivotTable Report
Delete Tip from MyTips Separating a Number Into Digits
Delete Tip from MyTips Forecasting Daily Budget
Delete Tip from MyTips Retrieving the Entire Row of a Matched Value
Delete Tip from MyTips Adding Data, Charts, or Other Information to a Cell Comment
Delete Tip from MyTips Changing an Absolute Reference to a Relative Reference or Vice Versa
Delete Tip from MyTips PivotTable report - Grouping Text Fields
Delete Tip from MyTips Preventing charts from being printed in Microsoft Excel
Delete Tip from MyTips Retrieving Data from a PivotTable Report
Delete Tip from MyTips Counting Date Values by Specified Date Criteria
Delete Tip from MyTips Rounding Numbers that Meet Specified Criteria
Delete Tip from MyTips Delete rows and columns using VBA in Microsoft Excel
Delete Tip from MyTips Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
Delete Tip from MyTips Excel 2003 Resources on the Web
Delete Tip from MyTips Finding the Score that Was the Nth Highest for a Specified Team
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet in Excel 2007
Delete Tip from MyTips Counting Rows of Even Numbers in Two Parallel Ranges
Delete Tip from MyTips Use listboxes with multiple choices using VBA in Microsoft Excel
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page in Excel 2007
Delete Tip from MyTips Using Date & Time Criteria to Count Entries in a Combined Date & Time List
Delete Tip from MyTips Copiando y Pegando Rápido a la Derecha o Debajo en una Lista
Delete Tip from MyTips Retrieving Values from a List that are Greater than a Specified Number
Delete Tip from MyTips Copying, Cutting and Pasting (Moving)
Delete Tip from MyTips Set row height and column width in millimeters using VBA in Microsoft Excel
Delete Tip from MyTips Create a new module using VBA in Microsoft Excel
Delete Tip from MyTips Usando una Imagen para Ver Valores de Celda en Otras Hojas
Delete Tip from MyTips Applying Colors to Maximum/Minimum Values in a List
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips Validating Number Entries
Delete Tip from MyTips Count the number of cells in a range in Microsoft Excel
Delete Tip from MyTips Formulas to calculate Loan payments in Microsoft Excel
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout
Delete Tip from MyTips Format number in joining text with linked number in Microsoft Excel
Delete Tip from MyTips Moving Between Open Workbooks
Delete Tip from MyTips PDF2XL Enterprise
Delete Tip from MyTips Summing using multiple criteria in Microsoft Excel
Delete Tip from MyTips Changing the Font Size of the Sheet Name
Delete Tip from MyTips Summing the Visible Filtered List Values in Excel 2007
Delete Tip from MyTips Grouping Text Fields in Excel 2007
Delete Tip from MyTips Copying Styles from One Workbook to Another
Delete Tip from MyTips Copy from row till the last row with data into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Delete module content using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Standard Font in Excel 2007
Delete Tip from MyTips Removing All Page Breaks from the Sheet
Delete Tip from MyTips Select a Style in Excel 2007
Delete Tip from MyTips Deleting the Word "Total" from the subtotal List
Delete Tip from MyTips Unnecessary Blank Characters in Cells in Excel 2007
Delete Tip from MyTips Add Group and Outline in Excel 2007
Delete Tip from MyTips Using Different Functions to Consolidate Lists in excel 2007
Delete Tip from MyTips Calculating the Week Number
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Sum by color using VBA in Microsoft Excel
Delete Tip from MyTips Working Out a Person's Age in Microsoft Excel
Delete Tip from MyTips Count the number of words in a cell in Microsoft Excel
Delete Tip from MyTips Add special symbols to the number format
Delete Tip from MyTips Opening Workbooks from a List of Hyperlinks in Excel 2007
Delete Tip from MyTips Summing Values from Two Ranges, Based on Two Criteria
Delete Tip from MyTips Print all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Vlookup Formula – Eliminating Errors
Delete Tip from MyTips Quickly Removing Subtotals
Delete Tip from MyTips Total the Table in Excel 2007
Delete Tip from MyTips Return error values from user defined functions using VBA in Microsoft Excel
Delete Tip from MyTips Problem: Unnecessary Empty Characters in Cells
Delete Tip from MyTips Retrieving Every nth Value In a Range
Delete Tip from MyTips Prevent that an automacro/eventmacro executes using VBA in Microsoft Excel
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips Vinculando una Celda a un Cuadro de Texto
Delete Tip from MyTips Adding a Number to a Formatted Time Value
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Validando Datos Numéricos
Delete Tip from MyTips Calculating Daily Pay, Incorporating Variable Hourly Rates
Delete Tip from MyTips Copying the Page Setup to Other Sheets in Excel 2007
Delete Tip from MyTips Conditional formatting depending on a cell comment using VBA in Microsoft Excel
Delete Tip from MyTips Show the time in the Format hh:mm:000 using VBA
Delete Tip from MyTips Quick Filtering Using the AutoFilter Icon
Delete Tip from MyTips Usando la Validación de Mensaje Entrante como un Comentario de Celda
Delete Tip from MyTips Coloring Even Numbered Rows in a List
Delete Tip from MyTips Transposing Values from Columns into Rows, and Vice Versa
Delete Tip from MyTips Use VLOOKUP Function as an alternative to a number of nested IF functions.
Delete Tip from MyTips Square root and cube root in Microsoft Excel
Delete Tip from MyTips Summing matching values in multiple rows
Delete Tip from MyTips Color Unique Record in a Range in Excel 2007
Delete Tip from MyTips Return the cell reference as text in Microsoft Excel
Delete Tip from MyTips Combine the VLookup and Match formulas in Microsoft Excel
Delete Tip from MyTips Calculating a Building's Occupancy Rate at Specified Times
Delete Tip from MyTips Copiando un Comentario de Celda
Delete Tip from MyTips Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells
Delete Tip from MyTips Icons Disappearing from the Toolbar
Delete Tip from MyTips Separtaing A String Into Substrings.
Delete Tip from MyTips Extracting last Word
Delete Tip from MyTips Getting Drill-Down Details in Excel 2007
Delete Tip from MyTips Summing How Many Points Scored by a Specified Team in Specified Games
Delete Tip from MyTips Finding a substring within a string
Delete Tip from MyTips Unhide rows and columns by using Custom Views in Microsoft Excel.
Delete Tip from MyTips Disregarding blank cells when performing calculations on a range.
Delete Tip from MyTips Multiplying time values and numbers.
Delete Tip from MyTips Creating a World Time Converter
Delete Tip from MyTips Calculate number of minutes between dates - time in Microsoft Excel
Delete Tip from MyTips Rounding the Calculation of Retail Price and Sales Tax
Delete Tip from MyTips Build an Excel Add-In in Microsoft Excel
Delete Tip from MyTips PivotTable report - Adding a Calculated Field
Delete Tip from MyTips Problem: The Characters Are in Reverse Order
Delete Tip from MyTips Changing the Source Link
Delete Tip from MyTips Formatting a Negative Number with Parentheses
Delete Tip from MyTips Calculating the Date of the Nth Specific Day of the Month
Delete Tip from MyTips Class modules using VBA in Microsoft Excel
Delete Tip from MyTips Limiting the Movement in a Protected Sheet
Delete Tip from MyTips Combining Text and Formatted Values
Delete Tip from MyTips List and add the days of months in a set period using VBA in Microsoft Excel
Delete Tip from MyTips Selecting Cells That Contain Errors in Formulas in Excel 2007
Delete Tip from MyTips Agregando un Método Abreviado Personalizado
Delete Tip from MyTips Calculating the Average of Every Nth Value
Delete Tip from MyTips Deleting Empty Rows
Delete Tip from MyTips Set the Background Color according to the date using VBA in Microsoft Excel
Delete Tip from MyTips Altering the results returned by VLOOKUP.
Delete Tip from MyTips Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
Delete Tip from MyTips Quickly Entering Text into Cells from a List of Previous Entries or a Validation List
Delete Tip from MyTips Quick Move to end of range of cells in Microsoft Excel
Delete Tip from MyTips Retrieving the Value of the First Non-Blank Cell in a List
Delete Tip from MyTips Finding Every Third Number and Returning the Largest of Them
Delete Tip from MyTips Using Financial Functions
Delete Tip from MyTips Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
Delete Tip from MyTips Merge cells without loosing values using VBA in Microsoft Excel
Delete Tip from MyTips Unintentionally Creating Links Between Workbooks
Delete Tip from MyTips Change the value/content of several UserForm-controls using VBA in Microsoft Excel
Delete Tip from MyTips Print multiple selections on one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Finding Specified Items in a List and Averaging their Associated Values
Delete Tip from MyTips Simplifying complicated multiplication calculations using the SUMPRODUCT function
Delete Tip from MyTips Protecting Data by Hiding a Row(s) and Column(s)
  To delete a tip, simply click on the trash icon of the tip you wish to remove




  1. Retrieving an Item from a List that Meets Multiple Criteria
  2. Simplifying Formulas by Reducing the Complexity of IF Functions
  3. The Best Shortcut Keys in Microsoft Excel
  4. Retrieving Values Using Range Names as References
  5. Copy Selection to a Database sheet using VBA in Microsoft Excel
  6. Create User Forms in Microsoft Excel
  7. Writing Your First VBA Function in Excel
  8. Replace text in a text file using VBA in Microsoft Excel
  9. Using Loops in VBA in Microsoft Excel
  10. Add Combo Box to a Sheet in Microsoft Excel
  11. Formulas to calculate Loan payments in Microsoft Excel
  12. Turn off warning messages using VBA in Microsoft Excel
  13. Summing Rounded Numbers
  14. Adding the Page Setup Icon to the Excel Menu Bar
  15. Calculating the Number of Business Days in a Specified Period
  16. Rounding Hours Up
  17. Find duplicates items in combine columns in Microsoft Excel
  18. Create an Amortization Schedule in Microsoft Excel
  19. Summing Stock Lists
  20. Working Out a Person's Age in Microsoft Excel



Excel 2007 Tutorials

SEO

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation