|  

» 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 Userdefined functions from other workbooks using VBA in Microsoft Excel
Delete Tip from MyTips Show the time in the Format hh:mm:000 using VBA
Delete Tip from MyTips Limiting the Movement in a Protected Sheet
Delete Tip from MyTips Selecting a Sheet from a Sorted Sheets List
Delete Tip from MyTips Opening/Closing a Workbook(s)
Delete Tip from MyTips Display a message on the statusbar using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Number to a Formatted Time Value
Delete Tip from MyTips Hiding or unhiding a column or columns in Microsoft Excel
Delete Tip from MyTips Counting Unique Numeric Values or Unique Data in a List
Delete Tip from MyTips Summing Rounded Numbers
Delete Tip from MyTips Inserting a New Sheet from a Template Sheet
Delete Tip from MyTips Preventing the Printing of Objects
Delete Tip from MyTips Adding Text Values Representing Time
Delete Tip from MyTips Selecting Cells from Any Cell to the Last Cell in the Sheet's Used Range
Delete Tip from MyTips Square root and cube root in Microsoft Excel
Delete Tip from MyTips E-mailing an Excel Workbook, Sheet, Data or Chart
Delete Tip from MyTips Adding the Page Setup Icon to the Excel Menu Bar
Delete Tip from MyTips Comparing Lists in Excel 2007
Delete Tip from MyTips Sum by color using VBA in Microsoft Excel
Delete Tip from MyTips Reversing the Word Order within a String
Delete Tip from MyTips Calculating an Average, Only Including Prices on Which There Was no Discount
Delete Tip from MyTips Sorting Numbers in Ascending or Descending Order
Delete Tip from MyTips Quickly Typing Dates into Cells
Delete Tip from MyTips Copying a Formula from a Cell While Keeping the Absolute Reference or Relative Reference
Delete Tip from MyTips Summing using multiple criteria in Microsoft Excel
Delete Tip from MyTips Adding/Deleting Subtotals
Delete Tip from MyTips Cambiando la Forma de un Comentario de Celda
Delete Tip from MyTips Calculating the Week Number
Delete Tip from MyTips Filtering by More Than Two Criteria
Delete Tip from MyTips Transposing a Range in Ascending Order
Delete Tip from MyTips Private Profile Strings using INI-files using VBA in Microsoft Excel
Delete Tip from MyTips How Excel Sorts Lists
Delete Tip from MyTips Seleccionar una Hoja de una Lista de Hojas Ordenadas
Delete Tip from MyTips List all fonts available in Excel using VBA in Microsoft Excel
Delete Tip from MyTips Determining whether Two Given Dates Occur within the Same Week
Delete Tip from MyTips Delete all macros in a workbook/document using VBA in Microsoft Excel
Delete Tip from MyTips Changing a Numeric Heading to Text
Delete Tip from MyTips Using a VLOOKUP Formula to Check If a Value Exists
Delete Tip from MyTips Quickly Creating Links Between Ranges
Delete Tip from MyTips Additional Functions in AutoSum
Delete Tip from MyTips Filtering a Range into a List of Unique Records
Delete Tip from MyTips Retrieving Values from another Sheet Using Date as Sheet Name Reference
Delete Tip from MyTips Defining a Range Name
Delete Tip from MyTips Calculating the Average of Every Nth Value, Excluding Zeros
Delete Tip from MyTips Changing the Name of the Cell Comment's Author
Delete Tip from MyTips Adding Data, Charts, or Other Information to a Cell Comment
Delete Tip from MyTips Adding the Auto Outline, Clear Outline, and Show Outline Symbols Icons to the Toolbar
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates Percentage Difference from the Previous Item
Delete Tip from MyTips Search and copy date values using VBA
Delete Tip from MyTips Eliminate screen flashing while running a macro using VBA in in Microsoft Excel
Delete Tip from MyTips Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References
Delete Tip from MyTips Searching a String for a Specific Substring
Delete Tip from MyTips Limiting the Movement in a Protected Sheet in Excel 2007
Delete Tip from MyTips Drag Fields into PivotTable Report in Excel 2007
Delete Tip from MyTips Displaying Numbers in Thousands in a Chart in Microsoft Excel
Delete Tip from MyTips Inserting a picture (company logo) in the header in Microsoft Excel 2002 xp
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips Splitting a Full Address into Three Separate Cells
Delete Tip from MyTips Retrieving Values from Different Sheets Using the Sheet Name as a Reference
Delete Tip from MyTips Performing a Quick Calculation in the Formula Bar
Delete Tip from MyTips Workbook events using VBA in Microsoft Excel
Delete Tip from MyTips Find the minimum positive value in Microsoft Excel
Delete Tip from MyTips Determine the screen size using VBA in Microsoft Excel
Delete Tip from MyTips Entering the Current Time into a Cell
Delete Tip from MyTips Personalizando un Icono
Delete Tip from MyTips Mail the Activeworkbook using VBA in Microsoft Excel
Delete Tip from MyTips Sort Ascending/Descending While Using AutoFilter
Delete Tip from MyTips Converting Units
Delete Tip from MyTips Count the number of values between a lower and upper limit in Microsoft Excel
Delete Tip from MyTips List files in a folder with Office 97 or later using VBA in Microsoft Excel
Delete Tip from MyTips Access ThisWorkbook module directly from Excel
Delete Tip from MyTips Deleting All Cell Comments in a Sheet
Delete Tip from MyTips Calculating a Building's Occupancy Rate at Specified Times
Delete Tip from MyTips Calculate holidays using VBA in Microsoft Excel
Delete Tip from MyTips Select folder names using VBA in Microsoft Excel
Delete Tip from MyTips Converting a Number to a Time Value
Delete Tip from MyTips Entrada Rápida de Texto en Celdas desde una Lista Previa de Entradas o Lista de Validación
Delete Tip from MyTips Export data from Excel to Access (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Seleccionando una Columna(s) o Fila(s) Utilizando Métodos Abreviados
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 Mail every Worksheet with address in cell A1 using VBA in Microsoft Excel
Delete Tip from MyTips Get the value of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Create a new module using VBA in Microsoft Excel
Delete Tip from MyTips Copy a sheet from each workbook into your workbook in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout
Delete Tip from MyTips Funcionalidades Expandidas de Pegado de Íconos en Excel 2002 y Excel 2003
Delete Tip from MyTips Return unique items using VBA in Microsoft Excel
Delete Tip from MyTips Combining Text from Different Cells
Delete Tip from MyTips Seperating Website Name or URL from Text
Delete Tip from MyTips Converting a Month's Serial Number into Its Corresponding Name
Delete Tip from MyTips Adding Groups and Outlines Manually
Delete Tip from MyTips Preventing Movement in Protected Areas in Microsoft Excel
Delete Tip from MyTips Showing All Items When Choosing from a Menu
Delete Tip from MyTips Counting values meeting multiple criteria in different columns.
Delete Tip from MyTips Row and column background color using VBA in Microsoft Excel
Delete Tip from MyTips Coloring and Filtering Lists According to Criteria
Delete Tip from MyTips Coloring Gridlines in Excel 2007
Delete Tip from MyTips Protecting Cells Containing Formulas in an Unprotected Sheet in Excel 2007
Delete Tip from MyTips Calculating the Number of Business Days in a Specified Period
Delete Tip from MyTips Finding a substring within a string
Delete Tip from MyTips Control Word from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Log files using VBA in Microsoft Excel
Delete Tip from MyTips Extending the Range of the SUM Formula
Delete Tip from MyTips Displaying the Format Cells Dialog Box
Delete Tip from MyTips Ranking Salespeople According to Sales Figure
Delete Tip from MyTips Copying a Cell Comment
Delete Tip from MyTips Copying and Pasting Validation list only in Microsoft Excel
Delete Tip from MyTips Combining Text and Numerically Calculated Results into One Output String
Delete Tip from MyTips Updating Charts by Dragging and Dropping in Microsoft Excel
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened in Excel 2007
Delete Tip from MyTips Retrieving the Value of the First Nonblank Cell in a List
Delete Tip from MyTips Removing the Smart Tag Indicator in Excel 2007
Delete Tip from MyTips Compare two worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Restricting the Number of Characters Entered into a Cell
Delete Tip from MyTips Adding the Custom Views Icon to the Excel Menu Bar
Delete Tip from MyTips Reducing the Used Area in a Sheet
Delete Tip from MyTips Checking For Duplicate Values Within A Range
Delete Tip from MyTips Copying or Moving a Sheet
Delete Tip from MyTips Log files using VBA in Microsoft Excel
Delete Tip from MyTips Excel 2003 Resources on the Web
Delete Tip from MyTips Canceling the Update Links Message While Opening a Linked Workbook
Delete Tip from MyTips Calculating the Average for Numbers Meeting Specified Criteria
Delete Tip from MyTips Retrieve the Distance between Any Two Cities from Distance Table
Delete Tip from MyTips Grouping the Date Field by Days, Months, Quarters, and Years in Excel 2007
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Transposing Cells
Delete Tip from MyTips Unintentionally Creating Links Between Workbooks
Delete Tip from MyTips Copy a Column or Columns to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Checking Whether Cells in a Range are Blank, and Counting the Blank Cells
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 Conditional Formatting in Excel 2007
Delete Tip from MyTips Change the cursor appearance to hourglass using VBA in Microsoft Excel
Delete Tip from MyTips Sum the digits numbers in a cell using custom VBA function in Microsoft Excel
Delete Tip from MyTips Searching for text in Microsoft Excel
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Avoiding Problems when Numeric Values are used as Text
Delete Tip from MyTips Adding the Camera icon to the toolbar in Microsoft Excel
Delete Tip from MyTips Filtering by the Date Field
Delete Tip from MyTips Whats New in Excel 2007
Delete Tip from MyTips Displaying zero values in Microsoft Excel
Delete Tip from MyTips Imprimiendo Comentarios de Celda
Delete Tip from MyTips Converting Times to Decimal Values
Delete Tip from MyTips Totaling Two Ranges Using the SUMIF Formula
Delete Tip from MyTips Calculating Differences Between Dates
Delete Tip from MyTips Display AutoFilter criteria after filtering using VBA in Microsoft Excel
Delete Tip from MyTips Buscando/Buscando y Reemplazando en una Hoja o en Todas las Hojas
Delete Tip from MyTips To highlight Header Rows/Columns or Banded Rows/Columns in Excel 2007
Delete Tip from MyTips Save a workbook backup using VBA in Microsoft Excel
Delete Tip from MyTips Escribiendo Rápido en un Área Seleccionada
Delete Tip from MyTips Comparing Three or More Lists in Microsoft Excel
Delete Tip from MyTips Retrieving Every Nth Value in a Range
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout in Excel 2007
Delete Tip from MyTips List, change or delete external formula references (links) using VBA in Microsoft Excel
Delete Tip from MyTips Shortcuts to see the Help for the Syntax Function in Microsoft Excel
Delete Tip from MyTips Counting the Number of Cells Containing Text
Delete Tip from MyTips Checking for Duplicate Values within a Range
Delete Tip from MyTips Selecting/Formatting Cells Containing Errors
Delete Tip from MyTips Separating a Number Into Digits
Delete Tip from MyTips Quickly Selecting a Range of Cells
Delete Tip from MyTips Change font color based on Date using VBA in Microsoft Excel
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 97
Delete Tip from MyTips Validating Text Entries in Excel 2007
Delete Tip from MyTips Sorting Numbers Based on Their Frequency within a List
Delete Tip from MyTips Changing an Absolute Reference to a Relative Reference or Vice Versa in Excel 2007
Delete Tip from MyTips Removing the Smart Tag Indicator
Delete Tip from MyTips Create a Custom Function
Delete Tip from MyTips Printing in Excel 2007
Delete Tip from MyTips Move row into worksheet after entry of worksheet name into row using VBA in Microsoft Excel
Delete Tip from MyTips To Insert/Remove a Page Break in Excel 2007
Delete Tip from MyTips Separating First and Last Names
Delete Tip from MyTips Counting Vacation or Sick Days within a Specified Time Period
Delete Tip from MyTips Retrieving the Last Value and the Last Character in a Row
Delete Tip from MyTips Counting the Number of Combined First and Last Names Matching Criteria in a Dynamic Range
Delete Tip from MyTips Sum the largest two numbers in range in Microsoft Excel
Delete Tip from MyTips Delete a module using VBA in Microsoft Excel
Delete Tip from MyTips Change the value/content of several UserForm-controls using VBA in Microsoft Excel
Delete Tip from MyTips Replacing Data Markers with Pictures in Microsoft Excel
Delete Tip from MyTips Pegando Múltiples Rangos Copiados Utilizando el Porta Papeles
Delete Tip from MyTips Use VLOOKUP Function as an alternative to a number of nested IF functions.
Delete Tip from MyTips Viewing Selecting Data in a Sheet
Delete Tip from MyTips Combining the Contents of Every N Number of Cells into One Value
Delete Tip from MyTips Shuffling a List of Values
Delete Tip from MyTips Defining a Range Name in Excel 2007
Delete Tip from MyTips Search, enter, and delete values using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Remaining Credit after Each Purchase
Delete Tip from MyTips Automating the Insertion of the Euro Symbol
Delete Tip from MyTips Printing an Already Saved Report Using Report Manager
Delete Tip from MyTips Creating a Counting Grid
Delete Tip from MyTips Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
Delete Tip from MyTips Seleccionando celdas especiales
Delete Tip from MyTips Change all the cells in the ActiveSheet to values using VBA in Microsoft Excel
Delete Tip from MyTips Combining Text and Formatted Values
Delete Tip from MyTips Close a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Font Size of the Sheet Name
Delete Tip from MyTips Change a Column or Columns to values using VBA in Microsoft Excel
Delete Tip from MyTips Add Group and Outline in Excel 2007
Delete Tip from MyTips Calculating Military Time Intervals
  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