|  

» 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 Set the Background Color according to the date using VBA in Microsoft Excel
Delete Tip from MyTips Displaying the serial number behind Date format in Microsoft Excel
Delete Tip from MyTips Use Smart Tag to fill series of dates in Microsoft Excel
Delete Tip from MyTips Sort by birthday using VBA in Microsoft Excel
Delete Tip from MyTips Convert time to a serial value in Microsoft Excel
Delete Tip from MyTips Adding Data, Charts, or Other Information to a Cell Comment
Delete Tip from MyTips How to extract a file name from a path in Microsoft Excel
Delete Tip from MyTips Reversing The Order Of Values In A List
Delete Tip from MyTips Creating a Counting Grid
Delete Tip from MyTips Summing using multiple criteria in Microsoft Excel
Delete Tip from MyTips Copy a Column or Columns to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Countdown in status bar using VBA in Microsoft Excel
Delete Tip from MyTips Canceling the Update Links Message While Opening a Linked Workbook in Excel 2007
Delete Tip from MyTips Rounding Hours Up
Delete Tip from MyTips Extract all the words except the first in Microsoft Excel
Delete Tip from MyTips Create styles directly from cells in Microsoft Excel
Delete Tip from MyTips Vlookup Formula – Organizing the Data Table
Delete Tip from MyTips Calculating a Required Date According to Two Criteria
Delete Tip from MyTips Comparing Lists
Delete Tip from MyTips Calculating Total Income Tax
Delete Tip from MyTips Count the number of words in a cell in Microsoft Excel
Delete Tip from MyTips Finding the Score that Was the Nth Highest for a Specified Team
Delete Tip from MyTips Copy Selection to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Replace value from validation list with a number using VBA 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 Totaling Time Values
Delete Tip from MyTips Adding Euro format to the number format 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 Parsing text to the right of a search criteria - delimiter in Microsoft Excel
Delete Tip from MyTips Validating Date Entries in Excel 2007
Delete Tip from MyTips Copy cells to all workbooks in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Week Number Corresponding with a Specific Date
Delete Tip from MyTips Sort Ascending/Descending While Using Filter in Excel 2007
Delete Tip from MyTips Change the availability for the shortcut menus using VBA in Microsoft Excel
Delete Tip from MyTips Insert a new module from a file using VBA in Microsoft Excel
Delete Tip from MyTips Automatic Report formatting using option buttons
Delete Tip from MyTips Using Loops in VBA in Microsoft Excel
Delete Tip from MyTips Coloring Sheet Tabs
Delete Tip from MyTips Separtaing A String Into Substrings.
Delete Tip from MyTips Changing the Default Style
Delete Tip from MyTips Simplifying Formulas by Defining Names for Often-Repeated Parts
Delete Tip from MyTips Preventing the Printing of Objects
Delete Tip from MyTips Create a new module using VBA in Microsoft Excel
Delete Tip from MyTips Displaying Formulas and Values of the Same Cells in Excel 2007
Delete Tip from MyTips Seleccionando la Lista/Región Actual
Delete Tip from MyTips Retrieving the Closest Larger / Closest Smaller Values from a List when there is No Exact Match
Delete Tip from MyTips Sort Ribbon in Excel 2007
Delete Tip from MyTips Summing Values from Two Ranges, Based on Two Criteria
Delete Tip from MyTips Retrieving Unique Values From A List
Delete Tip from MyTips Selecting a sheet from shortcut menu in Microsoft Excel
Delete Tip from MyTips Combining Text from Different Cells
Delete Tip from MyTips Protecting Cells Containing Formulas in a Protected Sheet
Delete Tip from MyTips Preventing Text from Spilling Over
Delete Tip from MyTips Compare two worksheets using VBA in Microsoft Excel
Delete Tip from MyTips Create day sheets of a month without weekends and holidays using VBA
Delete Tip from MyTips Add page breaks to sorted data using VBA in Microsoft Excel
Delete Tip from MyTips Change the value/content of several UserForm-controls using VBA in Microsoft Excel
Delete Tip from MyTips Create worksheets from a list of names using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Number of Business Days in a Specified Period
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 Agregando un Método Abreviado Personalizado
Delete Tip from MyTips Combining the Contents of Every N Number of Cells into One Value
Delete Tip from MyTips Converting Text to Its Proper Case
Delete Tip from MyTips Counting the Number of Values Meeting Criteria, but Only for Every 3rd Cell in a Range
Delete Tip from MyTips Formulas Erroneously Appearing as Text
Delete Tip from MyTips Replacing Zeros with Dashes in Number Formatting
Delete Tip from MyTips Summing Values from Different Sheets for the Same Cell Address
Delete Tip from MyTips Converting Units
Delete Tip from MyTips Show the time in the Format hh:mm:000 using VBA
Delete Tip from MyTips Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
Delete Tip from MyTips Entering the Current Time into a Cell
Delete Tip from MyTips Separating Positive and Negative numbers and add Running Balance column
Delete Tip from MyTips Filtering by Data Type in Excel 2007
Delete Tip from MyTips Using a Workspace to Open a Number of Workbooks at Once in Excel 2007
Delete Tip from MyTips Selecting All Sheet Cells
Delete Tip from MyTips Converting Text to Uppercase
Delete Tip from MyTips Rearranging a String in Alphabetic Order
Delete Tip from MyTips Coloring and/or Copying Subtotals from Consolidated Lists Containing Links
Delete Tip from MyTips Determine if an application is available using VBA in Microsoft Excel
Delete Tip from MyTips Calculating a Building's Occupancy Rate at Specified Times
Delete Tip from MyTips Cell protection only for formulas using VBA in Microsoft Excel
Delete Tip from MyTips Insert pictures using VBA in Microsoft Excel
Delete Tip from MyTips Array variables using VBA in Microsoft Excel
Delete Tip from MyTips Separating First and Last Names Using Formulas
Delete Tip from MyTips Change slash separator in date with period in Microsoft Excel
Delete Tip from MyTips Hiding the Display of Zero Values in Excel 2007
Delete Tip from MyTips Adding a Specified Number of Months to a Date
Delete Tip from MyTips Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells
Delete Tip from MyTips Count the number of values between a lower and upper limit in Microsoft Excel
Delete Tip from MyTips Adding the Camera icon to the toolbar in Microsoft Excel
Delete Tip from MyTips How to calculate VAT / Tax and net sale price in Microsoft Excel
Delete Tip from MyTips Quickly Printing a Page from the Workbook Using a Custom View
Delete Tip from MyTips Filtering by the Date Field
Delete Tip from MyTips Showing All Items When Choosing from a Menu
Delete Tip from MyTips Opening a Linked Workbook in Microsoft Excel
Delete Tip from MyTips Additional Functions in AutoSum
Delete Tip from MyTips Ranking Salespeople According To Sales Figure
Delete Tip from MyTips PDF2XL and PDF2XL OCR
Delete Tip from MyTips Extract the last word in a cell in Microsoft Excel
Delete Tip from MyTips Determine if a file is in use using VBA in Microsoft Excel
Delete Tip from MyTips Summing the Absolute Values of All Numbers in a Range
Delete Tip from MyTips Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
Delete Tip from MyTips Insertando Símbolos Especiales en Formatos Personalizados
Delete Tip from MyTips Updating Charts by Dragging and Dropping 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 Display AutoFilter criteria after filtering using VBA in Microsoft Excel
Delete Tip from MyTips Consolidating Lists While Adding Links to the Source Data in excel 2007
Delete Tip from MyTips Increasing/Decreasing the Screen Magnification Percentage
Delete Tip from MyTips Counting the Number of Times a Substring Appears Within a String
Delete Tip from MyTips Adding a Custom Function That Returns the Quarter Number
Delete Tip from MyTips Copying Cell Content Across Sheets
Delete Tip from MyTips Use the continuous page numbers technique in Report Manager in Microsoft Excel.
Delete Tip from MyTips Moving Between Precedent and Dependent Cells
Delete Tip from MyTips Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Changing the Cell Formatting from Date to Number
Delete Tip from MyTips Tracing Errors in Formula Results
Delete Tip from MyTips Entering Dates Quickly
Delete Tip from MyTips Problem: Values Not Formatting as Numbers
Delete Tip from MyTips Opening a saved Workbook in Microsoft Excel
Delete Tip from MyTips Control Outlook from Excel using VBA in Microsoft Excel
Delete Tip from MyTips Counting the Number of Cells Containing Text in a Range
Delete Tip from MyTips Retrieving the Last Value in a Dynamic List
Delete Tip from MyTips Adjusting Values Returned by the RAND Function
Delete Tip from MyTips Using Date & Time Criteria to Count Entries in a Combined Date & Time List
Delete Tip from MyTips Summing the Values of Cells Occurring at the Intersection of Ranges
Delete Tip from MyTips Weeknumbers using VBA in Microsoft Excel
Delete Tip from MyTips Shuffling a List of Values
Delete Tip from MyTips Find if a character is in a cell in Microsoft Excel
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page in Excel 2007
Delete Tip from MyTips Set up yellow background color for header in an AutoFilter table using VBA in Microsoft Excel
Delete Tip from MyTips Inserting Page Numbers in Excel 2007
Delete Tip from MyTips Avoiding Errors When Subtracting Times
Delete Tip from MyTips Display all installed fonts (Word) using VBA in Microsoft Excel
Delete Tip from MyTips Protecting the Sheet or the Cells in the Sheet
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips Print multiple selections on one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Retrieving the Entire Row of a Matched Value
Delete Tip from MyTips Copiando y Pegando el Contenido de Celdas Conservando el Formato
Delete Tip from MyTips Sum the largest two numbers in range in Microsoft Excel
Delete Tip from MyTips Delete module content using VBA in Microsoft Excel
Delete Tip from MyTips Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References
Delete Tip from MyTips Change text in header when printing using VBA in Microsoft Excel
Delete Tip from MyTips Finding the maximum value of all those meeting a certain criteria.
Delete Tip from MyTips Preventing Movement in Protected Areas in Microsoft Excel
Delete Tip from MyTips Retrieving Every nth Value In a Range
Delete Tip from MyTips Edit a Comment in Excel 2007
Delete Tip from MyTips Setting the Number of Fields Displayed in Excel 2007
Delete Tip from MyTips Inserting a picture (company logo) in Microsoft Excel 97 and 2000
Delete Tip from MyTips Retrieving the Minimal / Maximal Values from a Filtered List
Delete Tip from MyTips Coloring Based on Text Criteria in Excel 2007
Delete Tip from MyTips Coloring Gridlines
Delete Tip from MyTips Inserting a Calculated Field in Excel 2007
Delete Tip from MyTips Determining Long Distance Phone Calls, Based on the Number Dialed
Delete Tip from MyTips Seleccionar una Hoja en el Libro
Delete Tip from MyTips Determine if a workbook is already open using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values Based on Text Criteria
Delete Tip from MyTips Applying Formatting to Cells Containing Text Only in Excel 2007
Delete Tip from MyTips How to Use Your Excel Add-In Functions in VBA
Delete Tip from MyTips Mostrando Todos los Elementos al Escoger de un Menú
Delete Tip from MyTips Problem: The Minus Sign Appears to the Right of the Number
Delete Tip from MyTips Inserting a picture (company logo) in the header in Microsoft Excel 2002 xp
Delete Tip from MyTips Summing the Visible Filtered List Values in Excel 2007
Delete Tip from MyTips Rounding Numbers to Thousands
Delete Tip from MyTips Count the number of cells with numeric data in a range in Microsoft Excel
Delete Tip from MyTips Preventing a Printed Area from Extending onto an Extra Page in Excel 2007
Delete Tip from MyTips Hiding Subtotal Level Buttons in Excel 2007
Delete Tip from MyTips Calculating the Average of Every Nth Value, Excluding Zeros
Delete Tip from MyTips Searching a String for a Matching Word from another String
Delete Tip from MyTips Convert between column numbers and column references using VBA in Microsoft Excel
Delete Tip from MyTips Summing Stock Lists in Excel 2007
Delete Tip from MyTips Averaging Values that Correspond with the X Largest Values in a Dynamic Range
Delete Tip from MyTips Remove Duplicate Rows in Excel 2007
Delete Tip from MyTips Multiplying time values and numbers.
Delete Tip from MyTips Creating Subtotals Summary in Excel 2007
Delete Tip from MyTips Using the Keyboard to Select Chart Items in Microsoft Excel
Delete Tip from MyTips Export data from Excel to Access (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
Delete Tip from MyTips Defer an Automatically Update of PivotTable Layout Report in Excel 2007
Delete Tip from MyTips Selecting cells that only contain Text in Microsoft Excel
Delete Tip from MyTips Retrieving the Value of the First Nonblank Cell in a List
Delete Tip from MyTips Copying Formulas and Pasting Them in a Transposed Direction Without Changing the Relative References
  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