|  

» 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 Get the Row number of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Applying Formatting Only to Cells Containing Text
Delete Tip from MyTips Private Profile Strings using the Registry using VBA in Microsoft Excel
Delete Tip from MyTips Copy a row or rows of each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Filtering by the Date Field
Delete Tip from MyTips Calculating the Difference Between Hours
Delete Tip from MyTips Consolidating Lists While Adding Links to the Source Data
Delete Tip from MyTips Copy the CurrentRegion of a cell of each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Calculating Hourly Productivity
Delete Tip from MyTips Adding Subtotals to Primary and Secondary Fields
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips Unintentionally Creating Links between Workbooks in Excel 2007
Delete Tip from MyTips Replacing Substrings with Numbers from Adjacent Cells
Delete Tip from MyTips What's New in Excel 2003
Delete Tip from MyTips Separating First and Last Names
Delete Tip from MyTips Calculating Daily Pay, Incorporating Variable Hourly Rates
Delete Tip from MyTips Separating Positive and Negative numbers and add Running Balance column
Delete Tip from MyTips Compare two worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Removing icons from toolbars in Microsoft Excel
Delete Tip from MyTips Coloring One Record in Each Group in a Range
Delete Tip from MyTips Seleccionando Todas las Celdas de la Hoja
Delete Tip from MyTips Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime
Delete Tip from MyTips Basic information about OLE automation using VBA in Microsoft Excel
Delete Tip from MyTips Find the minimum positive value in Microsoft Excel
Delete Tip from MyTips Function for returning the user name using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values at the Intersection of Two or more Ranges
Delete Tip from MyTips Finding the First Value in a Row and Retrieving the Header for That Column
Delete Tip from MyTips Save a workbook backup using VBA in Microsoft Excel
Delete Tip from MyTips Counting Time Values in Terms of Hourly Increments
Delete Tip from MyTips Automatically Defining Names for Ranges in Lists
Delete Tip from MyTips Displaying the Workbook's Path in the Address Box
Delete Tip from MyTips Encoding a Sequence of Letters
Delete Tip from MyTips Rounding Times Down to the Nearest 30 Seconds
Delete Tip from MyTips Determine if a cell is within a range using VBA in Microsoft Excel
Delete Tip from MyTips Automatically Refreshing a PivotTable Report
Delete Tip from MyTips Mostrando el Cuadro de Diálogo de Formato de Celdas
Delete Tip from MyTips Export data from Excel to Access (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Print multiple selections on one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Calculating Total Annual Payment Based on Cumulative Monthly Payments
Delete Tip from MyTips Vinculando una Celda a un Cuadro de Texto
Delete Tip from MyTips Copying Styles from One Workbook to Another
Delete Tip from MyTips Using a Picture to Watch Cell Values in Other Sheets
Delete Tip from MyTips Finding a substring within a string
Delete Tip from MyTips Prevent entry of invalid values using VBA in Microsoft Excel
Delete Tip from MyTips Use the format painter to copy column widths and row heights in Microsoft Excel
Delete Tip from MyTips Total the Table in Excel 2007
Delete Tip from MyTips Problem: Date Formatting Cannot Be Changed in Excel 2007
Delete Tip from MyTips The Power Combination
Delete Tip from MyTips Printing a Custom View in Excel 2007
Delete Tip from MyTips Retrieving the Column Header of the Next Non-Blank Cell in a Row
Delete Tip from MyTips Autoexpanding a Date Type Chart using Microsoft Excel
Delete Tip from MyTips Use the continuous page numbers technique in Report Manager in Microsoft Excel.
Delete Tip from MyTips Rounding the Calculation of Retail Price and Sales Tax
Delete Tip from MyTips Retrieving the Value of the First Non-Blank Cell in a List
Delete Tip from MyTips Stepping into a Formula
Delete Tip from MyTips Printing a Chart in Microsoft Excel
Delete Tip from MyTips Count by color using VBA in Microsoft Excel
Delete Tip from MyTips Printing a Filtered List
Delete Tip from MyTips Move row into worksheet after entry of worksheet name into row using VBA in Microsoft Excel
Delete Tip from MyTips Replacing Data Markers with Pictures in Microsoft Excel
Delete Tip from MyTips Rearranging a String in Alphabetic Order
Delete Tip from MyTips Fast Typing in Selected Area
Delete Tip from MyTips To Insert/Remove a Page Break in Excel 2007
Delete Tip from MyTips Opening Workbooks from a List of Hyperlinks in Excel 2007
Delete Tip from MyTips Finding the Maximal / Minimal String, Based on Alphabetic Order
Delete Tip from MyTips Square root and cube root in Microsoft Excel
Delete Tip from MyTips Preventing Movement in Protected Areas in Microsoft Excel
Delete Tip from MyTips Problem: The Characters Are in Reverse Order
Delete Tip from MyTips Inserting a picture (company logo) in the header in Microsoft Excel 2002 xp
Delete Tip from MyTips Use VLOOKUP Function as an alternative to a number of nested IF functions.
Delete Tip from MyTips Converting Text to Its Proper Case
Delete Tip from MyTips Selecting a Set of Random Numbers, Avoiding Duplicates
Delete Tip from MyTips Change the availability for the CommandBars using VBA in Microsoft Excel
Delete Tip from MyTips Restricting Cell Entries to Text Only
Delete Tip from MyTips Calculate the count of workdays between two dates using VBA in Microsoft Excel
Delete Tip from MyTips Displaying Numbers in Thousands in a Chart in Microsoft Excel
Delete Tip from MyTips Converting Units
Delete Tip from MyTips Opening/Closing a Workbook(s)
Delete Tip from MyTips Open data in two dimensional array and save in sheet using VBA in Microsoft Excel
Delete Tip from MyTips Copiando/Moviendo una Celda (o Celdas) entre Hojas/Libros de Trabajo
Delete Tip from MyTips Selecting Special Cells
Delete Tip from MyTips Import data from Access to Excel (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Tracing Errors in Formula Results
Delete Tip from MyTips Counting the Number of Players According to Their Score in a Particular Quarter
Delete Tip from MyTips Handling Errors in Values & Empty cells in Excel 2007
Delete Tip from MyTips Retrieving the Last Value in a Dynamic List
Delete Tip from MyTips Automatically Wrapping Text in a Cell in Excel 2007
Delete Tip from MyTips Reducing the Workbook Size for Quick Sending via E Mail
Delete Tip from MyTips Finding the First Login and Last Logout Times of Employees
Delete Tip from MyTips Adding the Full Path of the Saved File to the Header/Footer
Delete Tip from MyTips Symbols Used to Create Custom Formatting
Delete Tip from MyTips Log files using VBA in Microsoft Excel
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 How to calculate VAT / Tax and net sale price in Microsoft Excel
Delete Tip from MyTips Coloring and Filtering Lists According to Criteria
Delete Tip from MyTips Index Formula vs. Vlookup Formula
Delete Tip from MyTips Delete a procedure from a module using VBA in Microsoft Excel
Delete Tip from MyTips Validating Text Entries in Excel 2007
Delete Tip from MyTips Adding Data, Charts, or Other Information to a Cell Comment
Delete Tip from MyTips Coloring Sheet Tabs
Delete Tip from MyTips Adding the Custom Views Icon to the Excel Menu Bar
Delete Tip from MyTips Combining Text and Numerically Calculated Results into One Output String
Delete Tip from MyTips Extract the first word in a cell in Microsoft Excel
Delete Tip from MyTips Summing Stock Lists
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Quickly Selecting a Range in the Workbook
Delete Tip from MyTips Copiando y Pegando el Contenido de una Celda en Miles de Celdas
Delete Tip from MyTips Adding a Shortcut for Wrapping Text
Delete Tip from MyTips Copying/Moving a Cell(s) Between Sheets/Workbooks
Delete Tip from MyTips Private Profile Strings using Words System.PrivateProfileString using VBA in Microsoft Excel
Delete Tip from MyTips Using Loops in VBA in Microsoft Excel
Delete Tip from MyTips Calculate holidays using VBA in Microsoft Excel
Delete Tip from MyTips Pass arguments to macros from buttons and menus using VBA in Microsoft Excel
Delete Tip from MyTips Playing WAV-files using VBA in Microsoft Excel
Delete Tip from MyTips Fill a ListBox with unique values from a worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Values Below or Above Average
Delete Tip from MyTips Saving Filtering Criteria in Excel 2007
Delete Tip from MyTips Use a closed workbook as a database (ADO) using VBA in Microsoft Excel
Delete Tip from MyTips Sorting Rules in Excel 2007
Delete Tip from MyTips Removing Hidden Apostrophes from Imported Numbers
Delete Tip from MyTips Rounding Numbers to Thousands
Delete Tip from MyTips Selecting Cells That Contain Formulas
Delete Tip from MyTips Find duplicates items in combine columns in Microsoft Excel
Delete Tip from MyTips Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters
Delete Tip from MyTips Fast Summation
Delete Tip from MyTips Hide/Unhide a Sheet in Excel 2007
Delete Tip from MyTips Counting the Values that Match Criteria in a Filtered List
Delete Tip from MyTips Change a Row or Rows to values to values using VBA in Microsoft Excel
Delete Tip from MyTips Deleting a Comment(s) in a Sheet in Excel 2007
Delete Tip from MyTips Adding Euro format to the number format in Microsoft Excel
Delete Tip from MyTips Displaying the serial number behind Date format in Microsoft Excel
Delete Tip from MyTips Retrieving Values from Different Sheets Using the Sheet Name as a Reference
Delete Tip from MyTips Time intervals using VBA in Microsoft Excel
Delete Tip from MyTips Change the availability for the shortcut menus 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 Create an addin in Excel 97, 2000, 2002 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 E-mailing an Excel Workbook, Sheet, Data or Chart
Delete Tip from MyTips Determine the screen size using VBA in Microsoft Excel
Delete Tip from MyTips Adding a Linked Picture to a Chart in Microsoft Excel
Delete Tip from MyTips Rounding Numbers to Millions
Delete Tip from MyTips Summing the N Largest Values in a Range
Delete Tip from MyTips Summing Sales Quantities and Amounts for Several Lists, or Presenting the Figures Side-by-Side
Delete Tip from MyTips Entering Formulas More Quickly by Shortening Sheet Names
Delete Tip from MyTips Transposing an Entire Range of Data into a Single Column
Delete Tip from MyTips Compare two worksheet ranges using VBA in Microsoft Excel
Delete Tip from MyTips Comparing Three or More Lists in Microsoft Excel
Delete Tip from MyTips Sharing and Allow Users to Edit Changes in Excel 2007
Delete Tip from MyTips Inserting a Watermark behind the Text in Excel 2007
Delete Tip from MyTips Protecting a Workbook in Excel 2007
Delete Tip from MyTips Protecting a Workbook
Delete Tip from MyTips Summing matching values in multiple rows
Delete Tip from MyTips Coloring Rows Based on Text Criteria
Delete Tip from MyTips Counting the Number of Cells Containing Text
Delete Tip from MyTips Summing Values from Different Sheets for the Same Cell Address
Delete Tip from MyTips Hiding Errors in Cells before Printing in Excel 2007
Delete Tip from MyTips Calculating Absolute Difference between Two Time Values
Delete Tip from MyTips Deleting Empty Rows
Delete Tip from MyTips Calculate Average Speed in Microsoft Excel
Delete Tip from MyTips Printing Formula Syntax
Delete Tip from MyTips Pasting Values
Delete Tip from MyTips Excel 2003 Resources on the Web
Delete Tip from MyTips Calculating Total Time Worked on a Specific Day
Delete Tip from MyTips Format even numbers
Delete Tip from MyTips Prevenir Moverse a la Siguiente Celda Después de Escribir
Delete Tip from MyTips Changing the Default Auto-Save File Location
Delete Tip from MyTips Formatting Cells Containing Formulas
Delete Tip from MyTips Copying/Moving a Cell(s) Between Sheets/Workbooks in Excel 2007
Delete Tip from MyTips Checking For Duplicate Values Within A Range
Delete Tip from MyTips Add a fancy line for Presentation
Delete Tip from MyTips Copy modules from one workbook to another using VBA in Microsoft Excel
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Permitiendo a Múltiples Usuarios Editar Rangos Predeterminados
Delete Tip from MyTips Adding a Picture to a Header/Footer in Excel 2007
Delete Tip from MyTips Sorting Sheets in Ascending Order
Delete Tip from MyTips Adding the Camera icon to the toolbar in Microsoft Excel
Delete Tip from MyTips How to Use Your Excel Add-In Functions in VBA
Delete Tip from MyTips Copying a Cell Comment
Delete Tip from MyTips Copy worksheet information to Word using VBA in Microsoft Excel
Delete Tip from MyTips Performing a Quick Calculation in the Formula Bar
Delete Tip from MyTips Using Different Functions to Consolidate Lists in excel 2007
Delete Tip from MyTips Delete sheets without confirmation prompts using VBA in Microsoft Excel
Delete Tip from MyTips List and add the days of months in a set period using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving Each Row Number that Corresponds with Successful Matches in a Look Up
Delete Tip from MyTips Saving a Customized Workbook as a Template
Delete Tip from MyTips Use listboxes with multiple choices using VBA in Microsoft Excel
Delete Tip from MyTips Copying or Applying Color to Groups and Outlines
Delete Tip from MyTips Opening a Template File Automatically When Starting Microsoft Excel
Delete Tip from MyTips Calculating the Week Number
Delete Tip from MyTips Searching a String for a Matching Word from another String
Delete Tip from MyTips Retrieving the Player Who Scored the Highest Number of Points
Delete Tip from MyTips Sum Total Sales Except for One Specified Item
Delete Tip from MyTips Delete rows and columns using VBA in Microsoft Excel
Delete Tip from MyTips Make LEFT Function recognize a number
Delete Tip from MyTips Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
Delete Tip from MyTips Protecting Workbooks with a Digital Signature in Excel 2007
Delete Tip from MyTips Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
Delete Tip from MyTips Avoiding Errors When Counting Date Values That Meet Specified Criteria
Delete Tip from MyTips Changing the Name of the Cell Comment's Author
Delete Tip from MyTips Extracting last Word
Delete Tip from MyTips Selecting Cells in Horizontal or Vertical Ranges
Delete Tip from MyTips Printing a Filtered List in Excel 2007
  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