|  

» 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 Coloring Two Subtotal Levels in Different Colors
Delete Tip from MyTips Edit the tooltip for toolbarbuttons using VBA in Microsoft Excel
Delete Tip from MyTips Formatting Cells Containing Formulas
Delete Tip from MyTips Counting how many times specific character appears in cell in Microsoft Excel
Delete Tip from MyTips Moving Between Precedent and Dependent Cells
Delete Tip from MyTips Counting the Number of Cells Containing Text
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips The SUMIF Formula – Using Comparison Operators ( ) as Criteria
Delete Tip from MyTips Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
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 Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Retrieving the Most Frequent Occurrence for Each Category
Delete Tip from MyTips Seleccionando Celdas desde Cualquier Celda hasta la Última del Rango Utilizado de la Hoja
Delete Tip from MyTips Dual Monitors - Trouble Displaying separate spreadsheets on each Monitor
Delete Tip from MyTips Backing Up Customized Changes to Toolbars and Menus
Delete Tip from MyTips Calculating the Number of Business Days in a Specified Period
Delete Tip from MyTips Hiding Items
Delete Tip from MyTips Ranking Numbers in a Dynamic List
Delete Tip from MyTips Finding and Deleting Unwanted and Orphan Links in Excel 2007
Delete Tip from MyTips Autoexpanding a Date Type Chart using Microsoft Excel
Delete Tip from MyTips Drawing Lines Between Sorted Groups
Delete Tip from MyTips Look up unique values using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Standard Font
Delete Tip from MyTips Finding the Serial Number of the Last Day of the Month
Delete Tip from MyTips Retrieving the Column Header of the Next Non-Blank Cell in a Row
Delete Tip from MyTips Formulas to calculate Loan payments in Microsoft Excel
Delete Tip from MyTips Transposing a Range in Ascending Order
Delete Tip from MyTips Counting the Number of Values Between Upper and Lower Limits
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates Percentage Difference from the Previous Item
Delete Tip from MyTips Validating text entries in Microsoft Excel
Delete Tip from MyTips Preventing the Printing of Objects
Delete Tip from MyTips Calculating the Difference Between Hours
Delete Tip from MyTips Opening/Closing a Workbook(s) in Excel 2007
Delete Tip from MyTips Determine if a sheet exists in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Combined First and Last Names Matching Criteria in a Dynamic Range
Delete Tip from MyTips Moving to the Last (or First) Cell in a Range
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields
Delete Tip from MyTips Mail Sheet Array 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 Performing calculations based on multiple criteria, using SUMPRODUCT function
Delete Tip from MyTips Summing How Many Points Scored by a Specified Team in Specified Games
Delete Tip from MyTips Rules for Organizing the Source Data in Excel Sheets
Delete Tip from MyTips Pasting Values
Delete Tip from MyTips Retrieving the Column Header that Corresponds with a Matched Value
Delete Tip from MyTips Displaying the Serial Number Behind the Date
Delete Tip from MyTips Finding the First Login and Last Logout Times of Employees
Delete Tip from MyTips Quickly Printing a Page from the Workbook Using a Custom View
Delete Tip from MyTips Calculating Daily Pay, Incorporating Variable Hourly Rates
Delete Tip from MyTips Close a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Inserting a Watermark Behind the Text
Delete Tip from MyTips Creating a Summing Formula that Automatically Adjusts to a Dynamic Range
Delete Tip from MyTips Avoiding Errors when Counting Date Values that Meet Specified Criteria
Delete Tip from MyTips Control Excel from Word using VBA in Microsoft Excel
Delete Tip from MyTips Using the Keyboard to Select Chart Items in Microsoft Excel
Delete Tip from MyTips Calculating a Building's Occupancy Rate at Specified Times
Delete Tip from MyTips Calculating the Average for Numbers Meeting Specified Criteria
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Days, Months, Quarters, and Years
Delete Tip from MyTips Delete sheets without confirmation prompts using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Shortcut for Wrapping Text
Delete Tip from MyTips Creating Date and Time Stamp
Delete Tip from MyTips Prevent that an automacro/eventmacro executes using VBA in Microsoft Excel
Delete Tip from MyTips Make LEFT Function recognize a number
Delete Tip from MyTips Convert text to lower case in Microsoft Excel
Delete Tip from MyTips Class modules using VBA in Microsoft Excel
Delete Tip from MyTips Create a new module using VBA in Microsoft Excel
Delete Tip from MyTips Set background color depending on value verification using VBA in Microsoft Excel
Delete Tip from MyTips Converting a Number to a Time Value
Delete Tip from MyTips Changing the Font Size of the Sheet Name in Excel 2007
Delete Tip from MyTips Summing matching values in multiple rows
Delete Tip from MyTips Calculate a weeks start date using VBA in Microsoft Excel
Delete Tip from MyTips Calculate the count of workdays between two dates using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Sale Price Based On Item And Color Criteria
Delete Tip from MyTips Inserting/Editing Formulas
Delete Tip from MyTips Consolidating Lists
Delete Tip from MyTips Change the availability for the shortcut menus using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Values from another Sheet Using Date as Sheet Name Reference
Delete Tip from MyTips Find the minimum positive value in Microsoft Excel
Delete Tip from MyTips Creating New IP Addresses
Delete Tip from MyTips Selecting a Range of Non-Adjacent Cells
Delete Tip from MyTips Copying the Subtotals Summary
Delete Tip from MyTips Control Word from Excel using VBA in Microsoft Excel
Delete Tip from MyTips List files in a folder with Microsoft Scripting Runtime using VBA in Microsoft Excel
Delete Tip from MyTips Adding Subtotals to a Date Field
Delete Tip from MyTips Nesting Formulas
Delete Tip from MyTips Changing the Indentation in a Cell
Delete Tip from MyTips Convert negative values treated as text using VBA in Microsoft Excel
Delete Tip from MyTips Creating a Summary Table of a Student Questionnaire
Delete Tip from MyTips Copy cells from the ActiveCell Row to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Smallest Nth Value Match Within a List
Delete Tip from MyTips Access the Private module of a Worksheet Object while in Excel
Delete Tip from MyTips La Función Celda Devuelve el Nombre de la Hoja, Libro y Ruta
Delete Tip from MyTips Hiding the Display of Zero Values
Delete Tip from MyTips Coloring Numbers Based on Specific Criteria Using Conditional Formatting
Delete Tip from MyTips Redondeando Números a Millones con Miles como Decimal
Delete Tip from MyTips Search value in external workbook and paste with format style using VBA in Microsoft Excel
Delete Tip from MyTips Converting Time Values from One Time Zone to Another
Delete Tip from MyTips Retrieve Value Using Case-Sensitive Lookups
Delete Tip from MyTips Finding a substring within a string
Delete Tip from MyTips The Euro Currency Tools Add-In
Delete Tip from MyTips Printing a Chart in Microsoft Excel
Delete Tip from MyTips Add space between characters and numbers in Microsoft Excel
Delete Tip from MyTips Hiding/Unhiding a Row(s) or Column(s)
Delete Tip from MyTips Inserting Special Symbols into Custom Formats
Delete Tip from MyTips Expanded Paste Icon Features in Excel 2002 & Excel 2003
Delete Tip from MyTips Coloring Numbers Based on Specific Criteria
Delete Tip from MyTips Determine if a workbook exists using VBA in Microsoft Excel
Delete Tip from MyTips Grouping the Date Field by Number of Days in Excel 2007
Delete Tip from MyTips Delete module content using VBA in Microsoft Excel
Delete Tip from MyTips Return error values from user defined functions using VBA in Microsoft Excel
Delete Tip from MyTips Extract all the words except the first in Microsoft Excel
Delete Tip from MyTips Formatting a PivotTable Report
Delete Tip from MyTips Creating a custom Report Manager by writing a short VBA program in Microsoft Excel
Delete Tip from MyTips Splitting a Full Address into Three Separate Cells
Delete Tip from MyTips Counting the Number of Cells Containing Text
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Import data from Access to Excel (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Imprimiendo Comentarios de Celda
Delete Tip from MyTips Quickly Entering a Long Company or Person Name
Delete Tip from MyTips Return every n-th item using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Color Unique Record in a Range in Excel 2007
Delete Tip from MyTips Applying Formatting Only to Cells Containing Text
Delete Tip from MyTips Retrieving From List By Position
Delete Tip from MyTips Calculate holidays using VBA in Microsoft Excel
Delete Tip from MyTips Using a Picture to Watch Cell Values in Other Sheets
Delete Tip from MyTips Shortcuts for opening the Function Arguments window in Microsoft Excel
Delete Tip from MyTips Count the number of times dates in certain month appears in range in Microsoft Excel
Delete Tip from MyTips Adding the Subtotals Icon to the Menu Bar
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet in Excel 2007
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields in Excel 2007
Delete Tip from MyTips Copiando y Pegando el Contenido de una Celda en Miles de Celdas
Delete Tip from MyTips Show/Hide Grand Totals in Excel 2007
Delete Tip from MyTips Retrieving the Last Value and the Last Character in a Row
Delete Tip from MyTips Retrieve the Distance between Any Two Cities from Distance Table
Delete Tip from MyTips Extracting Characters from Text Without Using Formulas
Delete Tip from MyTips Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
Delete Tip from MyTips Summing Stock Lists in Excel 2007
Delete Tip from MyTips Replacing Zeros with Dashes in Number Formatting
Delete Tip from MyTips Using a Range Name in a Formula
Delete Tip from MyTips Selecting All Sheet Cells
Delete Tip from MyTips Combining Text and Formatted Values
Delete Tip from MyTips Move row into worksheet after entry of worksheet name into row using VBA in Microsoft Excel
Delete Tip from MyTips Searching for text in Microsoft Excel
Delete Tip from MyTips Retrieving the Cell Address of the Largest Value in a Range
Delete Tip from MyTips Execute Command/Sub-Procedure Using Timer in VBA
Delete Tip from MyTips Summing using multiple criteria in Microsoft Excel
Delete Tip from MyTips Calculating the Quarter Number
Delete Tip from MyTips Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007
Delete Tip from MyTips Formatting a Value Field in Excel 2007
Delete Tip from MyTips Extending the Range of the SUM Formula
Delete Tip from MyTips Avoiding the #VALUE! Error when Adding Cells that May Contain Blanks
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 Retrieving Unique Values from a List
Delete Tip from MyTips Adding a Custom Keyboard Shortcut
Delete Tip from MyTips Copy a column or columns from each workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Seleccionando Celdas en Rangos Horizontales o Verticales
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened
Delete Tip from MyTips Printing Non-Continuous Areas in Excel 2007
Delete Tip from MyTips Count how many numbers are in series of numbers when a certain criteria is set in Microsoft Excel
Delete Tip from MyTips Calculating Total Annual Payment Based on Cumulative Monthly Payments
Delete Tip from MyTips Use Name in a Formula in Excel 2007
Delete Tip from MyTips Mostrando el Cuadro de Diálogo de Formato de Celdas
Delete Tip from MyTips Cambiando el Número Predeterminado de Hojas en un Nuevo Libro
Delete Tip from MyTips Insert pictures using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime
Delete Tip from MyTips Create styles directly from cells in Microsoft Excel
Delete Tip from MyTips Summing Expenses Accumulated to a Specified Month
Delete Tip from MyTips Copying Formulas and Pasting Them in a Transposed Direction Without Changing the Relative References
Delete Tip from MyTips Cambiando el Estilo Predeterminado
Delete Tip from MyTips Creating a PivotTable Report in Excel 2007
Delete Tip from MyTips Sizing Charts with the Window in Microsoft Excel.
Delete Tip from MyTips E-mailing an Excel Workbook, Sheet, Data or Chart
Delete Tip from MyTips Watch Cell Information at a Distance
Delete Tip from MyTips Creating Charts with F11 in Microsoft Excel
Delete Tip from MyTips Preventing Text from Spilling Over
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 a Range of Numbers, Excluding the Minimal Value
Delete Tip from MyTips Adding the Properties Icon to the Standard Toolbar
Delete Tip from MyTips Multiplying time values and numbers.
Delete Tip from MyTips Printing Cell Comments in Excel 2007
Delete Tip from MyTips Negative times in Microsoft Excel
Delete Tip from MyTips Automatically Wrapping Text in a Cell
Delete Tip from MyTips Coloring Gridlines
Delete Tip from MyTips Using a Workspace to Open a Number of Workbooks at Once
Delete Tip from MyTips Show the full name ( path and workbook name ) in the menu bar in Microsoft Excel
Delete Tip from MyTips Create new workbooks using VBA in Microsoft Excel
Delete Tip from MyTips Summing Stock Lists
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates the Difference from the Previous Item
Delete Tip from MyTips Deleting the Word
Delete Tip from MyTips Add page breaks to sorted data using VBA in Microsoft Excel
Delete Tip from MyTips Countdown in status bar using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Number to a Formatted Time Value
Delete Tip from MyTips Validando Datos de Texto
Delete Tip from MyTips Array Formulas – the Technical Side
Delete Tip from MyTips Summing the Number of Hours an Employee Worked During a Two Week Period
Delete Tip from MyTips Retrieving Matching Values From Not Adjacent List
Delete Tip from MyTips Avoiding the Occurrence of Unexpected VLOOKUP #N/A Errors
Delete Tip from MyTips Rounding Numbers to Thousands
Delete Tip from MyTips Insertando Símbolos Especiales en Formatos Personalizados
Delete Tip from MyTips Creating a World Time Converter
Delete Tip from MyTips Counting the Number of Values Below or Above Average
Delete Tip from MyTips Summing a range containing errors and values in Microsoft Excel
Delete Tip from MyTips Selecting the Current Region/List
Delete Tip from MyTips Selecting/Formatting Cells Containing Errors
Delete Tip from MyTips Los Iconos Desaparecen de la Barra de Herramientas
Delete Tip from MyTips Saving a Customized Workbook as a Template in Excel 2007
Delete Tip from MyTips Using the Round Function to Round Numbers to Thousands
Delete Tip from MyTips Dividing a First Left Heading Title in Excel 2007
Delete Tip from MyTips Calculating the Lowest Common Multiple (LCM)
Delete Tip from MyTips Creating Progressively Incremented Counting Criteria
Delete Tip from MyTips Sort Ribbon in Excel 2007
Delete Tip from MyTips Copy cells to all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips PivotTable Report Terminology
Delete Tip from MyTips Creating List Objects
Delete Tip from MyTips Replacing Substrings with Numbers from Adjacent Cells
Delete Tip from MyTips Cambiando la Forma de un Comentario de Celda
Delete Tip from MyTips Count the number of cells in a range 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