|  

» 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 Let Excel Read Text for You
Delete Tip from MyTips Change a Column or Columns to values using VBA in Microsoft Excel
Delete Tip from MyTips Save a workbook backup using VBA in Microsoft Excel
Delete Tip from MyTips Selecting a Sheet from a Sorted Sheets List
Delete Tip from MyTips Change the selection with one or more areas to Values using VBA in Microsoft Excel
Delete Tip from MyTips Function for returning the user name using VBA in Microsoft Excel
Delete Tip from MyTips Delete a module using VBA in Microsoft Excel
Delete Tip from MyTips Entering the Current Date into a Cell
Delete Tip from MyTips Reducing the Workbook Size for Quick Sending via E Mail
Delete Tip from MyTips Print multiple selections on one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Calculate number of minutes between dates - time in Microsoft Excel
Delete Tip from MyTips Rounding a Value to Make It Divisible by a Specified Number
Delete Tip from MyTips Calculating the Average of Every Nth Value
Delete Tip from MyTips Change the default printer using VBA in Microsoft Excel
Delete Tip from MyTips Copying a Formula from a Cell While Keeping the Absolute Reference or Relative Reference
Delete Tip from MyTips Compare two worksheet ranges using VBA in Microsoft Excel
Delete Tip from MyTips Get the Row number of the last non blank cell in a column in Microsoft Excel
Delete Tip from MyTips Adding a Combo Box
Delete Tip from MyTips Summing using multiple criteria in Microsoft Excel
Delete Tip from MyTips Filtering by the Date Field
Delete Tip from MyTips Summing Values from Cells in Different Sheets
Delete Tip from MyTips Autoexpanding a Date Type Chart using Microsoft Excel
Delete Tip from MyTips Retrieving the First Value in a List that is Greater / Smaller than a Specified Number
Delete Tip from MyTips Formatting Cells Containing Formulas
Delete Tip from MyTips Deleting a Range Name in Excel 2007
Delete Tip from MyTips Saving a Customized Workbook as a Template
Delete Tip from MyTips Extracting Characters from Text Using Text Formulas
Delete Tip from MyTips Put a line at Foot of print page
Delete Tip from MyTips Summing Sales Amounts According to Product Category and Customer Name
Delete Tip from MyTips Performing Numeric Operations on Substrings
Delete Tip from MyTips Transposing a Column into Successive Rows of a Specified Length
Delete Tip from MyTips PivotTable report - Adding a Data Field That Calculates Percentage Difference from the Previous Item
Delete Tip from MyTips Using the COUNT Functions
Delete Tip from MyTips Retrieving a Price Value By Looking at Two Difference Data Tables
Delete Tip from MyTips Coloring Numbers Based on Specific Criteria Using Conditional Formatting
Delete Tip from MyTips Using a Workspace to Open a Number of Workbooks at Once in Excel 2007
Delete Tip from MyTips Show/Hide Field Header in Excel 2007
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 Finding Minimum / Maximum Values
Delete Tip from MyTips Parsing text to the right of a search criteria - delimiter in Microsoft Excel
Delete Tip from MyTips Increasing/Decreasing the Screen Magnification Percentage
Delete Tip from MyTips Delete a procedure from a module using VBA in Microsoft Excel
Delete Tip from MyTips Change slash separator in date with period in Microsoft Excel
Delete Tip from MyTips Counting the Number of Cells Containing Text in a Range
Delete Tip from MyTips Using multiple criteria in SUMIF Function
Delete Tip from MyTips Auto-Recovering/ Auto-Saving a Workbook
Delete Tip from MyTips Problem: Unnecessary Empty Characters in Cells
Delete Tip from MyTips Finding Every Third Number and Returning the Largest of Them
Delete Tip from MyTips Determine if an application is available using VBA in Microsoft Excel
Delete Tip from MyTips Copy Selection to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in All Sheets
Delete Tip from MyTips Launch Word file from Excel VBA
Delete Tip from MyTips Adding a Shortcut for Wrapping Text
Delete Tip from MyTips Values Not Formatted as Numbers in Excel 2007
Delete Tip from MyTips Circular References
Delete Tip from MyTips Calculate holidays using VBA in Microsoft Excel
Delete Tip from MyTips Adding special symbols to the number format in Microsoft Excel
Delete Tip from MyTips Correcting Formatting Errors
Delete Tip from MyTips Retrieving a Specific Cell from Multiple Sheets
Delete Tip from MyTips Adding Continuous Page Numbers While Printing
Delete Tip from MyTips Look up unique values using VBA in Microsoft Excel
Delete Tip from MyTips Combining Text and Numerically Calculated Results into One Output String
Delete Tip from MyTips Eliminando Iconos que Realizan Dos Tareas Diferentes
Delete Tip from MyTips Calculating the Average of Every Nth Value, Excluding Zeros
Delete Tip from MyTips Sort by birthday using VBA in Microsoft Excel
Delete Tip from MyTips Sum Total Sales Except for One Specified Item
Delete Tip from MyTips Forecasting Daily Budget
Delete Tip from MyTips Retrieving the Value of the First Nonblank Cell in a List
Delete Tip from MyTips Retrieving Sale Price Based on Item and Color Criteria
Delete Tip from MyTips Coloring and Filtering Lists According to Criteria
Delete Tip from MyTips Calculating the Date at the End of a Month
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 Retrieving an Item from a List that Meets Multiple Criteria
Delete Tip from MyTips Canceling the Update Links Message While Opening a Linked Workbook
Delete Tip from MyTips Set up yellow background color for header in an AutoFilter table using VBA in Microsoft Excel
Delete Tip from MyTips Count by color using VBA in Microsoft Excel
Delete Tip from MyTips Creating email address
Delete Tip from MyTips Preventing charts from being printed in Microsoft Excel
Delete Tip from MyTips Altering the results returned by VLOOKUP.
Delete Tip from MyTips Adding the Custom Views Icon to the Excel Menu Bar
Delete Tip from MyTips Copy a Row or Rows to a Database sheet using VBA in Microsoft Excel
Delete Tip from MyTips Summing values in vertical and horizontal ranges in Microsoft Excel
Delete Tip from MyTips Applying Formatting to Cells Containing Text Only in Excel 2007
Delete Tip from MyTips Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
Delete Tip from MyTips Export data from Excel to Access (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips The Power Combination
Delete Tip from MyTips Unintentionally Creating Links between Workbooks in Excel 2007
Delete Tip from MyTips Seleccionando un Rango de Celdas No Adyacentes
Delete Tip from MyTips Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates
Delete Tip from MyTips Rounding Numbers to Millions
Delete Tip from MyTips Retrieving the Cell Address of the Largest Value in a Range
Delete Tip from MyTips Grouping/ Ungrouping Sheets
Delete Tip from MyTips Applying Colors to Subtotal Rows in Excel 2007
Delete Tip from MyTips Delete module content using VBA in Microsoft Excel
Delete Tip from MyTips Avoiding Negative Values when Calculating the Number of Days between Two Dates
Delete Tip from MyTips Getting Drill-Down Details
Delete Tip from MyTips Displaying the Format Cells Dialog Box
Delete Tip from MyTips Copy a column or columns from each sheet into one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Quickly Entering Text into Cells from a List of Previous Entries or a Validation List in Excel 2007
Delete Tip from MyTips Range Name Syntax
Delete Tip from MyTips Combining Text and a Formatted Date
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 Getting Continuously Refreshed Data from a Web Site in Excel 97
Delete Tip from MyTips Color numbers based on the value result in Microsoft Excel
Delete Tip from MyTips Applying Formatting Only to Cells Containing Text
Delete Tip from MyTips Inserting a Chart in Excel 2007
Delete Tip from MyTips Userdefined functions from other workbooks 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 Sorting Options in Excel 2007
Delete Tip from MyTips Change the state of a custom CommandBar button using VBA in Microsoft Excel
Delete Tip from MyTips Creating a List in which Each Number is the Sum of the Previous N Numbers
Delete Tip from MyTips Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
Delete Tip from MyTips Identifying the Case of Letters within Strings
Delete Tip from MyTips Calculating Total Income Tax
Delete Tip from MyTips Breaking Links Between Workbooks
Delete Tip from MyTips Displaying Figures in Financial Reports Rounded to Thousands
Delete Tip from MyTips Symbols Used to Create Custom Formatting
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 Printing a Filtered List
Delete Tip from MyTips Calculating Time Differences Between Regions of the World
Delete Tip from MyTips Count the number of cells in a range in Microsoft Excel
Delete Tip from MyTips Calculating Number of Days, Weeks, Months and Years between Dates
Delete Tip from MyTips Counting Date Values by Specified Date Criteria
Delete Tip from MyTips Summing from Closed Workbooks
Delete Tip from MyTips Checking For Duplicate Values Within A Range
Delete Tip from MyTips Retrieving the Column Header of the Next Non-Blank Cell in a Row
Delete Tip from MyTips Set the Background Color according to the date using VBA in Microsoft Excel
Delete Tip from MyTips Printing Each Subtotal Group on a Separate Page in Excel 2007
Delete Tip from MyTips Checking For Sequences Within A Sorted List
Delete Tip from MyTips Changing the Name of the Cell Comments Author in Excel 2007
Delete Tip from MyTips Converting Uppercase Letters to Lowercase
Delete Tip from MyTips Worksheet events 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 Create eventmacros for the Application object using VBA in Microsoft Excel
Delete Tip from MyTips Finding/Finding & Replacing in a Single Sheet or in Entire Workbook in Excel 2007
Delete Tip from MyTips Inserting Subtotals Quickly
Delete Tip from MyTips Performing calculations based on multiple criteria, using SUMPRODUCT function
Delete Tip from MyTips An Improved Custom Random Numbers Function
Delete Tip from MyTips Copying Formatting
Delete Tip from MyTips Create an Amortization Schedule in Microsoft Excel
Delete Tip from MyTips Splitting a Full Address into Three Separate Cells
Delete Tip from MyTips Calculating the Week Number
Delete Tip from MyTips Converting Text to Its Proper Case
Delete Tip from MyTips Counting the Number of Times Any of the Numbers in First List Appears within Second List
Delete Tip from MyTips Using a Picture to Watch Cell Values in Other Sheets
Delete Tip from MyTips Adding a Custom Keyboard Shortcut
Delete Tip from MyTips Creating a Timesheet
Delete Tip from MyTips Funcionalidades Expandidas de Pegado de Íconos en Excel 2002 y Excel 2003
Delete Tip from MyTips Adding Time Values
Delete Tip from MyTips Automatically Defining Names for Ranges in Lists
Delete Tip from MyTips Format even numbers
Delete Tip from MyTips Copying & Pasting Cell Content Along with Formatting
Delete Tip from MyTips Calculating the Date of the Nth Specific Day of the Month
Delete Tip from MyTips Adding a Picture to a Header/Footer in Excel 2007
Delete Tip from MyTips Hiding the Display of Zero Values in Excel 2007
Delete Tip from MyTips Count unique values using VBA in Microsoft Excel
Delete Tip from MyTips Validating Text Entries in Excel 2007
Delete Tip from MyTips Usando la Validación de Mensaje Entrante como un Comentario de Celda
Delete Tip from MyTips Seleccionando Rápidamente un Rango de Celdas
Delete Tip from MyTips Private Profile Strings using Words System.PrivateProfileString using VBA in Microsoft Excel
Delete Tip from MyTips Manually Wrapping Text in a Cell
Delete Tip from MyTips Dual Monitors - Trouble Displaying separate spreadsheets on each Monitor
Delete Tip from MyTips Retrieving the Last Value in a Dynamic List
Delete Tip from MyTips Validando Datos de Texto
Delete Tip from MyTips Log files using VBA in Microsoft Excel
Delete Tip from MyTips Print a Table in Excel 2007
Delete Tip from MyTips Preventing Duplicates When Entering Data
Delete Tip from MyTips Displaying Numbers in Thousands in a Chart in Microsoft Excel
Delete Tip from MyTips Avoiding Error Displays when Formulas Return Result Calculations
Delete Tip from MyTips How to find the minimum value in range while ignoring 0 value in Microsoft Excel
Delete Tip from MyTips Function for returning the computer name using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values Based on the Criteria of a Non-Empty Adjacent Cell
Delete Tip from MyTips Open data in two dimensional array and save in sheet using VBA in Microsoft Excel
Delete Tip from MyTips Quickly Removing Subtotals in Excel 2007
Delete Tip from MyTips Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
Delete Tip from MyTips Password to prevent opening a workbook in Microsoft Excel
Delete Tip from MyTips Copying the Subtotals Summary
Delete Tip from MyTips Hiding Items
Delete Tip from MyTips Determining Whether a Person Worked a Full or Partial Shift
Delete Tip from MyTips Converting a Decimal Value to a Time Value
Delete Tip from MyTips Checking for Duplicate Values within a Range
Delete Tip from MyTips Combining Text and Formatted Values
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Opening/Closing a Workbook(s)
Delete Tip from MyTips Format table depending on number formats using VBA in Microsoft Excel
Delete Tip from MyTips Count the number of values between a lower and upper limit in Microsoft Excel
Delete Tip from MyTips Coloring Visible Rows in Filtered List in Excel 2007
Delete Tip from MyTips Summing Groups of Every N Values in a Row
Delete Tip from MyTips Copying Cell Content Across Sheets
Delete Tip from MyTips Extracting a substring
Delete Tip from MyTips Add space between characters and numbers in Microsoft Excel
Delete Tip from MyTips Disregarding blank cells when performing calculations on a range.
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Copying and Pasting Validation list only in Microsoft Excel
  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