|  

» 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 Export data from Excel to Access (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Rounding Numbers to Millions with Thousands as a Decimal
Delete Tip from MyTips Coloring Rows Based on Text Criteria
Delete Tip from MyTips Linking a Cell to a Text Box
Delete Tip from MyTips Merge cells without loosing values using VBA in Microsoft Excel
Delete Tip from MyTips Converting Uppercase Letters to Lowercase
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Separating First and Last Names
Delete Tip from MyTips Calculating Military Time Intervals
Delete Tip from MyTips List all the workbook links in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Combine the VLookup and Match formulas in Microsoft Excel
Delete Tip from MyTips Convert text to lower case in Microsoft Excel
Delete Tip from MyTips Adding a Shortcut for Wrapping Text
Delete Tip from MyTips Use a closed workbook as a database (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Rearranging a String in Alphabetic Order
Delete Tip from MyTips Personalizando un Icono
Delete Tip from MyTips Extracting last Word
Delete Tip from MyTips Totaling Time Values
Delete Tip from MyTips Summing values in vertical and horizontal ranges in Microsoft Excel
Delete Tip from MyTips Search and copy date values using VBA
Delete Tip from MyTips Summing Values Based on Text Criteria
Delete Tip from MyTips Changing the Name of the Cell Comment's Author
Delete Tip from MyTips Add page breaks to sorted data using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Updating a Range Name Reference
Delete Tip from MyTips Deleting All Cell Comments in a Sheet
Delete Tip from MyTips Copy all rows of a column without a value using VBA in Microsoft Excel
Delete Tip from MyTips Ranking Numbers in a Dynamic List
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 Values Based on the Criteria of a Non-Empty Adjacent Cell
Delete Tip from MyTips Adding a Data Field That Calculates Percentages from One Item of the Row Field
Delete Tip from MyTips Hiding or unhiding a column or columns in Microsoft Excel
Delete Tip from MyTips Importing a Text File in Excel 2007
Delete Tip from MyTips Summing Values from Different Sheets for the Same Cell Address
Delete Tip from MyTips Retrieving the Last Value in a Dynamic List
Delete Tip from MyTips Creating a Timesheet
Delete Tip from MyTips Viewing Selecting Data in a Sheet
Delete Tip from MyTips Calculations with one thousandth fractions of seconds by Custom Function using VBA
Delete Tip from MyTips Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts
Delete Tip from MyTips Open data in two dimensional array and save in sheet using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Every Nth Value in a Range
Delete Tip from MyTips Sorting Sheets in Ascending Order
Delete Tip from MyTips Summing a range containing errors and values 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 Determine the screen size using VBA in Microsoft Excel
Delete Tip from MyTips Checking For Duplicate Values Within A Range
Delete Tip from MyTips Copying, Cutting and Pasting (Moving)
Delete Tip from MyTips Preventing a Printed Area from Extending onto an Extra Page
Delete Tip from MyTips Rounding a Value to Make It Divisible by a Specified Number
Delete Tip from MyTips Retrieve Value Using Case-Sensitive Lookups
Delete Tip from MyTips Preventing a Printed Area from Extending onto an Extra Page in Excel 2007
Delete Tip from MyTips Restore the VBE windows to their default positions using VBA in Microsoft Excel
Delete Tip from MyTips Converting Text to Uppercase
Delete Tip from MyTips Reset filter before saving a worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Values from another Excel Workbook Using Text References
Delete Tip from MyTips Conditional formatting depending on a cell comment using VBA in Microsoft Excel
Delete Tip from MyTips Resguardando los Cambios Personalizados a Barras de Herramientas y Menús
Delete Tip from MyTips Conditonal Formatting using Microsoft Excel VBA
Delete Tip from MyTips Pass arguments to macros from buttons and menus using VBA in Microsoft Excel
Delete Tip from MyTips Delete a procedure from a module using VBA in Microsoft Excel
Delete Tip from MyTips Formatting a Negative Number with Parentheses
Delete Tip from MyTips Displaying Formula Syntax
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 Nesting Formulas
Delete Tip from MyTips Control Word from Excel using VBA in Microsoft Excel
Delete Tip from MyTips List all fonts available in Excel using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values from a List Containing Numerical and Textual Substrings
Delete Tip from MyTips Watch Calculation Results Immediately in Excel 2007
Delete Tip from MyTips How to eliminate N/A error result when using Vlookup formula in Microsoft Excel
Delete Tip from MyTips Use the continuous page numbers technique in Report Manager in Microsoft Excel.
Delete Tip from MyTips Coloring and/or Copying Subtotals from Consolidated Lists Containing Links
Delete Tip from MyTips Merging and Centering with a Toggle Button in Excel 2002 and Excel 2003
Delete Tip from MyTips Summarize data according to criteria from the data table using Sumif formula, Offset formula and Combo Box in Microsoft Excel
Delete Tip from MyTips Find the maximum numerical value in a list based on a criteria in Microsoft Excel
Delete Tip from MyTips Replacing Zeros with Dashes in Number Formatting
Delete Tip from MyTips Rounding numerical calculation results in Microsoft Excel
Delete Tip from MyTips Cambiando el Formato Predeterminado del Comentario de Celda
Delete Tip from MyTips Canceling the Update Links Message While Opening a Linked Workbook in Excel 2007
Delete Tip from MyTips Counting Values that Appear Only Once in
Delete Tip from MyTips Hide/Unhide a Sheet in Excel 2007
Delete Tip from MyTips Printing Non-Continuous Areas
Delete Tip from MyTips Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
Delete Tip from MyTips Seeing Calculation Results Immediately
Delete Tip from MyTips Summing the Absolute Values of All Numbers in a Range
Delete Tip from MyTips Consolidate with formulas if the row & column headers of all worksheets are identical in Microsoft Excel
Delete Tip from MyTips Close a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting in Excel 2007
Delete Tip from MyTips Changing the Default Style
Delete Tip from MyTips Rounding Numbers to Thousands
Delete Tip from MyTips Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
Delete Tip from MyTips Adding the Path Address to the Header/Footer
Delete Tip from MyTips Extract the last word in a cell in Microsoft Excel
Delete Tip from MyTips Import data from a closed workbook (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Converting Decimal Fractions to Fractions of a Specified Number
Delete Tip from MyTips Defining a Range Name
Delete Tip from MyTips Calculate Average Speed in Microsoft Excel
Delete Tip from MyTips Build an Excel Add-In in Microsoft Excel
Delete Tip from MyTips Displaying the serial number behind Date format in Microsoft Excel
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 Totaling Two Ranges Using the SUMIF Formula
Delete Tip from MyTips Dual Monitors - Trouble Displaying separate spreadsheets on each Monitor
Delete Tip from MyTips Getting Drill-Down Details in Excel 2007
Delete Tip from MyTips Ignoring Blank Cells when Performing Calculations
Delete Tip from MyTips Create User Forms in Microsoft Excel
Delete Tip from MyTips Selecting a Column(s) or Row(s) Using Keyboard Shortcuts
Delete Tip from MyTips Saving Defined Page Setups for Future Printing
Delete Tip from MyTips Determine if a workbook is already open using VBA in Microsoft Excel
Delete Tip from MyTips Inserting a picture (company logo) in Microsoft Excel 97 and 2000
Delete Tip from MyTips Edit the tooltip for toolbarbuttons using VBA in Microsoft Excel
Delete Tip from MyTips Delete all macros in a workbook/document using VBA in Microsoft Excel
Delete Tip from MyTips Deleting a Range Name in Excel 2007
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2000
Delete Tip from MyTips Checking for Sequences within a Sorted List
Delete Tip from MyTips Tracing Errors in Formula Results
Delete Tip from MyTips Customizing Date Formatting
Delete Tip from MyTips Stepping into a Formula in Excel 2007
Delete Tip from MyTips Adding Continuous Page Numbers While Printing
Delete Tip from MyTips Creating Formulas that Only Return Results from Non-Blank Cells
Delete Tip from MyTips Copying Cell Content Across Sheets
Delete Tip from MyTips Stepping into a Formula
Delete Tip from MyTips Find the minimum positive value in Microsoft Excel
Delete Tip from MyTips Sorting Numbers in Ascending or Descending Order
Delete Tip from MyTips Displaying Formulas and Values of the Same Cells
Delete Tip from MyTips Insert New Sheet in Excel 2007
Delete Tip from MyTips Redondeando Números a Millones con Miles como Decimal
Delete Tip from MyTips Retrieving a Price Value By Looking at Two Difference Data Tables
Delete Tip from MyTips Preventing Duplicates When Entering Data
Delete Tip from MyTips Comparing Three or More Lists in Microsoft Excel
Delete Tip from MyTips Grouping a Date Field by a Week Number in Excel 2007
Delete Tip from MyTips Pasting From Multiple Copied Ranges in Excel 2007
Delete Tip from MyTips Coloring Based on Text Criteria in Excel 2007
Delete Tip from MyTips Adding non-contiguous ranges to a single contiguous range for printing in Microsoft Excel
Delete Tip from MyTips Adding a Custom Function That Returns the Quarter Number
Delete Tip from MyTips Entering Times Quickly
Delete Tip from MyTips What's New in Excel 2003
Delete Tip from MyTips Show/Hide Expand Items Buttons in Excel 2007
Delete Tip from MyTips Adding the Properties Icon to the Standard Toolbar
Delete Tip from MyTips Redondeando Números a Miles con Centésimas como Decimales
Delete Tip from MyTips Execute Command/Sub-Procedure Using Timer in VBA
Delete Tip from MyTips Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel
Delete Tip from MyTips Automatically Refreshing a PivotTable Report
Delete Tip from MyTips Make LEFT Function recognize a number
Delete Tip from MyTips Count by color using VBA in Microsoft Excel
Delete Tip from MyTips Adding and Saving a New Customized Toolbar
Delete Tip from MyTips PivotTable report - Grouping Text Fields
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003
Delete Tip from MyTips Saving a Customized Workbook as a Template in Excel 2007
Delete Tip from MyTips Find the most commonly repeated string in a column in Microsoft Excel
Delete Tip from MyTips Set background color depending on value verification using VBA in Microsoft Excel
Delete Tip from MyTips Nesting Formulas in Excel 2007
Delete Tip from MyTips Function for returning the computer name using VBA in Microsoft Excel
Delete Tip from MyTips Displaying the Serial Number Behind the Time
Delete Tip from MyTips E-mailing an Excel Workbook, Sheet, Data or Chart
  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