|  

» 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 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 Moving Between Open Workbooks
Delete Tip from MyTips Adding Additional Functions to Subtotals
Delete Tip from MyTips Identifying the Case of Letters within Strings
Delete Tip from MyTips Delete rows with blank cells in a certain column using VBA in Microsoft Excel
Delete Tip from MyTips Combining Text from Different Cells
Delete Tip from MyTips Eliminate screen flashing while running a macro using VBA in in Microsoft Excel
Delete Tip from MyTips Determining Which Quarter a Specified Date Corresponds With
Delete Tip from MyTips Find the minimum numerical value in a list based on a criteria in Microsoft Excel
Delete Tip from MyTips Summing Subtotals Only from Range
Delete Tip from MyTips Transposing a Range in Ascending Order
Delete Tip from MyTips Summing the Number of Hours an Employee Worked During a Two Week Period
Delete Tip from MyTips What's New in Excel 2003
Delete Tip from MyTips Summing How Many Points Scored by a Specified Team in Specified Games
Delete Tip from MyTips Hiding the Display of Zero Values in Excel 2007
Delete Tip from MyTips Retrieving Every Nth Value in a Range
Delete Tip from MyTips Find if a character is in a range in Microsoft Excel
Delete Tip from MyTips Changing the font size of the Sheet name in Microsoft Excel
Delete Tip from MyTips Using Different Functions to Consolidate Lists
Delete Tip from MyTips Generate total for dynamic area using VBA in Microsoft Excel
Delete Tip from MyTips Set the Ruler Units in Excel 2007
Delete Tip from MyTips Preventing Duplicates While Entering Data
Delete Tip from MyTips Changing the Default Style
Delete Tip from MyTips Sorting Sheets in Ascending Order
Delete Tip from MyTips Copy a Column or Columns to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Reducing the Used Area in a Sheet
Delete Tip from MyTips Replace value from validation list with a number using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Updating a Range Name Reference
Delete Tip from MyTips Conditonal Formatting using Microsoft Excel VBA
Delete Tip from MyTips Nesting Formulas
Delete Tip from MyTips Add a fancy line for Presentation
Delete Tip from MyTips Create an Amortization Schedule in Microsoft Excel
Delete Tip from MyTips Find the address of the max value in range in Microsoft Excel
Delete Tip from MyTips Dividing an Amount into Equal Payments While Avoiding Division / Rounding Errors
Delete Tip from MyTips Fast Typing in Selected Area
Delete Tip from MyTips Unintentionally Creating Links Between Workbooks
Delete Tip from MyTips Square root and cube root in Microsoft Excel
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Coloreando un Registro en Cada Grupo en un Rango
Delete Tip from MyTips Formulas to calculate Loan payments in Microsoft Excel
Delete Tip from MyTips Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
Delete Tip from MyTips Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
Delete Tip from MyTips Access ThisWorkbook module directly from Excel
Delete Tip from MyTips Replace text in a text file using VBA in Microsoft Excel
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Performing calculations based on multiple criteria, using SUMPRODUCT function
Delete Tip from MyTips Entering the Current Time into a Cell
Delete Tip from MyTips Ocultando/Desocultando una Fila(s) o Columna(s)
Delete Tip from MyTips Summing Expenses Accumulated to a Specified Month
Delete Tip from MyTips Qué hay de Nuevo en Excel 2002/2003: Menú, menú contextual de celdas y nuevos métodos abreviados
Delete Tip from MyTips Calculate Average Speed in Microsoft Excel
Delete Tip from MyTips Count the number of values between a lower and upper limit in Microsoft Excel
Delete Tip from MyTips Ignoring Blank Cells when Performing Calculations
Delete Tip from MyTips Defining a Range Name
Delete Tip from MyTips Protecting Data by Hiding a Row(s) and a Column(s) in Excel 2007
Delete Tip from MyTips Summing Sales Amounts According to Product Category and Customer Name
Delete Tip from MyTips Counting the Number of Values Between Upper and Lower Limits
Delete Tip from MyTips Change font color based on Date using VBA in Microsoft Excel
Delete Tip from MyTips Performing a Quick Calculation in the Formula Bar
Delete Tip from MyTips Sum the largest two numbers in range in Microsoft Excel
Delete Tip from MyTips Customizing Date Formatting in Excel 2007
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Determine the type of operating system using VBA in Microsoft Excel
Delete Tip from MyTips Export data from Excel to Access (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Calculate a weeks start date using VBA in Microsoft Excel
Delete Tip from MyTips Adding the Page Setup Icon to the Excel Menu Bar
Delete Tip from MyTips Moving to the Last (or First) Cell in a Range
Delete Tip from MyTips Select a Style in Excel 2007
Delete Tip from MyTips Validating Date Entries
Delete Tip from MyTips Counting how many times specific character appears in cell in Microsoft Excel
Delete Tip from MyTips Converting a Number to a Time Value
Delete Tip from MyTips Rounding Numerical Substrings
Delete Tip from MyTips Fast Summation
Delete Tip from MyTips Protegiendo Datos Ocultando una Fila(s) y Columna(s)
Delete Tip from MyTips Problem: Unnecessary Empty Characters in Cells
Delete Tip from MyTips Sum Total Sales Except for One Specified Item
Delete Tip from MyTips Breaking Links between Workbooks in Excel 2007
Delete Tip from MyTips Displaying Figures in Financial Reports Rounded to Thousands
Delete Tip from MyTips Usando la Validación de Mensaje Entrante como un Comentario de Celda
Delete Tip from MyTips Creating a custom Report Manager by writing a short VBA program 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 Protecting a Workbook in Excel 2007
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Delete all cells with today's date using VBA
Delete Tip from MyTips Retrieving a Value from a PivotTable Report in Excel 2007
Delete Tip from MyTips Agregando y Guardando una Nueva Barra de Herramientas Personalizada
Delete Tip from MyTips Dividing a First Left Heading Title in Excel 2007
Delete Tip from MyTips Summing Rounded Numbers
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 Dando Formato a un Número Negativo con Paréntesis
Delete Tip from MyTips Pasting Values
Delete Tip from MyTips Retrieving a Specific Cell from Multiple Sheets
Delete Tip from MyTips Formulas Erroneously Appearing as Text
Delete Tip from MyTips Breaking Links Between Workbooks
Delete Tip from MyTips Determine which CommandBar button that started a macro using VBA in Microsoft Excel
Delete Tip from MyTips Extract the first, middle and last name in Microsoft Excel
Delete Tip from MyTips Applying Colors to Top/Bottom Values in a List in Excel 2007
Delete Tip from MyTips Change the selection with one or more areas to Values using VBA in Microsoft Excel
Delete Tip from MyTips Deleting a Range Name
Delete Tip from MyTips Fast Copying & Pasting in Adjacent Cells
Delete Tip from MyTips Retrieving the Price for a Specified Item and a Specified Brand
Delete Tip from MyTips Create an addin in Excel 97, 2000, 2002 using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Column Header of the Next Non-Blank Cell in a Row
Delete Tip from MyTips Imprimiendo Comentarios de Celda
Delete Tip from MyTips Rounding Numbers to Thousands
Delete Tip from MyTips Retrieving Unique Values from a List
Delete Tip from MyTips Coloring Even Numbered Rows in a List
Delete Tip from MyTips Transposing Cells
Delete Tip from MyTips Copying, Cutting and Pasting (Moving)
Delete Tip from MyTips Utilizando el Espacio Vacío de la Barra de Menús con el agregado de Iconos Útiles
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Font Size of the Sheet Name
Delete Tip from MyTips Changing the Indentation in a Cell(s) in Excel 2007
Delete Tip from MyTips Importing a Text File in Excel 2007
Delete Tip from MyTips Copying and Pasting Validation list only in Microsoft Excel
Delete Tip from MyTips Combining Text and a Formatted Date
Delete Tip from MyTips Adding a Custom Function That Returns the Quarter Number
Delete Tip from MyTips Fast Copying & Pasting Right or Down in a List
Delete Tip from MyTips Removing Personal Information from a Workbook
Delete Tip from MyTips COUNT Formulas
Delete Tip from MyTips Summing using multiple criteria in Microsoft Excel
Delete Tip from MyTips Comparing Lists Using the COUNTIF Formula
Delete Tip from MyTips Comparing Lists
Delete Tip from MyTips Insert/Delete a Row/a Column in Excel 2007
Delete Tip from MyTips Counting the Number of YES Responses in a Student Questionnaire
Delete Tip from MyTips The Filter Ribbon in excel 2007
Delete Tip from MyTips Rounding Times Down to the Nearest 30 Seconds
Delete Tip from MyTips Removing Redundant Characters from a Range of Cells and Resetting the Format
Delete Tip from MyTips Limiting the Movement in a Protected Sheet
Delete Tip from MyTips Hiding Gridlines on the Screen and When Printing in Excel 2007
Delete Tip from MyTips Adding a Linked Picture to a Chart in Microsoft Excel
Delete Tip from MyTips Extracting the First N Number of Words from a String
Delete Tip from MyTips Array variables using VBA in Microsoft Excel
Delete Tip from MyTips Inserting Page Numbers in Excel 2007
Delete Tip from MyTips Copy Selection 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 Automatically Wrapping Text in a Cell
Delete Tip from MyTips Converting Time to Decimal 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 Copying Cell Content Across Sheets
Delete Tip from MyTips Change the default printer using VBA in Microsoft Excel
Delete Tip from MyTips Reversing the Order of Values in a List
Delete Tip from MyTips Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters
Delete Tip from MyTips How to eliminate N/A error result when using Vlookup formula in Microsoft Excel
Delete Tip from MyTips Totaling Time Values
Delete Tip from MyTips Change the state of a custom CommandBar button using VBA in Microsoft Excel
Delete Tip from MyTips Seleccionando Celdas desde Cualquier Celda hasta la Última del Rango Utilizado de la Hoja
Delete Tip from MyTips Preventing Moving to the Next Cell after Typing in Excel 2007
Delete Tip from MyTips Finding the Maximal / Minimal String, Based on Alphabetic Order
Delete Tip from MyTips Using a VLOOKUP Formula to Check If a Value Exists
Delete Tip from MyTips List all fonts available in Excel using VBA in Microsoft Excel
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Array Formulas – the Technical Side
Delete Tip from MyTips Sharing and Allow Users to Edit Changes in Excel 2007
Delete Tip from MyTips Combining Numbers that Have Leading Zeros
Delete Tip from MyTips Copy worksheet information to Word using VBA in Microsoft Excel
Delete Tip from MyTips Open and close the CD-ROM tray using VBA in Microsoft Excel
Delete Tip from MyTips Control Outlook from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Setting the Default Chart Type in Microsoft Excel
Delete Tip from MyTips Changing the Source Link
Delete Tip from MyTips Automatic Report formatting using option buttons
Delete Tip from MyTips Copy row heights and column widths using VBA in Microsoft Excel
Delete Tip from MyTips Finding Every Third Number and Returning the Largest of Them
Delete Tip from MyTips Calculating Canadian Mortgage Payments
Delete Tip from MyTips Grouping the Date Field by Number of Days in Excel 2007
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Change all cells in a range to values using VBA in Microsoft Excel
Delete Tip from MyTips Reviewing Comments in the Sheet in Excel 2007
Delete Tip from MyTips Reversing Strings
Delete Tip from MyTips Return error values from user defined functions using VBA in Microsoft Excel
Delete Tip from MyTips Filling a Range with a Series of Dates in Excel 2007
Delete Tip from MyTips Inserting a Copied Cell(s) Without Overwriting Existing Data
Delete Tip from MyTips Finding Specified Items in a List and Averaging their Associated Values
Delete Tip from MyTips Add a New Comment in Excel 2007
Delete Tip from MyTips Return text up to the second space in Microsoft Excel
Delete Tip from MyTips Automatically Defining Names for Ranges in a List in Excel 2007
Delete Tip from MyTips Copying or Applying Color to Groups and Outlines
Delete Tip from MyTips Displaying the serial number behind Date format in Microsoft Excel
Delete Tip from MyTips Seperating Website Name or URL from Text
Delete Tip from MyTips Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
Delete Tip from MyTips Access the Private module of a Worksheet Object while in Excel
Delete Tip from MyTips Hiding Gridlines on the Screen and When Printing
Delete Tip from MyTips Summing Values in a Range Containing Redundant Spaces
Delete Tip from MyTips Quick Move to end of range of cells in Microsoft Excel
Delete Tip from MyTips Protecting Sheets / Cells in Microsoft Excel
Delete Tip from MyTips Entering Times Quickly
Delete Tip from MyTips Calculating the Number of Weekday Hours Between Two Dates
Delete Tip from MyTips Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
Delete Tip from MyTips Averaging Values that Correspond with the X Largest Values in a Dynamic Range
Delete Tip from MyTips The Best Shortcut Keys in Microsoft Excel
Delete Tip from MyTips ”Desprender” Paletas desde la Barra de Herramientas
Delete Tip from MyTips Changing an Absolute Reference to a Relative Reference or Vice Versa in Excel 2007
Delete Tip from MyTips Eliminando Iconos que Realizan Dos Tareas Diferentes
Delete Tip from MyTips Counting Rows of Even Numbers in Two Parallel Ranges
Delete Tip from MyTips Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
Delete Tip from MyTips Removing Icons Performing Two Different Tasks
Delete Tip from MyTips Copy Selection to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Subtotal Ribbon in Excel 2007
  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