|  

» 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 Control Word from Excel 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 Set row height and column width in millimeters using VBA in Microsoft Excel
Delete Tip from MyTips Access the Private module of a Worksheet Object while in Excel
Delete Tip from MyTips Control Outlook from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Expanded Paste Icon Features in Excel 2002 & Excel 2003
Delete Tip from MyTips Counting the Number of Items Sold Every Half Hour
Delete Tip from MyTips Copy a column or columns from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
Delete Tip from MyTips Creating a Dynamic Inventory List Based on Daily Sales
Delete Tip from MyTips Create an Amortization Schedule in Microsoft Excel
Delete Tip from MyTips Return random numbers using VBA in Microsoft Excel
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet in Excel 2007
Delete Tip from MyTips Table Tools Ribbon in Excel 2007
Delete Tip from MyTips Preventing charts from being printed in Microsoft Excel
Delete Tip from MyTips Calculate holidays using VBA in Microsoft Excel
Delete Tip from MyTips Fill a ListBox with unique values from a worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Extract all the words except the first in Microsoft Excel
Delete Tip from MyTips Prevent entry of invalid values using VBA in Microsoft Excel
Delete Tip from MyTips Function for returning the computer name 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 Allowing Multiple Users to Edit Ranges in Microsoft Excel
Delete Tip from MyTips Totaling Two Ranges Using the SUMIF Formula
Delete Tip from MyTips Backing Up Customized Changes to Toolbars and Menus
Delete Tip from MyTips Retrieving the Minimal / Maximal Values from a Filtered List
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 Hiding Data Before Printing
Delete Tip from MyTips Adding a Number to a Formatted Time Value
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003
Delete Tip from MyTips Summing Using Text Characters as Criteria
Delete Tip from MyTips Printing a Custom View in Excel 2007
Delete Tip from MyTips Icons Disappearing from the Toolbar
Delete Tip from MyTips List all fonts available in Excel using VBA in Microsoft Excel
Delete Tip from MyTips Automatizando la Inserción del Símbolo Euro
Delete Tip from MyTips Working Out a Person's Age in Microsoft Excel
Delete Tip from MyTips Reversing The Order Of Values In A List
Delete Tip from MyTips Changing the Source Link
Delete Tip from MyTips Setting the Number of Fields Displayed in the Page Layout
Delete Tip from MyTips Chart object events using VBA in Microsoft Excel
Delete Tip from MyTips Sorting Sheets in Ascending Order
Delete Tip from MyTips Array variables using VBA in Microsoft Excel
Delete Tip from MyTips Delete all cells with today's date using VBA
Delete Tip from MyTips Summing Rounded Numbers
Delete Tip from MyTips Summing the Number of Hours an Employee Worked During a Two Week Period
Delete Tip from MyTips Determining whether Two Given Dates Occur within the Same Week
Delete Tip from MyTips Restricting the Number of Characters Entered into a Cell
Delete Tip from MyTips Find the Alphabetically Lowest Letter in a List
Delete Tip from MyTips Adding the Path Address to the Header/Footer
Delete Tip from MyTips Creating a Counting Grid
Delete Tip from MyTips Retrieving Values from another Excel Workbook Using Text References
Delete Tip from MyTips Calculating Military Time Intervals
Delete Tip from MyTips Show/Hide Expand Items Buttons in Excel 2007
Delete Tip from MyTips Show the time in the Format hh:mm:000 using VBA
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet
Delete Tip from MyTips Change the availability for the shortcut menus using VBA in Microsoft Excel
Delete Tip from MyTips Reversing the Word Order within a String
Delete Tip from MyTips Summing Rounded Numbers
Delete Tip from MyTips Avoiding Errors when Subtracting Times
Delete Tip from MyTips Comparing Three or More Lists in Microsoft Excel
Delete Tip from MyTips Copying Formulas and Pasting Them in a Transposed Direction Without Changing the Relative References
Delete Tip from MyTips Converting Time to Decimal Values
Delete Tip from MyTips Tracing Errors in Formula Results in Excel 2007
Delete Tip from MyTips Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
Delete Tip from MyTips Return text up to the second space in Microsoft Excel
Delete Tip from MyTips Using a Picture to Watch Cell Values in Other Sheets
Delete Tip from MyTips Determine if a workbook is already open using VBA in Microsoft Excel
Delete Tip from MyTips Replacing Zeros with Dashes in Number Formatting
Delete Tip from MyTips Modifying a SUMPRODUCT function to Return a Sum Rather than a Count
Delete Tip from MyTips Dividing a First Left Heading Title in Excel 2007
Delete Tip from MyTips Quickly Entering a Long Company or Person Name
Delete Tip from MyTips Preventing Moving to the Next Cell After Typing
Delete Tip from MyTips Private Profile Strings using INI-files using VBA in Microsoft Excel
Delete Tip from MyTips Coloring Visible Rows in Filtered List in Excel 2007
Delete Tip from MyTips Retrieving the Entire Row of a Matched Value
Delete Tip from MyTips Changing the Name of the Cell Comments Author in Excel 2007
Delete Tip from MyTips Finding the First Login and Last Logout Times of Employees
Delete Tip from MyTips Calculate number of minutes between dates - time in Microsoft Excel
Delete Tip from MyTips Formulas Erroneously Appearing as Text
Delete Tip from MyTips Formulas to calculate Loan payments in Microsoft Excel
Delete Tip from MyTips Creating Charts with F11 in Microsoft Excel
Delete Tip from MyTips Rounding a Value to Make It Divisible by a Specified Number
Delete Tip from MyTips Grouping/ Ungrouping Sheets
Delete Tip from MyTips Automating the Insertion of the Euro Symbol
Delete Tip from MyTips Inserting a Calculated Field in Excel 2007
Delete Tip from MyTips Averaging Values that Correspond with the X Largest Values in a Dynamic Range
Delete Tip from MyTips Copy a range with more Areas to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Default Cell Comment Format
Delete Tip from MyTips Displaying Formula Syntax
Delete Tip from MyTips Tracing Errors in Formula Results
Delete Tip from MyTips Entering Times Quickly
Delete Tip from MyTips Printing Formula Syntax
Delete Tip from MyTips Mostrando Todos los Elementos al Escoger de un Menú
Delete Tip from MyTips Automatically Wrapping Text in a Cell
Delete Tip from MyTips Countdown in status bar using VBA in Microsoft Excel
Delete Tip from MyTips Totaling Time Values
Delete Tip from MyTips Dividing a First Left Heading Title
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
Delete Tip from MyTips Coloring Gridlines in Excel 2007
Delete Tip from MyTips Cambiar la Sangría en una Celda
Delete Tip from MyTips Display a CommandBar centered on the screen using VBA in Microsoft Excel
Delete Tip from MyTips List files in a folder with Office 97 or later using VBA in Microsoft Excel
Delete Tip from MyTips Problem: Unnecessary Empty Characters in Cells
Delete Tip from MyTips Checking For Duplicate Values Within A Range
Delete Tip from MyTips How to eliminate N/A error result when using Vlookup formula in Microsoft Excel
Delete Tip from MyTips Altering the results returned by VLOOKUP.
Delete Tip from MyTips Watch Cell Information at a Distance
Delete Tip from MyTips Inserting a Chart in Excel 2007
Delete Tip from MyTips Get the value of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Manually Wrapping Text in a Cell in Excel 2007
Delete Tip from MyTips Display all installed fonts (Excel) using VBA in Microsoft Excel
Delete Tip from MyTips Sorting by Cell Color, Font Color or Cell Icon in Excel 2007
Delete Tip from MyTips Protecting Data by Hiding a Row(s) and Column(s)
Delete Tip from MyTips Opening a Copy of an Existing Workbook
Delete Tip from MyTips Inserting Subtotals Quickly
Delete Tip from MyTips Saving Defined Page Setups for Future Printing
Delete Tip from MyTips Sorting Rules in Excel 2007
Delete Tip from MyTips Use the built-in dialogs using VBA in Microsoft Excel
Delete Tip from MyTips Password to prevent opening a workbook in Microsoft Excel
Delete Tip from MyTips Coloring Numbers Based on Specific Criteria
Delete Tip from MyTips Determining Which Quarter a Specified Date Corresponds With
Delete Tip from MyTips Grouping the Date Field by Number of Days
Delete Tip from MyTips Returning the Entire Contents of the Row Containing the Highest Math Grade
Delete Tip from MyTips Creando y Guardando Estilos Predeterminados
Delete Tip from MyTips Cambiando la Fuente Estándar
Delete Tip from MyTips Counting Unique Numeric Values or Unique Data in a List
Delete Tip from MyTips Set up conditional formatting for an area with VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Grade Value for Corresponding Mark
Delete Tip from MyTips Use Smart Tag to fill series of dates in Microsoft Excel
Delete Tip from MyTips Quick Filtering Using the AutoFilter Icon
Delete Tip from MyTips Manually Wrapping Text in a Cell
Delete Tip from MyTips Transposing Cells
Delete Tip from MyTips Change all cells in a range to values using VBA in Microsoft Excel
Delete Tip from MyTips Index Formula vs. Vlookup Formula
Delete Tip from MyTips Change the availability for the CommandBars using VBA in Microsoft Excel
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in All Sheets
Delete Tip from MyTips The SUMIF Formula – Using Comparison Operators ( ) as Criteria
Delete Tip from MyTips Moving Between Unprotected Cells in a Protected Sheet
Delete Tip from MyTips Copy the CurrentRegion of a cell of each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Handling Errors in Values & Empty cells in Excel 2007
Delete Tip from MyTips Avoiding False Results when Counting Dates Matching Specified Criteria
Delete Tip from MyTips Array Formulas in Excel 2007
Delete Tip from MyTips Count the number of cells in a range containing all types of Errors in Microsoft Excel
Delete Tip from MyTips Change the default printer using VBA in Microsoft Excel
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 Agregando Datos, Tablas, u Otra Información al Comentario de una Celda
Delete Tip from MyTips Protegiendo Datos Ocultando una Fila(s) y Columna(s)
Delete Tip from MyTips Counting the Number of Times a Specified Substring Appears within a Range of Strings
Delete Tip from MyTips Creating a custom Report Manager by writing a short VBA program in Microsoft Excel
Delete Tip from MyTips Removing the Smart Tag Indicator
Delete Tip from MyTips Combining Numbers that Have Leading Zeros
Delete Tip from MyTips Counting the Number of Cells Containing Text
Delete Tip from MyTips Calculating Commissions Based on Sales Rank
Delete Tip from MyTips Problem: The Minus Sign Appears to the Right of the Number
Delete Tip from MyTips Change range with more then Area to values using VBA in Microsoft Excel
Delete Tip from MyTips Creating List Objects
Delete Tip from MyTips Color numbers based on the value result in Microsoft Excel
Delete Tip from MyTips Displaying the serial number behind Date format in Microsoft Excel
Delete Tip from MyTips Joining text using formula in Microsoft Excel
Delete Tip from MyTips Transfer data from a recordset to a worksheet (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Personalizando un Icono
Delete Tip from MyTips Nesting Formulas
Delete Tip from MyTips Hiding Cells before Printing in Excel 2007
Delete Tip from MyTips Aumentando/Disminuyendo el Porcentaje de Aumento de la Pantalla
Delete Tip from MyTips Add Group and Outline in Excel 2007
Delete Tip from MyTips Combining Text and Formatted Values
Delete Tip from MyTips Delete rows and columns using VBA in Microsoft Excel
Delete Tip from MyTips Sorting Rules & List Structure
Delete Tip from MyTips Copying the Page Setup to Other Sheets
Delete Tip from MyTips Entering Dates Quickly
Delete Tip from MyTips Calculate commission percentage based on a commission schedule in Microsoft Excel
Delete Tip from MyTips Unintentionally Creating Links between Workbooks in Excel 2007
Delete Tip from MyTips Protecting the Sheet or the Cells in the Sheet
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips Copying a Cell Comment
Delete Tip from MyTips ”Desprender” Paletas desde la Barra de Herramientas
Delete Tip from MyTips Avoiding Negative Values when Calculating the Number of Days between Two Dates
Delete Tip from MyTips Sort Ascending/Descending While Using AutoFilter
Delete Tip from MyTips Calculate Average Speed in Microsoft Excel
Delete Tip from MyTips Using the Validation Input Message as a Cell Comment
Delete Tip from MyTips Using Different Functions to Consolidate Lists
Delete Tip from MyTips Find duplicates items in combine columns in Microsoft Excel
Delete Tip from MyTips Using Cell Reference with Keyboard signs in the Criteria Range argument when using COUNTIF formula.
Delete Tip from MyTips Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
Delete Tip from MyTips Usando la Función Redondear para Redondear Números a Miles
Delete Tip from MyTips Summing data by selecting cells in Microsoft Excel
Delete Tip from MyTips Coloring One Record in Each Group in a Range
Delete Tip from MyTips The Power Combination
Delete Tip from MyTips Summing Positive and Negative Numbers Separately
Delete Tip from MyTips Protecting Workbooks with a Digital Signature
Delete Tip from MyTips Count by color using VBA in Microsoft Excel
Delete Tip from MyTips Additional Functions in AutoSum
Delete Tip from MyTips Coloreando un Registro en Cada Grupo en un Rango
Delete Tip from MyTips Creating a Custom Report Manager
Delete Tip from MyTips Checking For Sequences Within A Sorted List
Delete Tip from MyTips Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
Delete Tip from MyTips Calculating the Week Number Corresponding with a Specific Date
  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