|  

» 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 Preventing Movement in Protected Areas in Microsoft Excel
Delete Tip from MyTips Selecting cells that only contain Text in Microsoft Excel
Delete Tip from MyTips Sum total stock value for any part in Microsoft Excel
Delete Tip from MyTips Delete all cells with today's date using VBA
Delete Tip from MyTips Delete sheets without confirmation prompts using VBA in Microsoft Excel
Delete Tip from MyTips Select bottom right end corner of the used area Microsoft Excel
Delete Tip from MyTips Hiding Outline Symbols
Delete Tip from MyTips Changing the Default Date Separator from a Slash to a Dot When Entering a Date into a Cell
Delete Tip from MyTips Counting the Number of Strings which Contain Numbers Meeting Criteria
Delete Tip from MyTips Counting the Number of Players According to Their Score in a Particular Quarter
Delete Tip from MyTips Replace all "u" with "U" up to today's date using VBA in Microsoft Excel
Delete Tip from MyTips Array Formulas – the Technical Side
Delete Tip from MyTips Totaling Two Ranges Using the SUMIF Formula
Delete Tip from MyTips Count the number of cells containing data in a range in Microsoft Excel
Delete Tip from MyTips Determining Whether a Person Worked a Full or Partial Shift
Delete Tip from MyTips Preventing Text from Spilling Over
Delete Tip from MyTips Count the number of cells in a range containing all types of Errors in Microsoft Excel
Delete Tip from MyTips Adding Subtotals to a Date Field
Delete Tip from MyTips Updating Charts by Dragging and Dropping in Microsoft Excel
Delete Tip from MyTips Problem: Unnecessary Empty Characters in Cells
Delete Tip from MyTips Displaying Figures in Financial Reports Rounded to Thousands
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 Haciendo que una Celda sea la Primera en la Ventana Activa
Delete Tip from MyTips How to Use Your Excel Add-In Functions in VBA
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2000
Delete Tip from MyTips Automatically Defining Names for Ranges in Lists
Delete Tip from MyTips Print multiple selections on one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Player Who Scored the Highest Number of Points
Delete Tip from MyTips Altering results returned in case of an error.
Delete Tip from MyTips Find the value in the first non blank cell in range in Microsoft Excel
Delete Tip from MyTips Summing Using Text Characters as Criteria
Delete Tip from MyTips PDF2XL Enterprise
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips Seperating Website Name or URL from Text
Delete Tip from MyTips Retrieving Values from another Excel Workbook Using Text References
Delete Tip from MyTips Adding Additional PivotTable Reports Using the Same Data Source
Delete Tip from MyTips Moving Between Precedent and Dependent Cells in Excel 2007
Delete Tip from MyTips Calculating the Lowest Common Multiple (LCM)
Delete Tip from MyTips Index Formula vs. Vlookup Formula
Delete Tip from MyTips Sort Ascending/Descending While Using AutoFilter
Delete Tip from MyTips Inserting a New Sheet from a Template Sheet
Delete Tip from MyTips Hiding Subtotal Level Buttons
Delete Tip from MyTips Finding and Deleting Unwanted and Orphan Links in Excel 2007
Delete Tip from MyTips Combining Numbers that Have Leading Zeros
Delete Tip from MyTips Count cells in a range from all worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Summing the N Largest Values in a Range
Delete Tip from MyTips Playing WAV-files using VBA in Microsoft Excel
Delete Tip from MyTips Change only the CurrentRegion of the ActiveCell to values using VBA in Microsoft Excel
Delete Tip from MyTips Replacing Data Markers with Pictures in Microsoft Excel
Delete Tip from MyTips Finding the Relative Position of Numbers within a String
Delete Tip from MyTips Creating Date and Time Stamp
Delete Tip from MyTips Using the Keyboard to Select Chart Items in Microsoft Excel
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 Transfer data from a recordset to a worksheet (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Displaying the Serial Number Behind the Time
Delete Tip from MyTips Excel 2003 Resources on the Web
Delete Tip from MyTips Changing the Default Auto-Save File Location in Excel 2007
Delete Tip from MyTips PivotTable report - Grouping Text Fields
Delete Tip from MyTips Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Performing a Quick Calculation in the Formula Bar
Delete Tip from MyTips Change the default printer using VBA in Microsoft Excel
Delete Tip from MyTips Performing calculations based on multiple criteria, using SUMPRODUCT function
Delete Tip from MyTips Create User Forms in Microsoft Excel
Delete Tip from MyTips Entering the Current Time into a Cell
Delete Tip from MyTips Ranking a List of Numbers
Delete Tip from MyTips Extracting last Word
Delete Tip from MyTips Playing MIDI-files using VBA in Microsoft Excel
Delete Tip from MyTips Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
Delete Tip from MyTips Ajustando Automáticamente el Texto en una Celda
Delete Tip from MyTips Cambiando la Fuente Estándar
Delete Tip from MyTips Change the selection with one or more areas to Values using VBA in Microsoft Excel
Delete Tip from MyTips Display AutoFilter criteria after filtering using VBA in Microsoft Excel
Delete Tip from MyTips Deleting the Word
Delete Tip from MyTips Using Date & Time Criteria to Count Entries in a Combined Date & Time List
Delete Tip from MyTips Log files using VBA in Microsoft Excel
Delete Tip from MyTips Replacing Zeros with Dashes in Number Formatting
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Copy the UsedRange of each sheet into one sheet using VBA 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 Displaying the Format Cells Dialog Box
Delete Tip from MyTips Conditional formatting depending on a cell comment 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 Using Different Functions to Consolidate Lists in excel 2007
Delete Tip from MyTips Simplifying complicated multiplication calculations using the SUMPRODUCT function
Delete Tip from MyTips Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel
Delete Tip from MyTips Add a New Comment in Excel 2007
Delete Tip from MyTips Avoiding Errors When Subtracting Times
Delete Tip from MyTips Avoiding the Occurrence of Unexpected VLOOKUP #N/A Errors
Delete Tip from MyTips Finding the Number of Days in a Given Month
Delete Tip from MyTips Ignoring Blank Cells Containing Invisible Spaces when Using Array Formulas
Delete Tip from MyTips Use AutoCorrect to enter special symbols in Microsoft Excel
Delete Tip from MyTips Changing the Default Number of Sheets in a New Workbook
Delete Tip from MyTips Ignoring Blank Cells when Performing Calculations
Delete Tip from MyTips Coloring Numbers Based on Specific Criteria
Delete Tip from MyTips Manually Wrapping Text in a Cell in Excel 2007
Delete Tip from MyTips Avoiding Errors when Subtracting Times
Delete Tip from MyTips Insert headers and footers using VBA in Microsoft Excel
Delete Tip from MyTips Cell Function Returns Sheet Name, Workbook Name and Path
Delete Tip from MyTips Search value in external workbook and paste with format style using VBA in Microsoft Excel
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 Adding a Custom Keyboard Shortcut
Delete Tip from MyTips Hiding Subtotal Level Buttons in Excel 2007
Delete Tip from MyTips Retrieving the Most Frequent Occurrence for Each Category
Delete Tip from MyTips Enter the Weekdays Mon - Fri in a Worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Summing Positive and Negative Numbers Separately
Delete Tip from MyTips Displaying the Top/Bottom Number of Items
Delete Tip from MyTips Making a Cell the First Cell in the Active Window
Delete Tip from MyTips Sorting Numbers in Ascending or Descending Order
Delete Tip from MyTips Deleting a Range Name
Delete Tip from MyTips Saving a Customized Workbook as a Template
Delete Tip from MyTips Moving to the Last (or First) Cell in a Range
Delete Tip from MyTips Copiando un Comentario de Celda
Delete Tip from MyTips Escribiendo Rápido un Nombre Largo de Empresa o Persona
Delete Tip from MyTips Summing the Visible Filtered List
Delete Tip from MyTips Summing data from a cell in a number of sheets in Microsoft Excel
Delete Tip from MyTips Formulas Erroneously Appearing as Text
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 Coloring Gridlines
Delete Tip from MyTips Icons Disappearing from the Toolbar
Delete Tip from MyTips Avoiding Errors When Counting Date Values That Meet Specified Criteria
Delete Tip from MyTips Coloring and/or Copying Subtotals from Consolidated Lists Containing Links in Excel 2007
Delete Tip from MyTips Hiding/Unhiding a Row(s) or Column(s)
Delete Tip from MyTips Ocultando la Visualización de los Valores Cero
Delete Tip from MyTips Automating the Insertion of the Euro Symbol
Delete Tip from MyTips Calculating Absolute Difference between Two Time Values
Delete Tip from MyTips Rounding a Value to Make It Divisible by a Specified Number
Delete Tip from MyTips Switching Between Open Workbooks in Excel 2007
Delete Tip from MyTips Decide what an INPUTBOX is supposed to return 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 Extract the first, middle and last name in Microsoft Excel
Delete Tip from MyTips Creating Formulas that Only Return Results from Non-Blank Cells
Delete Tip from MyTips Adding the Page Setup Icon to the Excel Menu Bar
Delete Tip from MyTips Validating Number Entries in Excel 2007
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Converting Text to Its Proper Case
Delete Tip from MyTips Inserting a Copied Cell(s) Without Overwriting Existing Data
Delete Tip from MyTips Table Tools Ribbon in Excel 2007
Delete Tip from MyTips Calculating a Required Date According to Two Criteria
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Recovering Data from a Corrupted Workbook That Cannot Be Opened in Excel 2007
Delete Tip from MyTips Cambiando un Encabezado Numérico a Texto
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page in Excel 2007
Delete Tip from MyTips Displaying the Format Cells Dialog Box in Excel 2007
Delete Tip from MyTips Insertando una Celda(s) sin Sobrescribir Datos Existentes
Delete Tip from MyTips Summing Values Using Indirect Cell References
Delete Tip from MyTips Copying Styles from One Workbook to Another in Excel 2007
Delete Tip from MyTips Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime
Delete Tip from MyTips Formatting a Negative Number with Parentheses
Delete Tip from MyTips Modifying a SUMPRODUCT function to Return a Sum Rather than a Count
Delete Tip from MyTips Coloring Visible Rows in Filtered List in Excel 2007
Delete Tip from MyTips Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts
Delete Tip from MyTips Creating List Objects
Delete Tip from MyTips To Insert/Remove a Page Break in Excel 2007
Delete Tip from MyTips Inserting Special Symbols into Custom Formats
Delete Tip from MyTips Sum by color using VBA in Microsoft Excel
Delete Tip from MyTips Printing a Filtered List in Excel 2007
Delete Tip from MyTips Find the Alphabetically Lowest Letter in a List
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Copying & Pasting Cell Content to Thousands of Cells
  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