|  

» 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 Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References
Delete Tip from MyTips Displaying the Format Cells Dialog Box
Delete Tip from MyTips Inserting a Copied Cell(s) Without Overwriting Existing Data
Delete Tip from MyTips Counting Unique Numeric Values or Unique Data in a List
Delete Tip from MyTips The Euro Currency Tools Add-In
Delete Tip from MyTips Encoding a Sequence of Letters
Delete Tip from MyTips Counting Based on Multiple Criteria
Delete Tip from MyTips Restricting Cell Entries to Text Only
Delete Tip from MyTips List files in a folder with Microsoft Scripting Runtime using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Unique Items Sold by Each Salesperson
Delete Tip from MyTips Calculations with one thousandth fractions of seconds by Custom Function using VBA
Delete Tip from MyTips Consolidating Lists
Delete Tip from MyTips Entering Times Quickly
Delete Tip from MyTips Entering Times Quickly
Delete Tip from MyTips Identifying and selecting the print area in a sheet 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 Preventing Movement in Protected Areas in Microsoft Excel
Delete Tip from MyTips Worksheet functions in VBA macros using VBA in Microsoft Excel
Delete Tip from MyTips Copying Cell Content Across Sheets
Delete Tip from MyTips Retrieving a Price Value by Looking at Two Difference Data Tables
Delete Tip from MyTips Changing the Default Cell Comment Format
Delete Tip from MyTips Comparing Lists Using the COUNTIF Formula
Delete Tip from MyTips Adding icons (boxes) to the menu bar in Microsoft Excel
Delete Tip from MyTips E-mailing an Excel Workbook, Sheet, Data or Chart
Delete Tip from MyTips Calculating Total Time Worked on a Specific Day
Delete Tip from MyTips Ocultando la Visualización de los Valores Cero
Delete Tip from MyTips Colorear las Filas Pares Numeradas en una Lista
Delete Tip from MyTips Copy all rows of a column without a value using VBA in Microsoft Excel
Delete Tip from MyTips Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
Delete Tip from MyTips Determine if a sheet exists in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips Changing the Number of Files Shown in the Recently Used File List
Delete Tip from MyTips Rounding a Value to Make It Divisible by a Specified Number
Delete Tip from MyTips Private Profile Strings using the Registry using VBA in Microsoft Excel
Delete Tip from MyTips Summing Sales Quantities and Amounts for Several Lists, or Presenting the Figures Side-by-Side
Delete Tip from MyTips Subtracting Times
Delete Tip from MyTips Search, enter, and delete values using VBA in Microsoft Excel
Delete Tip from MyTips Formatting a PivotTable Report
Delete Tip from MyTips Displaying the Serial Number Behind the Date
Delete Tip from MyTips Ranking a List of Numbers
Delete Tip from MyTips Filtering by Data Type in Excel 2007
Delete Tip from MyTips Displaying the Serial Number Behind the Time
Delete Tip from MyTips Changing the Default Auto-Save File Location
Delete Tip from MyTips Merge cells without loosing values using VBA in Microsoft Excel
Delete Tip from MyTips Calculating Total Time Worked on a
Delete Tip from MyTips Adding a Linked Picture to a Chart in Microsoft Excel
Delete Tip from MyTips Finding a substring within a string
Delete Tip from MyTips Transponiendo Celdas
Delete Tip from MyTips Counting the Number of Values from Multiple Worksheets that Match Criteria
Delete Tip from MyTips Creating a custom Report Manager by writing a short VBA program in Microsoft Excel
Delete Tip from MyTips Adding a Calculated Percentage Field
Delete Tip from MyTips Import data from Access to Excel (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Using the Keyboard to Select Chart Items in Microsoft Excel
Delete Tip from MyTips Determine which CommandBar button that started a macro using VBA in Microsoft Excel
Delete Tip from MyTips Array variables using VBA in Microsoft Excel
Delete Tip from MyTips Playing MIDI-files using VBA in Microsoft Excel
Delete Tip from MyTips Import data from Access to Excel (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Prevent that an automacro/eventmacro executes using VBA in Microsoft Excel
Delete Tip from MyTips Getting Values From A Closed Workbook using VBA in Microsoft Excel
Delete Tip from MyTips Coloring and/or Copying Subtotals from Consolidated Lists Containing Links in Excel 2007
Delete Tip from MyTips Determining Which Quarter a Specified Date Corresponds With
Delete Tip from MyTips Using a Range Name in a Formula
Delete Tip from MyTips Export data from Excel to Access (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts
Delete Tip from MyTips Filtering a List into Unique Records Using the COUNTIF Formula
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in Entire Workbook in Excel 2007
Delete Tip from MyTips Copying the Page Setup to Other Sheets in Excel 2007
Delete Tip from MyTips Making a Cell the First Cell in the Active Window
Delete Tip from MyTips Mail sheet(s) to one or more people using VBA in Microsoft Excel
Delete Tip from MyTips Execute Command/Sub-Procedure Using Timer in VBA
Delete Tip from MyTips Opening a template file automatically upon starting Microsoft Excel
Delete Tip from MyTips Performing Numeric Operations on Substrings
Delete Tip from MyTips Changing the Standard Font
Delete Tip from MyTips Display AutoFilter criteria after filtering using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Percentage of Cells in a Range that Contain a Specified String
Delete Tip from MyTips Combining Numbers that Have Leading Zeros
Delete Tip from MyTips Format number in joining text with linked number in Microsoft Excel
Delete Tip from MyTips Calculating the Number of Weekday Hours Between Two Dates
Delete Tip from MyTips Copying Styles from One Workbook to Another in Excel 2007
Delete Tip from MyTips Separating First and Last Names Without Using Formulas
Delete Tip from MyTips Generate a random value between two limits in Microsoft Excel
Delete Tip from MyTips Create new workbooks using VBA in Microsoft Excel
Delete Tip from MyTips Change the availability for a menu item using VBA in Microsoft Excel
Delete Tip from MyTips Summing Sales Amounts According to Product Category and Customer Name
Delete Tip from MyTips Adding and Saving a New Customized Toolbar
Delete Tip from MyTips The Power Combination
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 Converting Text to Uppercase
Delete Tip from MyTips Converting Text to Its Proper Case
Delete Tip from MyTips Filtering by More Than Two Criteria
Delete Tip from MyTips Finding the Serial Number of the Last Day of the Month
Delete Tip from MyTips Protecting Workbooks with a Digital Signature in Excel 2007
Delete Tip from MyTips Returning the Nth Largest / Smallest Values in a Range
Delete Tip from MyTips Retrieving the Most Frequent Occurrence for Each Category
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Show/Hide Field Header in Excel 2007
Delete Tip from MyTips Rounding Numbers to Millions
Delete Tip from MyTips Change the worksheet codemodule names using VBA in Microsoft Excel
Delete Tip from MyTips Printing a Filtered List in Excel 2007
Delete Tip from MyTips Working Out a Person's Age in Microsoft Excel
Delete Tip from MyTips Summing Numerical Substrings
Delete Tip from MyTips Reducing the Used Area in a Sheet
Delete Tip from MyTips Displaying the Top/Bottom N Items in Excel 2007
Delete Tip from MyTips Copying/Moving a Cell(s) Between Sheets/Workbooks
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields
Delete Tip from MyTips Protecting a Workbook
Delete Tip from MyTips Sorting by Custom Lists in Excel 2007
Delete Tip from MyTips Determining and Indicating the Number of Times Each Value Has Been Entered in a List
Delete Tip from MyTips Protecting a Workbook in Excel 2007
Delete Tip from MyTips Copiando y Pegando Rápido en Celdas Adyacentes
Delete Tip from MyTips Printing Formula Syntax
Delete Tip from MyTips Sort by birthday using VBA in Microsoft Excel
Delete Tip from MyTips Quickly Typing Dates into Cells
Delete Tip from MyTips Retrieving Sale Price Based On Item And Color Criteria
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Adjusting Values Returned by the RAND Function
Delete Tip from MyTips Insert a new module from a file 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 Create eventmacros for the Application object using VBA in Microsoft Excel
Delete Tip from MyTips Placing the Previous Payment Date beside Each Pay Date in a List
Delete Tip from MyTips Basic file and folder examples using VBA in Microsoft Excel
Delete Tip from MyTips Inserting a Field that Calculates the Difference between Two Fields in Excel 2007
Delete Tip from MyTips Copy the UsedRange of each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Grade Value for Corresponding Mark
Delete Tip from MyTips Coloreando Números Según un Criterio Específico
Delete Tip from MyTips Preventing a Printed Area from Extending onto an Extra Page in Excel 2007
Delete Tip from MyTips Validando Datos de Texto
Delete Tip from MyTips Calculating Daily Pay, Incorporating Variable Hourly Rates
Delete Tip from MyTips Rearranging a String in Alphabetic Order
Delete Tip from MyTips Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007
Delete Tip from MyTips Add a New Comment in Excel 2007
Delete Tip from MyTips Creating a World Time Converter
Delete Tip from MyTips Control Outlook from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Replacing Substrings with Numbers from Adjacent Cells
Delete Tip from MyTips Extracting Characters from Text Using Text Formulas
Delete Tip from MyTips PivotTable Report Terminology
Delete Tip from MyTips Protecting Sheets / Cells in Microsoft Excel
Delete Tip from MyTips Change all the cells in the ActiveSheet to values using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values from a List Containing Numerical and Textual Substrings
Delete Tip from MyTips Adding a Picture to a Header/Footer
Delete Tip from MyTips Ranking Numbers in a Dynamic List
Delete Tip from MyTips Calculating Hourly Productivity
Delete Tip from MyTips Icons Disappearing from the Toolbar
Delete Tip from MyTips Access the Private module of a Worksheet Object while in Excel
Delete Tip from MyTips Summing A Dynamic Range of Numbers According To Criteria
Delete Tip from MyTips Mostrando Cifras Redondeadas a Miles en un Reporte Financiero
Delete Tip from MyTips Moving Between Precedent and Dependent Cells
Delete Tip from MyTips Finding Every Third Number and Returning the Largest of Them
Delete Tip from MyTips Consolidating Lists While Adding Links to the Source Data in excel 2007
Delete Tip from MyTips Grouping Text Fields 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 Deleting the Word "Total" from the subtotal List
Delete Tip from MyTips Extract the last word in a cell in Microsoft Excel
Delete Tip from MyTips Combining Text and a Formatted Date
Delete Tip from MyTips Calculating the Average of Every Nth Value
Delete Tip from MyTips Set the Ruler Units in Excel 2007
Delete Tip from MyTips Filtering a Range into a List of Unique Records
Delete Tip from MyTips Find the last numeric value in a range in Microsoft Excel
Delete Tip from MyTips Parsing text to the right of a search criteria - delimiter in Microsoft Excel
Delete Tip from MyTips Copy cells to all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Checking If Matching Numbers Exist in Different Ranges
Delete Tip from MyTips Counting Date Values by Specified Date Criteria
Delete Tip from MyTips Copying Formatting
Delete Tip from MyTips Joining text using formula in Microsoft Excel
Delete Tip from MyTips Simplifying Formulas by Reducing the Complexity of IF Functions
Delete Tip from MyTips Calculate holidays using VBA in Microsoft Excel
Delete Tip from MyTips Color Unique Record in a Range in Excel 2007
Delete Tip from MyTips Determine if an application is available using VBA in Microsoft Excel
Delete Tip from MyTips Proofing in Excel 2007
Delete Tip from MyTips Seleccionar una Hoja de una Lista de Hojas Ordenadas
Delete Tip from MyTips Copying a Formula from a Cell While Keeping the Reference in Excel 2007
Delete Tip from MyTips Summing Stock Lists
Delete Tip from MyTips Adding special symbols to the number format in Microsoft Excel
Delete Tip from MyTips The Filter Ribbon in excel 2007
Delete Tip from MyTips Delete a module using VBA in Microsoft Excel
Delete Tip from MyTips Combining Text and Formatted Values
  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