|  

» 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 E-mailing an Excel Workbook, Sheet, Data or Chart
Delete Tip from MyTips Displaying Formula Syntax
Delete Tip from MyTips Userdefined functions from other workbooks using VBA in Microsoft Excel
Delete Tip from MyTips Quickly Selecting a Range in the Workbook
Delete Tip from MyTips Additional Functions in AutoSum
Delete Tip from MyTips Worksheet events using VBA in Microsoft Excel
Delete Tip from MyTips How Excel Sorts Lists
Delete Tip from MyTips Creating a Dynamic Inventory List Based on Daily Sales
Delete Tip from MyTips Opening a Linked Workbook in Microsoft Excel
Delete Tip from MyTips Creating a Custom Report Manager
Delete Tip from MyTips The Power Combination
Delete Tip from MyTips Adding the Page Setup Icon to the Excel Menu Bar
Delete Tip from MyTips Adding Additional PivotTable Reports Using the Same Data Source
Delete Tip from MyTips Changing the font size of the Sheet name in Microsoft Excel
Delete Tip from MyTips Insert or delete a Row/Column in Microsoft Excel
Delete Tip from MyTips PivotTable Report Terminology
Delete Tip from MyTips Whats New in Excel 2007
Delete Tip from MyTips Converting a Month's Serial Number into Its Corresponding Name
Delete Tip from MyTips Allowing Multiple Users to Edit Ranges in Microsoft Excel
Delete Tip from MyTips Coloring Based on Text Criteria in Excel 2007
Delete Tip from MyTips Returning the Entire Contents of the Row Containing the Highest Math Grade
Delete Tip from MyTips Fast Summation in Excel 2007
Delete Tip from MyTips Limiting the Movement in a Protected Sheet
Delete Tip from MyTips Retrieving a Price Value By Looking at Two Difference Data Tables
Delete Tip from MyTips Protecting Cells in the Sheet in Excel 2007
Delete Tip from MyTips Counting Rows that Match Specific Criteria for Each Column
Delete Tip from MyTips Counting the Number of Players According to Their Score in a Particular Quarter
Delete Tip from MyTips Copy Selection to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Filtering by the Date Field
Delete Tip from MyTips Playing MIDI-files 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 Changing the Default Date Separator from a Slash to a Dot When Entering a Date into a Cell
Delete Tip from MyTips Calculating an Average, Only Including Prices on Which There Was no Discount
Delete Tip from MyTips Extract the first, middle and last name in Microsoft Excel
Delete Tip from MyTips Summing Total Sales, Based on Quantity & Price
Delete Tip from MyTips Creating New IP Addresses
Delete Tip from MyTips Summing Groups of Every N Values in a Row
Delete Tip from MyTips Restricting Cell Entries to Text Only
Delete Tip from MyTips Display a message on the statusbar using VBA in Microsoft Excel
Delete Tip from MyTips Ocultando las Líneas de División en el Monitor y al Imprimir
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Sorting by Cell Color, Font Color or Cell Icon in Excel 2007
Delete Tip from MyTips Backing Up Customized Changes to Toolbars and Menus
Delete Tip from MyTips Insert a new module from a file using VBA in Microsoft Excel
Delete Tip from MyTips Find the Alphabetically Lowest Letter in a List
Delete Tip from MyTips Checking for Sequences within a Sorted List
Delete Tip from MyTips Summing the Values of Cells Occurring at the Intersection of Ranges
Delete Tip from MyTips Get the Row number of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Change a Column or Columns to values using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of YES Responses in a Student Questionnaire
Delete Tip from MyTips Retrieving Values from another Excel Workbook Using Text References
Delete Tip from MyTips Moving Between Open Workbooks
Delete Tip from MyTips Prevent that an automacro/eventmacro executes using VBA in Microsoft Excel
Delete Tip from MyTips Creating and Saving Custom Styles
Delete Tip from MyTips Seleccionando Rápidamente un Rango de Celdas
Delete Tip from MyTips Hiding Outline Symbols
Delete Tip from MyTips Print the pages in reverse order using VBA in Microsoft Excel
Delete Tip from MyTips Control Excel from Word using VBA in Microsoft Excel
Delete Tip from MyTips Save a workbook backup using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Minimal / Maximal Values from a Filtered List
Delete Tip from MyTips Retrieving the Most Frequent Occurrence for Each Category
Delete Tip from MyTips Inserting Page Numbers in Excel 2007
Delete Tip from MyTips Copying a Formula from a Cell While Keeping the Absolute Reference or Relative Reference
Delete Tip from MyTips Avoiding Errors when Subtracting Times
Delete Tip from MyTips Protegiendo Datos Ocultando una Fila(s) y Columna(s)
Delete Tip from MyTips Opening/Closing a Workbook(s)
Delete Tip from MyTips The Euro Currency Tools Add-In
Delete Tip from MyTips Protecting Cells Containing Formulas in a Protected Sheet
Delete Tip from MyTips Retrieve the Distance between Any Two Cities from Distance Table
Delete Tip from MyTips Private Profile Strings using Words System.PrivateProfileString using VBA in Microsoft Excel
Delete Tip from MyTips Hiding the Display of Zero Values
Delete Tip from MyTips Copying, Cutting and Pasting (Moving)
Delete Tip from MyTips Add values from the previous or next worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Vinculando una Celda a un Cuadro de Texto
Delete Tip from MyTips Replacing Zeros with Dashes in Number Formatting
Delete Tip from MyTips Finding the Relative Position of Numbers within a String
Delete Tip from MyTips Replace text in a text file using VBA in Microsoft Excel
Delete Tip from MyTips Selecting Special Cells
Delete Tip from MyTips Calculate Average Speed in Microsoft Excel
Delete Tip from MyTips Copiando y Pegando Rápido en Celdas Adyacentes
Delete Tip from MyTips Defer an Automatically Update of PivotTable Layout Report in Excel 2007
Delete Tip from MyTips Sorting Sheets in Ascending Order
Delete Tip from MyTips Validating Text Entries in Excel 2007
Delete Tip from MyTips Rounding Prices to the Nearest Nickel, Dime, Quarter and Dollar
Delete Tip from MyTips Selecting Cells That Contain Errors in Formulas in Excel 2007
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Converting a Number to a Time Value
Delete Tip from MyTips How to Use Your Excel Add-In Functions in VBA
Delete Tip from MyTips How to change column number with letter in Microsoft Excel
Delete Tip from MyTips Generate a random value between two limits in Microsoft Excel
Delete Tip from MyTips Selecting All Sheet Cells
Delete Tip from MyTips Mail the Activeworkbook using VBA in Microsoft Excel
Delete Tip from MyTips Copy a Column or Columns to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values Using Indirect Cell References
Delete Tip from MyTips Validation list without empty cells using VBA in Microsoft Excel
Delete Tip from MyTips Summing Across Multiple Sheets
Delete Tip from MyTips Comparing Three or More Lists in Microsoft Excel
Delete Tip from MyTips Using the COUNT Functions
Delete Tip from MyTips COUNT Formulas
Delete Tip from MyTips Counting number of unique entries in a specified range.
Delete Tip from MyTips Excluding Exceptional Values when Calculating an Average
Delete Tip from MyTips Protecting Cells Containing Formulas in an Unprotected Sheet
Delete Tip from MyTips Using Loops in VBA in Microsoft Excel
Delete Tip from MyTips Turn off warning messages using VBA in Microsoft Excel
Delete Tip from MyTips Change the cell formatted from date format to number format in Microsoft Excel
Delete Tip from MyTips Customizing an Icon
Delete Tip from MyTips Changing the Font Size of the Sheet Name
Delete Tip from MyTips Summing Monthly Trial Balance Figures
Delete Tip from MyTips Finding Every Third Number and Returning the Largest of Them
Delete Tip from MyTips Adding Sub-Details to an Item
Delete Tip from MyTips Ignoring Blank Cells when Performing Calculations
Delete Tip from MyTips Copying and Pasting Validation list only in Microsoft Excel
Delete Tip from MyTips PDF2XL Enterprise
Delete Tip from MyTips Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007
Delete Tip from MyTips Use AutoCorrect to enter special symbols in Microsoft Excel
Delete Tip from MyTips Adding the Path Address to the Header/Footer
Delete Tip from MyTips Summing Sales Quantities and Amounts for Several Lists, or Presenting the Figures Side-by-Side
Delete Tip from MyTips Import data from Access to Excel (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving a value from a reference grid according to index values
Delete Tip from MyTips Retrieving the Last Value and the Last Character in a Row
Delete Tip from MyTips Applying Colors to Subtotal Rows in Excel 2007
Delete Tip from MyTips Count the number of cells in a range in Microsoft Excel
Delete Tip from MyTips Use VLOOKUP Function as an alternative to a number of nested IF functions.
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 Retrieving the Entire Row of a Matched Value
Delete Tip from MyTips Counting how many times specific character appears in cell in Microsoft Excel
Delete Tip from MyTips Moving to the Last (or First) Cell in a Range
Delete Tip from MyTips Playing sound notes using VBA in Microsoft Excel
Delete Tip from MyTips Counting Unique "X" and "O" Occurrences in a Matrix
Delete Tip from MyTips Display Direction in Excel 2007
Delete Tip from MyTips Display all installed fonts (Word) using VBA in Microsoft Excel
Delete Tip from MyTips Show/Hide Expand Items Buttons in Excel 2007
Delete Tip from MyTips Rounding Numbers that Meet Specified Criteria
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 Sorting by Columns
Delete Tip from MyTips Set the Ruler Units in Excel 2007
Delete Tip from MyTips Formulas to calculate Loan payments 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 Copying the Subtotals Summary
Delete Tip from MyTips Rounding Up / Down to the Nearest Multiple of a Specific Number
Delete Tip from MyTips The Best Shortcut Keys in Microsoft Excel
Delete Tip from MyTips Insert pictures using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Nth Value in a Row / Column
Delete Tip from MyTips Add a cell, Row or a column in Microsoft Excel
Delete Tip from MyTips Summing Values from Different Sheets for the Same Cell Address
Delete Tip from MyTips Refreshing the Data in PivotTable Report while Opening a Workbook in Excel 2007
Delete Tip from MyTips Replacing Data Markers with Pictures in Microsoft Excel
Delete Tip from MyTips Removing Personal Information from a Workbook in Excel 2007
Delete Tip from MyTips Joining text using formula in Microsoft Excel
Delete Tip from MyTips AVERAGEIFS, SUMIFS and COUNTIFS Functions New functions in Excel 2007
Delete Tip from MyTips Displaying Numbers in Thousands in a Chart in Microsoft Excel
Delete Tip from MyTips Counting the Number of Times a Substring Appears Within a String
Delete Tip from MyTips Converting Text Representing Minutes and Seconds into Numerical Values
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Extract the last word in a cell in Microsoft Excel
Delete Tip from MyTips Deleting a Range Name
Delete Tip from MyTips Comparing Lists Using the COUNTIF Formula
Delete Tip from MyTips Summing values in vertical and horizontal ranges in Microsoft Excel
Delete Tip from MyTips Counting Date Values by Specified Date Criteria
Delete Tip from MyTips Deje que Excel lea el texto por usted
Delete Tip from MyTips Validating text entries in Microsoft Excel
Delete Tip from MyTips Replacing Substrings with Numbers from Adjacent Cells
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
Delete Tip from MyTips Using VLOOKUP and ISNA functions to find matching values in different sheets
Delete Tip from MyTips Adding Continuous Page Numbers While Printing
Delete Tip from MyTips Quick Filtering Using the AutoFilter Icon
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2000
Delete Tip from MyTips Inserting a picture (company logo) in Microsoft Excel 97 and 2000
Delete Tip from MyTips Restore the position in the window using VBA in Microsoft Excel
Delete Tip from MyTips Rounding Times Down to a Specified Time Increment
Delete Tip from MyTips Create new workbooks using VBA in Microsoft Excel
Delete Tip from MyTips Summing Expenses Accumulated to a Specified Month
Delete Tip from MyTips Change the state of a custom CommandBar button using VBA in Microsoft Excel
Delete Tip from MyTips Copying Styles from One Workbook to Another in Excel 2007
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Sum total stock value for any part in Microsoft Excel
Delete Tip from MyTips Deleting the Word
Delete Tip from MyTips Count the number of values between a lower and upper limit in Microsoft Excel
Delete Tip from MyTips Adding Subtotals to a Date Field
Delete Tip from MyTips Create and Add a Function for Reversed Text Characters 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