|  

» 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 Rounding Numbers to Millions
Delete Tip from MyTips Quickly Selecting a Range in the Workbook
Delete Tip from MyTips Using multiple criteria in SUMIF Function
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields
Delete Tip from MyTips Change cells in the Activecell rowrange to values using VBA in Microsoft Excel
Delete Tip from MyTips Multiplying a Range by -1 in One Operation
Delete Tip from MyTips Coloring Rows Based on Text Criteria
Delete Tip from MyTips Calculating Canadian Mortgage Payments
Delete Tip from MyTips Find duplicates items in combine columns in Microsoft Excel
Delete Tip from MyTips Vlookup Formula – Organizing the Data Table
Delete Tip from MyTips Altering the results returned by VLOOKUP.
Delete Tip from MyTips Put a line at Foot of print page
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2000
Delete Tip from MyTips Summing How Many Points Scored by a Specified Team in Specified Games
Delete Tip from MyTips Combining Numbers that Have Leading Zeros
Delete Tip from MyTips Hiding Items
Delete Tip from MyTips Counting the Number of Values Meeting Criteria, but Only for Every 3rd Cell in a Range
Delete Tip from MyTips Opening a template file automatically upon starting Microsoft Excel
Delete Tip from MyTips Selecting Cells That Contain Errors in Formulas in Excel 2007
Delete Tip from MyTips Breaking Links between Workbooks in Excel 2007
Delete Tip from MyTips Worksheet events using VBA in Microsoft Excel
Delete Tip from MyTips Saving a Frequently Used Formula/Numeric Value in the Define Name Dialog Box
Delete Tip from MyTips Counting the Number of Times a Specified Substring Appears within a Range of Strings
Delete Tip from MyTips Nesting Formulas
Delete Tip from MyTips Pasting Multiple Copied Ranges Using the Clipboard
Delete Tip from MyTips Saving Defined Page Setups for Future Printing in Excel 2007
Delete Tip from MyTips Sorting by Cell Color, Font Color or Cell Icon in Excel 2007
Delete Tip from MyTips Replace text in a text file using VBA in Microsoft Excel
Delete Tip from MyTips Creating a Custom Report Manager
Delete Tip from MyTips Getting Values From A Closed Workbook using VBA in Microsoft Excel
Delete Tip from MyTips Subtracting Times
Delete Tip from MyTips Seeing Calculation Results Immediately
Delete Tip from MyTips Inserting a picture (company logo) in the header in Microsoft Excel 2002 xp
Delete Tip from MyTips The Best Shortcut Keys in Microsoft Excel
Delete Tip from MyTips Return unique items using VBA in Microsoft Excel
Delete Tip from MyTips Determine if a sheet exists in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Avoiding Negative Values when Calculating the Number of Days between Two Dates
Delete Tip from MyTips Adding Euro format to the number format in Microsoft Excel
Delete Tip from MyTips Combining the Contents of Every N Number of Cells into One Value
Delete Tip from MyTips Color numbers based on the value result in Microsoft Excel
Delete Tip from MyTips Inserting Subtotals Quickly
Delete Tip from MyTips Selecting Special Cells
Delete Tip from MyTips Circular References
Delete Tip from MyTips Validando Datos de Texto
Delete Tip from MyTips Using the COUNT Functions
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting
Delete Tip from MyTips Counting the Number of Cells Containing Text in a Range
Delete Tip from MyTips Format number in joining text with linked number in Microsoft Excel
Delete Tip from MyTips Coloring Numbers Based on Specific Criteria Using Conditional Formatting
Delete Tip from MyTips Reduciendo el Área Utilizada en una Hoja
Delete Tip from MyTips Copying/Moving a Cell(s) Between Sheets/Workbooks
Delete Tip from MyTips Linking a Cell to a Text Box
Delete Tip from MyTips Selecting Cells That Contain Formulas
Delete Tip from MyTips Select a printer tray before printing using VBA in Microsoft Excel
Delete Tip from MyTips Grouping/ Ungrouping Sheets
Delete Tip from MyTips Execute Command/Sub-Procedure Using Timer in VBA
Delete Tip from MyTips Finding the Number of Days in a Given Month
Delete Tip from MyTips Set background color depending on value verification using VBA in Microsoft Excel
Delete Tip from MyTips Change text in header when printing using VBA in Microsoft Excel
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Convert negative values treated as text using VBA in Microsoft Excel
Delete Tip from MyTips Find the value in the first non blank cell in range in Microsoft Excel
Delete Tip from MyTips Private Profile Strings using Words System.PrivateProfileString using VBA in Microsoft Excel
Delete Tip from MyTips Cambiando la Forma de un Comentario de Celda
Delete Tip from MyTips Create a new module using VBA in Microsoft Excel
Delete Tip from MyTips Mail the Activeworkbook using VBA in Microsoft Excel
Delete Tip from MyTips Determine the type of operating system using VBA in Microsoft Excel
Delete Tip from MyTips Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
Delete Tip from MyTips Print the pages in reverse order using VBA in Microsoft Excel
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Wrapping Text in a Cell
Delete Tip from MyTips Changing the Font Size of the Sheet Name
Delete Tip from MyTips An Improved Custom Random Numbers Function
Delete Tip from MyTips Adding a Calculated Percentage Field
Delete Tip from MyTips Using VLOOKUP and ISNA functions to find matching values in different sheets
Delete Tip from MyTips Protecting Data by Hiding a Row(s) and Column(s)
Delete Tip from MyTips Copy a Range from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Copy Selection to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Show/Hide Expand Items Buttons in Excel 2007
Delete Tip from MyTips Retrieving Sale Price Based on Item and Color Criteria
Delete Tip from MyTips Select bottom right end corner of the used area Microsoft Excel
Delete Tip from MyTips Joining text using formula in Microsoft Excel
Delete Tip from MyTips Changing the Default Auto-Save File Location
Delete Tip from MyTips Add space between characters and numbers in Microsoft Excel
Delete Tip from MyTips Inserting a Watermark Behind the Text
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened
Delete Tip from MyTips Creating a custom Report Manager by writing a short VBA program in Microsoft Excel
Delete Tip from MyTips Calculating Total Time Worked on a Specific Day
Delete Tip from MyTips Userdefined functions from other workbooks using VBA in Microsoft Excel
Delete Tip from MyTips Extracting Characters from Text Without Using Formulas
Delete Tip from MyTips Selecting Cells from Any Cell to the Last Cell in the Sheet's Used Range
Delete Tip from MyTips Shuffling a List of Values
Delete Tip from MyTips Import data from a closed workbook (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Preventing a VLOOKUP Function from Returning an Error when an Exact Match is Not Found
Delete Tip from MyTips Find the last numeric value in a range in Microsoft Excel
Delete Tip from MyTips Calculating a Building's Occupancy Rate at Specified Times
Delete Tip from MyTips Automatic Report formatting using option buttons
Delete Tip from MyTips Searching a String for a Matching Word from another String
Delete Tip from MyTips Copying the Page Setup to Other Sheets in Excel 2007
Delete Tip from MyTips Adding Subtotals to a Date Field
Delete Tip from MyTips Dando Color a las Líneas de División
Delete Tip from MyTips Sort Ribbon in Excel 2007
Delete Tip from MyTips Determining Whether a Person Worked a Full or Partial Shift
Delete Tip from MyTips Deleting Empty Rows
Delete Tip from MyTips Adding a Comment to a Formula
Delete Tip from MyTips Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007
Delete Tip from MyTips Ranking Salespeople According to Sales Figure
Delete Tip from MyTips Retrieving the Most Frequent Occurrence for Each Category
Delete Tip from MyTips Change the value/content of several UserForm-controls using VBA in Microsoft Excel
Delete Tip from MyTips PivotTable report - Grouping Text Fields
Delete Tip from MyTips Shortcuts to see the Help for the Syntax Function in Microsoft Excel
Delete Tip from MyTips Calculating an Average, Only Including Prices on Which There Was no Discount
Delete Tip from MyTips Displaying Numbers in Thousands in a Chart in Microsoft Excel
Delete Tip from MyTips Find the maximum numerical value in a list based on a criteria in Microsoft Excel
Delete Tip from MyTips Entering Times Quickly
Delete Tip from MyTips E-mailing an Excel Workbook, Sheet, Data or Chart
Delete Tip from MyTips Enter the holiday according to the Table in the holiday-list using VBA
Delete Tip from MyTips Copiando/Moviendo una Celda (o Celdas) entre Hojas/Libros de Trabajo
Delete Tip from MyTips Entering the Current Time into a Cell
Delete Tip from MyTips Avoiding Errors when Using the And Function to Combine Multiple Conditions in Array Formulas
Delete Tip from MyTips Opening a saved Workbook in Microsoft Excel
Delete Tip from MyTips Filtering by the Date Field
Delete Tip from MyTips Preventing a Printed Area from Extending onto an Extra Page
Delete Tip from MyTips Icons Disappearing from the Toolbar
Delete Tip from MyTips Displaying zero values in Microsoft Excel
Delete Tip from MyTips Prevent that an automacro/eventmacro executes using VBA in Microsoft Excel
Delete Tip from MyTips Avoiding False Results when Counting Dates Matching Specified Criteria
Delete Tip from MyTips Entering Formulas More Quickly by Shortening Sheet Names
Delete Tip from MyTips Summing Stock Lists
Delete Tip from MyTips Summing Numerical Substrings
Delete Tip from MyTips Generate total for dynamic area using VBA in Microsoft Excel
Delete Tip from MyTips Displaying the Serial Number Behind the Time
Delete Tip from MyTips Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Running Balance Calculation Column
Delete Tip from MyTips Converting Time to Decimal Values
Delete Tip from MyTips Sorting by Custom Lists
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Converting Text to Its Proper Case
Delete Tip from MyTips Compare two worksheet ranges using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Defining a Range Name
Delete Tip from MyTips Whats New in Excel 2007
Delete Tip from MyTips Unintentionally Creating Links between Workbooks in Excel 2007
Delete Tip from MyTips Identifying and selecting the print area in a sheet in Microsoft Excel
Delete Tip from MyTips Unprinted blank pages in Microsoft Excel 2002
Delete Tip from MyTips Copy a range with more Areas to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Coloreando Números Según un Criterio Específico Utilizando Formato Condicional
Delete Tip from MyTips Manually Wrapping Text in a Cell
Delete Tip from MyTips Calculating the Lowest Common Multiple (LCM)
Delete Tip from MyTips Opening a Copy of an Existing Workbook
Delete Tip from MyTips Combining Text and Numerically Calculated Results into One Output String
Delete Tip from MyTips Quickly Removing Subtotals
Delete Tip from MyTips Summing the Number of Hours an Employee Worked During a Two Week Period
Delete Tip from MyTips Summing Values from Cells in Different Sheets
Delete Tip from MyTips Simplifying complicated multiplication calculations using the SUMPRODUCT function
Delete Tip from MyTips Cell Function Returns Sheet Name, Workbook Name and Path
Delete Tip from MyTips Buscando/Buscando y Reemplazando en una Hoja o en Todas las Hojas
Delete Tip from MyTips Row and column background color using VBA in Microsoft Excel
Delete Tip from MyTips Summing Sales Amounts According to Product Category and Customer Name
Delete Tip from MyTips Array Formulas – the Technical Side
Delete Tip from MyTips Working Out a Person's Age in Microsoft Excel
Delete Tip from MyTips Retrieving from List by Position
Delete Tip from MyTips Opening Workbooks from a List of Hyperlinks in Excel 2007
Delete Tip from MyTips Creating New IP Addresses
Delete Tip from MyTips Selecting a Range of Non-Adjacent Cells
Delete Tip from MyTips Adding the Full Path of the Saved File to the Header/Footer
Delete Tip from MyTips Transposing Cells in Excel 2007
Delete Tip from MyTips Sort by birthday using VBA in Microsoft Excel
Delete Tip from MyTips Change a Column or Columns to values using VBA in Microsoft Excel
Delete Tip from MyTips Playing sound notes using VBA in Microsoft Excel
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips Adding Sub-Details to an Item
Delete Tip from MyTips Rounding numerical calculation results in Microsoft Excel
Delete Tip from MyTips Using a Workspace to Open a Number of Workbooks at Once
Delete Tip from MyTips Validating Data To Be Unique In A Range
Delete Tip from MyTips IFERROR Function - New Function in Excel 2007
Delete Tip from MyTips Build an Excel Add-In in Microsoft Excel
Delete Tip from MyTips Count the number of cells containing data in a range in Microsoft Excel
Delete Tip from MyTips Adding Additional PivotTable Reports Using the Same Data Source
Delete Tip from MyTips Separating Positive and Negative numbers and add Running Balance column
Delete Tip from MyTips Delete all macros in a workbook/document using VBA in Microsoft Excel
Delete Tip from MyTips Copying & Pasting Cell Content to Thousands of Cells
Delete Tip from MyTips Quickly Selecting a Range of Cells
Delete Tip from MyTips Control Word from Excel using VBA in Microsoft Excel
Delete Tip from MyTips How to extract a file name from a path in Microsoft Excel
Delete Tip from MyTips Automatically Refreshing a PivotTable Report in Excel 2007
Delete Tip from MyTips Copy a row or rows from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Cambiando el Número Predeterminado de Hojas en un Nuevo Libro
Delete Tip from MyTips List files in a folder with Office 97 or later using VBA in Microsoft Excel
Delete Tip from MyTips Delete all cells with today's date using VBA
Delete Tip from MyTips Playing WAV-files using VBA in Microsoft Excel
Delete Tip from MyTips Coloring Sheet Tabs in Excel 2007
Delete Tip from MyTips Problem: Date Formatting Cannot Be Changed
Delete Tip from MyTips Extending the Range of the SUM Formula
Delete Tip from MyTips Displaying the serial number behind Date format in Microsoft Excel
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Subtotal Ribbon in Excel 2007
Delete Tip from MyTips Counting Unique Numeric Values or Unique Data in a List
Delete Tip from MyTips Copiando el Formato
Delete Tip from MyTips Automatically Defining Names for Ranges in a List in Excel 2007
Delete Tip from MyTips Retrieve Value Using Case-Sensitive Lookups
Delete Tip from MyTips Add a cell, Row or a column in Microsoft Excel
Delete Tip from MyTips Add special symbols to the number format
Delete Tip from MyTips Retrieving the Closest Larger and Closest Smaller Values from a List When There Is No Exact Match
Delete Tip from MyTips Deleting the Word "Total" from the subtotal List
Delete Tip from MyTips Insert headers and footers using VBA in Microsoft Excel
Delete Tip from MyTips Mail one Sheet using VBA 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. 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