|  

» 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 Calculating the Difference Between Hours
Delete Tip from MyTips Comparing Lists Using the COUNTIF Formula
Delete Tip from MyTips Coloring Rows Based on Text Criteria
Delete Tip from MyTips List all the workbook links in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Average of Every Nth Value, Excluding Zeros
Delete Tip from MyTips Sort the worksheets in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Adding the full path of the saved file to headers and footers in Microsoft Excel 2002 xp
Delete Tip from MyTips Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
Delete Tip from MyTips Avoiding Errors When Counting Date Values That Meet Specified Criteria
Delete Tip from MyTips Converting Time Values from One Time Zone to Another
Delete Tip from MyTips Shuffling a List of Values
Delete Tip from MyTips Summing Values at the Intersection of Two or more Ranges
Delete Tip from MyTips Summing Values In a Range Specified By Indirect Cell References
Delete Tip from MyTips Retrieving from List by Position
Delete Tip from MyTips Validando Datos Numéricos
Delete Tip from MyTips Create day sheets of a month without weekends and holidays using VBA
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Replacing Data Markers with Pictures in Microsoft Excel
Delete Tip from MyTips Preventing charts from being printed in Microsoft Excel
Delete Tip from MyTips Validating Date Entries
Delete Tip from MyTips Preventing Duplicates When Entering Data
Delete Tip from MyTips Checking Whether Cells in a Range are Blank, and Counting the Blank Cells
Delete Tip from MyTips Range Name Syntax
Delete Tip from MyTips Defining a Range Name
Delete Tip from MyTips Class modules using VBA in Microsoft Excel
Delete Tip from MyTips Summing matching values in multiple rows
Delete Tip from MyTips Opening a Linked Workbook in Microsoft Excel
Delete Tip from MyTips COUNT Formulas
Delete Tip from MyTips Calculating a Building's Occupancy Rate at Specified Times
Delete Tip from MyTips Copiando y Pegando el Contenido de Celdas Conservando el Formato
Delete Tip from MyTips Protecting Workbooks with a Digital Signature in Excel 2007
Delete Tip from MyTips Calculating Differences Between Dates
Delete Tip from MyTips Retrieve the Distance between Any Two Cities from Distance Table
Delete Tip from MyTips Inserting Special Symbols into Custom Formats
Delete Tip from MyTips Sort Ascending/Descending While Using AutoFilter
Delete Tip from MyTips Retrieving a Specific Cell from Multiple Sheets
Delete Tip from MyTips Merging and Centering with a Toggle Button in Excel 2002 and Excel 2003
Delete Tip from MyTips Calculating Number of Days, Weeks, Months and Years between Dates
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 97
Delete Tip from MyTips Sorting by Custom Lists in Excel 2007
Delete Tip from MyTips How to find the minimum value in range while ignoring 0 value in Microsoft Excel
Delete Tip from MyTips Retrieving the Column Header of the Next Non-Blank Cell in a Row
Delete Tip from MyTips Additional Functions in AutoSum
Delete Tip from MyTips Finding Minimum / Maximum Values
Delete Tip from MyTips Summing Corresponding Values in Multiple Columns
Delete Tip from MyTips Finding the Largest Number among Those Meeting Specified Criteria
Delete Tip from MyTips Changing the Cell Comment Shape
Delete Tip from MyTips Reducing the Workbook Size for Quick Sending via E Mail
Delete Tip from MyTips Inserting/Editing Formulas
Delete Tip from MyTips Removing Hidden Apostrophes from Imported Numbers
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
Delete Tip from MyTips Coloring Two Subtotal Levels in Different Colors
Delete Tip from MyTips Import data from a closed workbook (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Placing the Previous Payment Date beside Each Pay Date in a List
Delete Tip from MyTips Make LEFT Function recognize a number
Delete Tip from MyTips The Power Combination
Delete Tip from MyTips Adding the Subtotals Icon to the Menu Bar
Delete Tip from MyTips Summing Total Sales, Based on Quantity & Price
Delete Tip from MyTips Combine the Index and Match formulas in Microsoft Excel
Delete Tip from MyTips Sorting by Cell Color, Font Color or Cell Icon in Excel 2007
Delete Tip from MyTips Creating Formulas that Only Return Results from Non-Blank Cells
Delete Tip from MyTips Calculating Commissions Based on Sales Rank
Delete Tip from MyTips Counting the Number of Values Between Upper and Lower Limits
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout
Delete Tip from MyTips Using the Macro Recorder in Microsoft Excel
Delete Tip from MyTips Avoiding False Results when Counting Dates Matching Specified Criteria
Delete Tip from MyTips Displaying the Workbook's Path in the Address Box
Delete Tip from MyTips Hiding/Unhiding a Row(s) or Column(s)
Delete Tip from MyTips Adding Groups and Outlines Manually
Delete Tip from MyTips Retrieve information from a range in another Excel File when the Path & File Name strings stored in various cells.
Delete Tip from MyTips Show the full name ( path and workbook name ) in the menu bar in Microsoft Excel
Delete Tip from MyTips Changing an Absolute Reference to a Relative Reference or Vice Versa
Delete Tip from MyTips Printing Non-Continuous Areas in Excel 2007
Delete Tip from MyTips Canceling the Update Links Message While Opening a Linked Workbook in Excel 2007
Delete Tip from MyTips Return random numbers using VBA in Microsoft Excel
Delete Tip from MyTips Working Out a Person's Age in Microsoft Excel
Delete Tip from MyTips Generate a random value between two limits 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 Summing a range containing errors and values in Microsoft Excel
Delete Tip from MyTips Inserting the path where the Workbook is saved to the title bar or the status bar using VBA in Microsoft Excel
Delete Tip from MyTips Validating text entries in Microsoft Excel
Delete Tip from MyTips Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Moving Between Precedent and Dependent Cells in Excel 2007
Delete Tip from MyTips Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
Delete Tip from MyTips Copy all rows of a column without a value using VBA in Microsoft Excel
Delete Tip from MyTips Insertando una Celda(s) sin Sobrescribir Datos Existentes
Delete Tip from MyTips Quick Move to end of range of cells in Microsoft Excel
Delete Tip from MyTips Convert between column numbers and column references using VBA in Microsoft Excel
Delete Tip from MyTips Copying the Subtotals Summary in Excel 2007
Delete Tip from MyTips Adding a Specified Number of Months to a Date
Delete Tip from MyTips Reduciendo el Área Utilizada en una Hoja
Delete Tip from MyTips Selecting a row or rows in Microsoft Excel
Delete Tip from MyTips Summing How Many Points Scored by a Specified Team in Specified Games
Delete Tip from MyTips Cambiando un Encabezado Numérico a Texto
Delete Tip from MyTips Close a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Creating a PivotTable Report
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Change the availability for a menu item using VBA in Microsoft Excel
Delete Tip from MyTips Making a Cell the First Cell in the Active Window
Delete Tip from MyTips Separating a Number Into Digits
Delete Tip from MyTips Import data from Access to Excel (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Quarter Number for Calendar and Fiscal Year
Delete Tip from MyTips Retrieving the Value of the First Non-Blank Cell in a List
Delete Tip from MyTips Calculating a Project's End Date
Delete Tip from MyTips Filtering a List into Unique Records Using the COUNTIF Formula
Delete Tip from MyTips Find the last numeric value in a range in Microsoft Excel
Delete Tip from MyTips Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel
Delete Tip from MyTips Converting Text Representing Minutes and Seconds into Numerical Values
Delete Tip from MyTips Apply Formatting to List/Table in Excel 2007
Delete Tip from MyTips Copy a range on the place of the Activecell to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Displaying Formula Syntax in Excel 2007
Delete Tip from MyTips Watch Calculation Results Immediately in Excel 2007
Delete Tip from MyTips Weeknumbers using VBA in Microsoft Excel
Delete Tip from MyTips Seleccionando la Lista/Región Actual
Delete Tip from MyTips Icons Disappearing from the Toolbar
Delete Tip from MyTips Creating PivotTable in Excel 2007
Delete Tip from MyTips Copying the Subtotals Summary
Delete Tip from MyTips Dividiendo el Primer Título Superior Izquierdo
Delete Tip from MyTips Validating Data To Be Unique In A Range
Delete Tip from MyTips Avoiding the Occurrence of Unexpected VLOOKUP #N/A Errors
Delete Tip from MyTips Counting Rows of Even Numbers in Two Parallel Ranges
Delete Tip from MyTips Summing Annual Expenses by Respective Quarters
Delete Tip from MyTips Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
Delete Tip from MyTips Summing the N Largest Values in a Range
Delete Tip from MyTips Adding a Custom Function That Returns the Quarter Number
Delete Tip from MyTips Preventing Moving to the Next Cell after Typing in Excel 2007
Delete Tip from MyTips Summing Across Multiple Sheets
Delete Tip from MyTips Add a New Comment in Excel 2007
Delete Tip from MyTips Avoiding Errors When Subtracting Times
Delete Tip from MyTips Adding Time Values
Delete Tip from MyTips Changing the Standard Font
Delete Tip from MyTips Funcionalidades Expandidas de Pegado de Íconos en Excel 2002 y Excel 2003
Delete Tip from MyTips What's New in Excel 2003
Delete Tip from MyTips Adding Continuous Page Numbers While Printing
Delete Tip from MyTips Cambiando el Número Predeterminado de Hojas en un Nuevo Libro
Delete Tip from MyTips Hiding Cells before Printing in Excel 2007
Delete Tip from MyTips Unnecessary Blank Characters in Cells in Excel 2007
Delete Tip from MyTips Delete a module using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Lowest Common Multiple (LCM)
Delete Tip from MyTips Use a closed workbook as a database (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Vinculando una Celda a un Cuadro de Texto
Delete Tip from MyTips Grouping/ Ungrouping Sheets
Delete Tip from MyTips Sort Ascending/Descending While Using Filter in Excel 2007
Delete Tip from MyTips Merge cells without loosing values using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Date of the Nth Specific Day of the Month
Delete Tip from MyTips Adding and Saving a New Customized Toolbar
Delete Tip from MyTips Inserting a picture (company logo) in Microsoft Excel 97 and 2000
Delete Tip from MyTips Change the selection with one or more areas to Values using VBA in Microsoft Excel
Delete Tip from MyTips Problem: Unnecessary Empty Characters in Cells
Delete Tip from MyTips Change a Column or Columns to values using VBA in Microsoft Excel
Delete Tip from MyTips Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
Delete Tip from MyTips Displaying the serial number behind Date format in Microsoft Excel
  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. Create User Forms in Microsoft Excel
  6. Copy Selection to a Database sheet using VBA 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