|  

» 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 Log files using VBA in Microsoft Excel
Delete Tip from MyTips Compare two worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Refreshing a PivotTable Report
Delete Tip from MyTips Comparing Lists Using the COUNTIF Formula
Delete Tip from MyTips Create styles directly from cells in Microsoft Excel
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 Adding the Custom Views Icon to the Excel Menu Bar
Delete Tip from MyTips Breaking Links Between Workbooks
Delete Tip from MyTips Row and column background color using VBA in Microsoft Excel
Delete Tip from MyTips Opening a saved Workbook in Microsoft Excel
Delete Tip from MyTips Index Formula vs. Vlookup Formula
Delete Tip from MyTips Adding the Properties Icon to the Standard Toolbar
Delete Tip from MyTips Copying Styles from One Workbook to Another
Delete Tip from MyTips Formulas to calculate Loan payments in Microsoft Excel
Delete Tip from MyTips Find duplicates items in combine columns in Microsoft Excel
Delete Tip from MyTips Checking If Matching Numbers Exist in Different Ranges
Delete Tip from MyTips Adding Passwords to Prevent Unauthorized Opening of a Workbook in Excel 2007
Delete Tip from MyTips Using Different Functions to Consolidate Lists
Delete Tip from MyTips Calculating Differences Between Dates
Delete Tip from MyTips Time intervals using VBA in Microsoft Excel
Delete Tip from MyTips Insert or delete a Row/Column in Microsoft Excel
Delete Tip from MyTips Adjust row height of merged cells using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values from Two Ranges, Based on Two Criteria
Delete Tip from MyTips PivotTable report - Adding a Calculated Field
Delete Tip from MyTips Validating Date Entries
Delete Tip from MyTips Counting the Number of Times Any of the Numbers in First List Appears within Second List
Delete Tip from MyTips Summing Sales Quantities and Amounts for Several Lists, or Presenting the Figures Side-by-Side
Delete Tip from MyTips Cell protection only for formulas using VBA in Microsoft Excel
Delete Tip from MyTips Borrando Todos los Comentarios de Celda en una Hoja
Delete Tip from MyTips Performing calculations based on multiple criteria, using SUMPRODUCT function
Delete Tip from MyTips Using the COUNT Functions
Delete Tip from MyTips Comparing Lists
Delete Tip from MyTips Adding a Number to a Formatted Time Value
Delete Tip from MyTips Creating Date and Time Stamp
Delete Tip from MyTips Fast Typing in Selected Area
Delete Tip from MyTips Watch Cell Information at a Distance
Delete Tip from MyTips Filling a Range with a Series of Dates
Delete Tip from MyTips Playing WAV-files using VBA in Microsoft Excel
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields
Delete Tip from MyTips Conditional formatting depending on a cell comment using VBA in Microsoft Excel
Delete Tip from MyTips Create eventmacros for the Application object using VBA in Microsoft Excel
Delete Tip from MyTips Saving Defined Page Setups for Future Printing
Delete Tip from MyTips Select filenames using VBA in Microsoft Excel
Delete Tip from MyTips Printing an Already Saved Report Using Report Manager
Delete Tip from MyTips Rounding numerical calculation results in Microsoft Excel
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2000
Delete Tip from MyTips Filtering by the Date Field
Delete Tip from MyTips Quickly Printing a Page from the Workbook Using a Custom View
Delete Tip from MyTips Viendo Datos Seleccionados en una Hoja
Delete Tip from MyTips Quickly Printing a Page from the Workbook Using a Custom View
Delete Tip from MyTips Create an Amortization Schedule in Microsoft Excel
Delete Tip from MyTips Symbols Used to Create Custom Formatting
Delete Tip from MyTips Filtering is limited to 999 items in Microsoft Excel
Delete Tip from MyTips Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range
Delete Tip from MyTips Calculating the Difference Between Hours
Delete Tip from MyTips Summing using multiple criteria in Microsoft Excel
Delete Tip from MyTips Adding a Running Balance Calculation Column
Delete Tip from MyTips Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
Delete Tip from MyTips Adding/Deleting Subtotals
Delete Tip from MyTips Opening a Linked Workbook in Microsoft Excel
Delete Tip from MyTips Counting Based on Multiple Criteria
Delete Tip from MyTips Quickly Selecting a Range in the Workbook
Delete Tip from MyTips Function for returning the user name using VBA in Microsoft Excel
Delete Tip from MyTips Grouping the Date Field by Number of Days
Delete Tip from MyTips Selecting Cells in Horizontal or Vertical Ranges
Delete Tip from MyTips Inserting a picture (company logo) in the header in Microsoft Excel 2002 xp
Delete Tip from MyTips Reset filter before saving a worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Count the number of cells in a range containing all types of Errors in Microsoft Excel
Delete Tip from MyTips Calculating the Remaining Credit after Each Purchase
Delete Tip from MyTips Cambiar el Formato de la Celda de Fecha a Número
Delete Tip from MyTips Counting the Number of Values Meeting Criteria, but Only for Every 3rd Cell in a Range
Delete Tip from MyTips Grouping/Ungrouping Sheets in Excel 2007
Delete Tip from MyTips Using the Macro Recorder in Microsoft Excel
Delete Tip from MyTips Sum Total Sales Except for One Specified Item
Delete Tip from MyTips Display message if column total is exceeded using VBA in Microsoft Excel
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips Use the continuous page numbers technique in Report Manager in Microsoft Excel.
Delete Tip from MyTips Sort Ascending/Descending While Using AutoFilter
Delete Tip from MyTips Copiando/Moviendo una Celda (o Celdas) entre Hojas/Libros de Trabajo
Delete Tip from MyTips Add space between characters and numbers in Microsoft Excel
Delete Tip from MyTips Adding Data, Charts, or Other Information to a Cell Comment
Delete Tip from MyTips Retrieving the Minimal / Maximal Values from a Filtered List
Delete Tip from MyTips Copy a Range from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Selecting a row or rows in Microsoft Excel
Delete Tip from MyTips Deleting Empty Rows
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates the Difference Between Two Data Fields
Delete Tip from MyTips Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
Delete Tip from MyTips Printing Non-Continuous Areas in Excel 2007
Delete Tip from MyTips Table Sorting Rules in Excel 2007
Delete Tip from MyTips Pasting Values
Delete Tip from MyTips Summing the N Largest Values in a Range
Delete Tip from MyTips Find if a character is in a cell in Microsoft Excel
Delete Tip from MyTips Count the number of cells containing data in a range in Microsoft Excel
Delete Tip from MyTips Creating New IP Addresses
Delete Tip from MyTips Execute Command/Sub-Procedure Using Timer in VBA
Delete Tip from MyTips Display all installed fonts (Excel) using VBA in Microsoft Excel
Delete Tip from MyTips Calculating Daily Pay, Incorporating Variable Hourly Rates
Delete Tip from MyTips Checking For Sequences Within A Sorted List
Delete Tip from MyTips Finding the maximum value of all those meeting a certain criteria.
Delete Tip from MyTips Sorting Numbers Based on Their Frequency within a List
Delete Tip from MyTips Moviéndose entre Celdas no Protegidas en una Hoja Protegida
Delete Tip from MyTips Creating Subtotals Summary in Excel 2007
Delete Tip from MyTips Opening Workbooks from a List of Hyperlinks
Delete Tip from MyTips Printing a Custom View in Excel 2007
Delete Tip from MyTips Summing Annual Expenses by Respective Quarters
Delete Tip from MyTips Count the number of times dates in certain month appears in range in Microsoft Excel
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 Changing the Number Formatting in Excel 2007
Delete Tip from MyTips Display AutoFilter criteria after filtering using VBA in Microsoft Excel
Delete Tip from MyTips Copying or Applying Color to Groups and Outlines
Delete Tip from MyTips Find the maximum numerical value in a list based on a criteria in Microsoft Excel
Delete Tip from MyTips Determining whether Two Given Dates Occur within the Same Week
Delete Tip from MyTips Splitting a Full Address into Three Separate Cells
Delete Tip from MyTips Coloring Rows Based on Text Criteria
Delete Tip from MyTips Preventing Moving to the Next Cell After Typing
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 Copy a range of each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips The Euro Currency Tools Add-In
Delete Tip from MyTips Calculating the Proportion of Characters from One String that Appears in another String
Delete Tip from MyTips Separating First and Last Names
Delete Tip from MyTips List and add the days of months in a set period using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Defining Names for Ranges in a List in Excel 2007
Delete Tip from MyTips Rounding a Value to Make It Divisible by a Specified Number
Delete Tip from MyTips Retrieving the Cell Address of the Largest Value in a Range
Delete Tip from MyTips Converting Text to Uppercase
Delete Tip from MyTips Retrieving the Price for a Specified Item and a Specified Brand
Delete Tip from MyTips Using VLOOKUP and ISNA functions to find matching values in different sheets
Delete Tip from MyTips Copying the Page Setup to Other Sheets
Delete Tip from MyTips Print all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Shortcut for Wrapping Text
Delete Tip from MyTips Summing Values in a Range Containing Redundant Spaces
Delete Tip from MyTips Mail every Worksheet with address in cell A1 using VBA in Microsoft Excel
Delete Tip from MyTips Ocultando la Visualización de los Valores Cero
Delete Tip from MyTips Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel
Delete Tip from MyTips Finding Every Third Number and Returning the Largest of Them
Delete Tip from MyTips Create a Custom Function
Delete Tip from MyTips Vlookup Formula – Eliminating Errors
Delete Tip from MyTips Calculating the Date at the End of a Month
Delete Tip from MyTips Quickly Creating Links between Workbooks in Excel 2007
Delete Tip from MyTips Selecting a sheet from shortcut menu in Microsoft Excel
Delete Tip from MyTips Summing Values Using Indirect Cell References
Delete Tip from MyTips Add unique values using VBA in Microsoft Excel
Delete Tip from MyTips Protecting Data by Hiding a Row(s) and a Column(s) in Excel 2007
Delete Tip from MyTips Displaying Formulas and Values of the Same Cells
Delete Tip from MyTips Summing Groups of Every N Values in a Row
Delete Tip from MyTips Creating, and using a Visual Basic Combo/ Edit box
Delete Tip from MyTips Selecting a Range of Non-Adjacent Cells
Delete Tip from MyTips Color Unique Record in a Range in Excel 2007
Delete Tip from MyTips Counting the Number of Items Sold Every Half Hour
Delete Tip from MyTips Checking For Duplicate Values Within A Range
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 Counting the Number of Unique Items Sold by Each Salesperson
Delete Tip from MyTips Hiding Subtotal Level Buttons
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Agregando un Método Abreviado para Ajuste de Texto
Delete Tip from MyTips Calculate commission percentage based on a commission schedule in Microsoft Excel
Delete Tip from MyTips Preventing Duplicates While Entering Data
Delete Tip from MyTips Get the value of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Counting the Number of Cells Containing Text in a Range
Delete Tip from MyTips Inserting a Chart in Excel 2007
Delete Tip from MyTips Workbook events using VBA in Microsoft Excel
Delete Tip from MyTips Using the Validation Input Message as a Cell Comment
Delete Tip from MyTips Adding Additional PivotTable Reports Using the Same Data Source
Delete Tip from MyTips Counting number of unique entries in a specified range.
Delete Tip from MyTips Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells
Delete Tip from MyTips Protecting the Sheet or the Cells in the Sheet
Delete Tip from MyTips Setting the Number of Fields Displayed in the Page Layout
Delete Tip from MyTips Identifying Numeric Values within a Range Formatted as Text
Delete Tip from MyTips Handling Errors in Values & Empty cells in Excel 2007
Delete Tip from MyTips Array Formulas – the Technical Side
Delete Tip from MyTips Hiding Items
Delete Tip from MyTips Displaying the serial number behind Date format in Microsoft Excel
Delete Tip from MyTips Vlookup Formula – Organizing the Data Table
Delete Tip from MyTips Copiando y Pegando Rápido a la Derecha o Debajo en una Lista
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Sorting by Columns
Delete Tip from MyTips Calculating the Quarter Number
Delete Tip from MyTips Fast Copying & Pasting Right or Down in a List
Delete Tip from MyTips Counting the Number of Values between Two Specified Values in a List
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 Password to prevent opening a workbook in Microsoft Excel
Delete Tip from MyTips Defining a Range Name
Delete Tip from MyTips Retrieving Values from a List that are Greater than a Specified Number
Delete Tip from MyTips Move row into worksheet after entry of worksheet name into row using VBA in Microsoft Excel
Delete Tip from MyTips Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
Delete Tip from MyTips Insert pictures using VBA in Microsoft Excel
Delete Tip from MyTips Avoiding Errors When Subtracting Times
Delete Tip from MyTips Retrieving the Last Value in a Dynamic List
Delete Tip from MyTips Ajustando Manualmente el Texto en una Celda
Delete Tip from MyTips Inserting Special Symbols into Custom Formats
Delete Tip from MyTips Seperating Website Name or URL from Text
Delete Tip from MyTips Reducing the Used Area in a Sheet
Delete Tip from MyTips Automatically Updating a Range Name Reference in Excel 2007
Delete Tip from MyTips Finding the Serial Number of the Last Day of the Month
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 Replacing Zeros with Dashes in Number Formatting
Delete Tip from MyTips Rounding Prices to the Nearest Nickel, Dime, Quarter and Dollar
Delete Tip from MyTips Seleccionando un Rango de Celdas No Adyacentes
Delete Tip from MyTips Use AutoCorrect to enter special symbols in Microsoft Excel
Delete Tip from MyTips Dividing a First Left Heading Title
Delete Tip from MyTips Sort by birthday using VBA in Microsoft Excel
Delete Tip from MyTips Hide/Unhide a Sheet in Excel 2007
Delete Tip from MyTips Summing the Visible Filtered List Values in Excel 2007
Delete Tip from MyTips Sum the largest two numbers in range in Microsoft Excel
Delete Tip from MyTips Turn off warning messages using VBA in Microsoft Excel
Delete Tip from MyTips Validando Datos Numéricos
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 Using Task Panes
Delete Tip from MyTips Replace text in a text file using VBA in Microsoft Excel
Delete Tip from MyTips Converting Time to Decimal Values
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Validating Number Entries in Excel 2007
Delete Tip from MyTips Change font color based on Date using VBA in Microsoft Excel
Delete Tip from MyTips Copy a column or columns from each sheet into 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