|  

» 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 Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
Delete Tip from MyTips Displaying the Top/Bottom Number of Items
Delete Tip from MyTips Show the time in the Format hh:mm:000 using VBA
Delete Tip from MyTips Consolidate with formulas if the row & column headers of all worksheets are identical in Microsoft Excel
Delete Tip from MyTips Calculating the Average Value in Every Nth Column, Excluding Zeros
Delete Tip from MyTips Moving Between Unprotected Cells in a Protected Sheet
Delete Tip from MyTips Selecting Special Cells
Delete Tip from MyTips Calculating an Average, Only Including Prices on Which There Was no Discount
Delete Tip from MyTips Counting the Number of Combined First and Last Names Matching Criteria in a Dynamic Range
Delete Tip from MyTips Calculating a Required Date According to Two Criteria
Delete Tip from MyTips Get the value of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Copy cells to all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Performing Numeric Operations on Substrings
Delete Tip from MyTips Counting Date Values by Specified Date Criteria
Delete Tip from MyTips Change a Row or Rows to values to values using VBA in Microsoft Excel
Delete Tip from MyTips Summing Groups of Every N Values in a Row
Delete Tip from MyTips COUNT Formulas
Delete Tip from MyTips Copying Formatting
Delete Tip from MyTips Find the minimum positive value in Microsoft Excel
Delete Tip from MyTips Return the cell reference as text in Microsoft Excel
Delete Tip from MyTips Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range
Delete Tip from MyTips Quickly Typing Dates into Cells
Delete Tip from MyTips Sort the worksheets in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Default Auto-Save File Location
Delete Tip from MyTips Creating email address
Delete Tip from MyTips List of File Formats that are Supported in Excel 2007
Delete Tip from MyTips Counting the Number of Values from Multiple Worksheets that Match Criteria
Delete Tip from MyTips Redondeando Números a Millones con Miles como Decimal
Delete Tip from MyTips Summing Stock Lists
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet
Delete Tip from MyTips Summing Using Text Characters as Criteria
Delete Tip from MyTips Copy all rows of a column without a value using VBA in Microsoft Excel
Delete Tip from MyTips Reemplazando Ceros con signos “-“ en el Formato Numérico
Delete Tip from MyTips ”Desprender” Paletas desde la Barra de Herramientas
Delete Tip from MyTips Array variables using VBA in Microsoft Excel
Delete Tip from MyTips Converting Times to Decimal Values
Delete Tip from MyTips Counting the Number of YES Responses in a Student Questionnaire
Delete Tip from MyTips Defining a Range Name
Delete Tip from MyTips Set background color depending on value verification using VBA in Microsoft Excel
Delete Tip from MyTips Moving the Chart to a Different Place in the Sheet in Microsoft Excel
Delete Tip from MyTips Converting Time to Decimal Values
Delete Tip from MyTips Delete all macros in a workbook/document using VBA in Microsoft Excel
Delete Tip from MyTips Search and copy date values using VBA
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page in Excel 2007
Delete Tip from MyTips Opening a Copy of an Existing Workbook
Delete Tip from MyTips Seleccionando una Columna(s) o Fila(s) Utilizando Métodos Abreviados
Delete Tip from MyTips How to change column number with letter in Microsoft Excel
Delete Tip from MyTips Finding the Maximal / Minimal String, Based on Alphabetic Order
Delete Tip from MyTips Quickly Selecting a Range of Cells
Delete Tip from MyTips Seeing Calculation Results Immediately
Delete Tip from MyTips Preventing a VLOOKUP Function from Returning an Error when an Exact Match is Not Found
Delete Tip from MyTips Count cells in a range from all worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Pasting Values
Delete Tip from MyTips Hiding Subtotal Level Buttons
Delete Tip from MyTips Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Fast Copying & Pasting Right or Down in a List
Delete Tip from MyTips Change a Column or Columns to values using VBA in Microsoft Excel
Delete Tip from MyTips Adding the Auto Outline, Clear Outline, and Show Outline Symbols Icons to the Toolbar
Delete Tip from MyTips Coloreando un Registro en Cada Grupo en un Rango
Delete Tip from MyTips Copying Styles from One Workbook to Another in Excel 2007
Delete Tip from MyTips Use the format painter to copy column widths and row heights in Microsoft Excel
Delete Tip from MyTips Hiding Subtotal Level Buttons in Excel 2007
Delete Tip from MyTips Converting Units
Delete Tip from MyTips Showing All Items When Choosing from a Menu
Delete Tip from MyTips Nesting OR and AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Removing the Smart Tag Indicator
Delete Tip from MyTips Adding Euro format to the number format in Microsoft Excel
Delete Tip from MyTips Quitando el Indicador de Etiqueta Inteligente
Delete Tip from MyTips How to change error result calculation when using Vlookup formula to 0 or empty cell in Microsoft Excel
Delete Tip from MyTips Symbols Used to Create Custom Formatting
Delete Tip from MyTips Check if a VBProject is protected using VBA in Microsoft Excel
Delete Tip from MyTips Add a New Comment in Excel 2007
Delete Tip from MyTips Replace text in a text file using VBA in Microsoft Excel
Delete Tip from MyTips Counting Time Values in Terms of Hourly Increments
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened in Excel 2007
Delete Tip from MyTips Mail the Activeworkbook using VBA in Microsoft Excel
Delete Tip from MyTips Inserting/Editing Formulas in Excel 2007
Delete Tip from MyTips Copying & Pasting Cell Content to Thousands of Cells
Delete Tip from MyTips Retrieving Grade Value for Corresponding Mark
Delete Tip from MyTips Password to prevent opening a workbook in Microsoft Excel
Delete Tip from MyTips Calculating the Average of Every Nth Value
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page
Delete Tip from MyTips Removing icons from toolbars in Microsoft Excel
Delete Tip from MyTips Import data from a closed workbook (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Mail Sheet Array using VBA in Microsoft Excel
Delete Tip from MyTips Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in All Sheets
Delete Tip from MyTips Converting a Julian Date to a Calendar Date
Delete Tip from MyTips Customizing an Icon
Delete Tip from MyTips Ranking Numbers in a Dynamic List
Delete Tip from MyTips Combine the VLookup and Match formulas in Microsoft Excel
Delete Tip from MyTips Table Tools Ribbon in Excel 2007
Delete Tip from MyTips Unnecessary Blank Characters in Cells in Excel 2007
Delete Tip from MyTips Transposing a Column into Successive Rows of a Specified Length
Delete Tip from MyTips Deleting a Range Name
Delete Tip from MyTips Selecting a sheet from shortcut menu in Microsoft Excel
Delete Tip from MyTips Inserting a picture (company logo) in Microsoft Excel 97 and 2000
Delete Tip from MyTips Selecting a Column(s) or Row(s) Using Keyboard Shortcuts
Delete Tip from MyTips Add a cell, Row or a column in Microsoft Excel
Delete Tip from MyTips Protecting Cells Containing Formulas in a Protected Sheet
Delete Tip from MyTips Sorting Numbers Based on Their Frequency within a List
Delete Tip from MyTips Basic information about OLE automation using VBA in Microsoft Excel
Delete Tip from MyTips Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
Delete Tip from MyTips Identifying and selecting the print area in a sheet in Microsoft Excel
Delete Tip from MyTips Finding the Score that Was the Nth Highest for a Specified Team
Delete Tip from MyTips Restore the position in the window using VBA in Microsoft Excel
Delete Tip from MyTips Creating PivotTable in Excel 2007
Delete Tip from MyTips Printing a Chart in Microsoft Excel
Delete Tip from MyTips Generate total for dynamic area using VBA in Microsoft Excel
Delete Tip from MyTips Enter the Weekdays Mon - Fri in a Worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Grouping the Date Field by Number of Days in Excel 2007
Delete Tip from MyTips Filtering by More Than Two Criteria
Delete Tip from MyTips Change range with more then Area to values using VBA in Microsoft Excel
Delete Tip from MyTips Transposing Cells in Excel 2007
Delete Tip from MyTips Adding the Page Setup Icon to the Excel Menu Bar
Delete Tip from MyTips PivotTable report - Adding a Calculated Field
Delete Tip from MyTips Selecting a Sheet in the Workbook
Delete Tip from MyTips Separtaing A String Into Substrings.
Delete Tip from MyTips Extracting a substring
Delete Tip from MyTips Count the number of times in particular date a text appear in adjacent column in Microsoft Excel
Delete Tip from MyTips Selecting Special Cells in Excel 2007
Delete Tip from MyTips Inserting Page Numbers in Excel 2007
Delete Tip from MyTips Sorting by Custom Lists in Excel 2007
Delete Tip from MyTips Unhide rows and columns by using Custom Views in Microsoft Excel.
Delete Tip from MyTips Printing a Page Number in Portrait While the Page Is in Landscape Layout in Excel 2007
Delete Tip from MyTips Summing Monthly Trial Balance Figures
Delete Tip from MyTips Chart object events using VBA in Microsoft Excel
Delete Tip from MyTips Adding Data, Charts, or Other Information to a Cell Comment in Excel 2007
Delete Tip from MyTips Determine which CommandBar button that started a macro using VBA in Microsoft Excel
Delete Tip from MyTips Quickly Printing a Page from the Workbook Using a Custom View
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Creating and Saving Custom Styles
Delete Tip from MyTips Separating First and Last Names Without Using Formulas
Delete Tip from MyTips Put a line at Foot of print page
Delete Tip from MyTips Control Word from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Copying a Cell Comment in Excel 2007
Delete Tip from MyTips Range Name Syntax
Delete Tip from MyTips Adding a Picture to a Header/Footer
Delete Tip from MyTips Rounding Numbers that Meet Specified Criteria
Delete Tip from MyTips Searching a String for a Specific Substring
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips Getting Values From A Closed Workbook using VBA in Microsoft Excel
Delete Tip from MyTips Control Excel from Word using VBA in Microsoft Excel
Delete Tip from MyTips Copying the Subtotals Summary 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 Values between Two Specified Values in a List
Delete Tip from MyTips Limiting the Movement in an Unprotected Sheet in Excel 2007
Delete Tip from MyTips Disregarding blank cells when performing calculations on a range.
Delete Tip from MyTips Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
Delete Tip from MyTips Grouping/ Ungrouping Sheets
Delete Tip from MyTips Adding a Reference to Header/Footer in excel 2007
Delete Tip from MyTips Automatically Updating a Range Name Reference
Delete Tip from MyTips Sorting Rules & List Structure
Delete Tip from MyTips Adjust row height of merged cells using VBA in Microsoft Excel
Delete Tip from MyTips Seperating Website Name or URL from Text
Delete Tip from MyTips Copying Formulas and Pasting Them in a Transposed Direction Without Changing the Relative References
Delete Tip from MyTips Reversing Strings
Delete Tip from MyTips Calculate Average Speed in Microsoft Excel
Delete Tip from MyTips Copying a Cell Comment
Delete Tip from MyTips Replacing Substrings with Numbers from Adjacent Cells
Delete Tip from MyTips Coloring and/or Copying Subtotals from Consolidated Lists Containing Links in Excel 2007
Delete Tip from MyTips Preventing the Printing of Objects
Delete Tip from MyTips Change the state of a custom CommandBar button using VBA in Microsoft Excel
Delete Tip from MyTips Create eventmacros for the Application object using VBA in Microsoft Excel
Delete Tip from MyTips Return unique items using VBA in Microsoft Excel
Delete Tip from MyTips Return random numbers using VBA in Microsoft Excel
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting in Excel 2007
Delete Tip from MyTips Calculating the Number of Business Days in a Specified Period
Delete Tip from MyTips Hiding the Display of Zero Values
Delete Tip from MyTips Create day sheets of a month without weekends and holidays using VBA
  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. Create User Forms in Microsoft Excel
  5. Writing Your First VBA Function in Excel
  6. Copy Selection to a Database sheet using VBA in Microsoft Excel
  7. Replace text in a text file using VBA in Microsoft Excel
  8. Add Combo Box to a Sheet in Microsoft Excel
  9. Using Loops in VBA in Microsoft Excel
  10. Formulas to calculate Loan payments in Microsoft Excel
  11. Retrieving Values Using Range Names as References
  12. Summing Rounded Numbers
  13. Find duplicates items in combine columns in Microsoft Excel
  14. Adding the Page Setup Icon to the Excel Menu Bar
  15. Working Out a Person's Age in Microsoft Excel
  16. Turn off warning messages using VBA in Microsoft Excel
  17. Create an Amortization Schedule in Microsoft Excel
  18. PDF2XL Enterprise
  19. Converting Time to Decimal Values
  20. Summing Stock Lists

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