|  

» 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 Changing a Numeric Heading to Text
Delete Tip from MyTips Pass arguments to macros from buttons and menus using VBA in Microsoft Excel
Delete Tip from MyTips Create and Add a Function for Reversed Text Characters in Microsoft Excel
Delete Tip from MyTips Reset filter before saving a worksheet using VBA in Microsoft Excel
Delete Tip from MyTips Opening a Linked Workbook in Microsoft Excel
Delete Tip from MyTips Using Loops in VBA in Microsoft Excel
Delete Tip from MyTips Preventing Moving to the Next Cell After Typing
Delete Tip from MyTips Selecting cells that only contain Text in Microsoft Excel
Delete Tip from MyTips Formatting a Negative Number with Parentheses
Delete Tip from MyTips List all the workbook links in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Deleting Empty Rows
Delete Tip from MyTips Use VLOOKUP Function as an alternative to a number of nested IF functions.
Delete Tip from MyTips Show the full name ( path and workbook name ) in the menu bar in Microsoft Excel
Delete Tip from MyTips Summing Sales Amounts According to Product Category and Customer Name
Delete Tip from MyTips Copying the Page Setup to Other Sheets
Delete Tip from MyTips Creating List Objects
Delete Tip from MyTips Retrieve information from a range in another Excel File when the Path & File Name strings stored in various cells.
Delete Tip from MyTips Automatically Refreshing a PivotTable Report
Delete Tip from MyTips Search, enter, and delete values using VBA in Microsoft Excel
Delete Tip from MyTips Hiding the Display of Zero Values
Delete Tip from MyTips Retrieving Every Nth Value in a Range
Delete Tip from MyTips Hiding Outline Symbols
Delete Tip from MyTips Calculating the Week Number
Delete Tip from MyTips The Best Shortcut Keys in Microsoft Excel
Delete Tip from MyTips Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
Delete Tip from MyTips Sorting Rules & List Structure
Delete Tip from MyTips Usando la Función Redondear para Redondear Números a Miles
Delete Tip from MyTips Change the cell formatted from date format to number format in Microsoft Excel
Delete Tip from MyTips Problem: Date Formatting Cannot Be Changed
Delete Tip from MyTips Determining whether Two Given Dates Occur within the Same Week
Delete Tip from MyTips Separtaing A String Into Substrings.
Delete Tip from MyTips Mail the Activeworkbook using VBA in Microsoft Excel
Delete Tip from MyTips Avoiding Problems when Numeric Values are used as Text
Delete Tip from MyTips Creating Charts with F11 in Microsoft Excel
Delete Tip from MyTips Splitting a Full Address into Three Separate Cells
Delete Tip from MyTips Getting Continuously Refreshed Data from a Web Site in Excel 2000
Delete Tip from MyTips Let Excel Read Text for You
Delete Tip from MyTips Selecting/Formatting Cells Containing Errors
Delete Tip from MyTips Problem: Unnecessary Empty Characters in Cells
Delete Tip from MyTips Changing the Cell Comment Shape
Delete Tip from MyTips Ranking Numbers in a Dynamic List
Delete Tip from MyTips Change the value/content of several UserForm-controls using VBA in Microsoft Excel
Delete Tip from MyTips Search value in external workbook and paste with format style using VBA in Microsoft Excel
Delete Tip from MyTips Pivot Table - Grouping dates by weeks in Microsoft Excel
Delete Tip from MyTips Nesting OR & AND Functions to Meet Multiple Criteria
Delete Tip from MyTips Rounding Time Intervals to the Nearest Specified Time Increment
Delete Tip from MyTips Converting Time to Decimal Values
Delete Tip from MyTips Protecting and Unprotecting Workbooks in Microsoft Excel
Delete Tip from MyTips How to Use Your Excel Add-In Functions in VBA
Delete Tip from MyTips Separating Positive and Negative numbers and add Running Balance column
Delete Tip from MyTips Working Out a Person's Age in Microsoft Excel
Delete Tip from MyTips Coloring Gridlines
Delete Tip from MyTips Separating a Number Into Digits
Delete Tip from MyTips Retrieving Data from a PivotTable Report
Delete Tip from MyTips Quitando el Indicador de Etiqueta Inteligente
Delete Tip from MyTips Calculating the Average of a Range of Numbers, Excluding the Minimal Value
Delete Tip from MyTips Copy a range from each workbook with a file name starting with ? in a folder using VBA in Microsoft Excel
Delete Tip from MyTips Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
Delete Tip from MyTips Print multiple selections on one sheet using VBA in Microsoft Excel
Delete Tip from MyTips Deleting a Range Name
Delete Tip from MyTips Entering Formulas in a Quicker Way by Shortening Sheet Names in Excel 2007
Delete Tip from MyTips Determining Whether a Worked Shift Was Morning, Afternoon or Night
Delete Tip from MyTips Rounding Numbers that Meet Specified Criteria
Delete Tip from MyTips Calculating the Number of Weekday Hours Between Two Dates
Delete Tip from MyTips Filtering by the Date Field
Delete Tip from MyTips Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Week Number Corresponding with a Specific Date
Delete Tip from MyTips Sorting Sheets in Ascending Order
Delete Tip from MyTips Displaying Figures in Financial Reports Rounded to Thousands
Delete Tip from MyTips Writing Your First VBA Function in Excel
Delete Tip from MyTips Change range with more then Area to values using VBA in Microsoft Excel
Delete Tip from MyTips Rounding Numbers to Millions with Thousands as a Decimal
Delete Tip from MyTips PDF2XL Enterprise
Delete Tip from MyTips Creating a Date and Time Matrix
Delete Tip from MyTips Adding the Auto Outline, Clear Outline, and Show Outline Symbols Icons to the Toolbar
Delete Tip from MyTips Add Group and Outline in Excel 2007
Delete Tip from MyTips Problem: The Minus Sign Appears to the Right of the Number
Delete Tip from MyTips Restore the VBE windows to their default positions using VBA in Microsoft Excel
Delete Tip from MyTips Filtering a Range into a List of Unique Records
Delete Tip from MyTips Display a CommandBar centered on the screen using VBA in Microsoft Excel
Delete Tip from MyTips Summing Values from Two Ranges, Based on Two Criteria
Delete Tip from MyTips Funcionalidades Expandidas de Pegado de Íconos en Excel 2002 y Excel 2003
Delete Tip from MyTips Updating Charts by Dragging and Dropping in Microsoft Excel
Delete Tip from MyTips Ignoring Blank Cells when Performing Calculations
Delete Tip from MyTips Calculations with one thousandth fractions of seconds by Custom Function using VBA
Delete Tip from MyTips Selecting a Column(s) or Row(s) Using Keyboard Shortcuts
Delete Tip from MyTips Avoiding Error Displays when Formulas Return Result Calculations
Delete Tip from MyTips Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
Delete Tip from MyTips Prevent a UserForm from closing when the user clicks the x-button using VBA in Microsoft Excel
Delete Tip from MyTips Adding the Properties Icon to the Standard Toolbar
Delete Tip from MyTips Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
Delete Tip from MyTips Worksheet events using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Default Style in Excel 2007
Delete Tip from MyTips Build an Excel Add-In in Microsoft Excel
Delete Tip from MyTips Create User Forms in Microsoft Excel
Delete Tip from MyTips Drawing Lines Between Sorted Groups
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Week Number
Delete Tip from MyTips Creating a Counting Grid
Delete Tip from MyTips To Fill Values Right or Down in a List in Excel 2007
Delete Tip from MyTips Changing the Source Link
Delete Tip from MyTips Add Combo Box to a Sheet in Microsoft Excel
Delete Tip from MyTips Retrieving the Cell Address of the Largest Value in a Range
Delete Tip from MyTips Userdefined functions from other workbooks using VBA in Microsoft Excel
Delete Tip from MyTips Calculate number of minutes between dates - time in Microsoft Excel
Delete Tip from MyTips Moving Between Open Workbooks
Delete Tip from MyTips Add content to a module from a file using VBA in Microsoft Excel
Delete Tip from MyTips Calculating the Week Number Corresponding with a Specific Date
Delete Tip from MyTips Copiando y Pegando el Contenido de una Celda en Miles de Celdas
Delete Tip from MyTips Sum total stock value for any part in Microsoft Excel
Delete Tip from MyTips Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
Delete Tip from MyTips Copy row heights and column widths using VBA 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 Comparing Lists Using the COUNTIF Formula
Delete Tip from MyTips Change the default printer using VBA in Microsoft Excel
Delete Tip from MyTips Subtotal Ribbon in Excel 2007
Delete Tip from MyTips Convert between column numbers and column references using VBA in Microsoft Excel
Delete Tip from MyTips Enter the holiday according to the Table in the holiday-list using VBA
Delete Tip from MyTips Linking a Cell to a Text Box
Delete Tip from MyTips Multiplying Values from Two Matrixes that Occupy Corresponding Addresses
Delete Tip from MyTips PivotTable report - Grouping the Date Field by Quarters in a Fiscal Reporting Year
Delete Tip from MyTips Adding Time Values from Separate Hours and Minutes Columns
Delete Tip from MyTips Using Different Functions to Consolidate Lists
Delete Tip from MyTips Use Smart Tag to fill series of dates in Microsoft Excel
Delete Tip from MyTips Retrieving a Price Value by Looking at Two Difference Data Tables
Delete Tip from MyTips Playing MIDI-files using VBA in Microsoft Excel
Delete Tip from MyTips Fast Copying & Pasting in Adjacent Cells
Delete Tip from MyTips Find the maximum numerical value in a list based on a criteria in Microsoft Excel
Delete Tip from MyTips Validating Data To Be Unique In A Range
Delete Tip from MyTips Formulas to calculate Loan payments in Microsoft Excel
Delete Tip from MyTips Retrieving a Value from a PivotTable Report in Excel 2007
Delete Tip from MyTips Format number in joining text with linked number in Microsoft Excel
Delete Tip from MyTips Calculate commission percentage based on a commission schedule in Microsoft Excel
Delete Tip from MyTips E-mailing an Excel Workbook, Sheet, Data or Chart
Delete Tip from MyTips Adding a Custom Function That Returns the Quarter Number
Delete Tip from MyTips Determine if a sheet exists in a workbook using VBA in Microsoft Excel
Delete Tip from MyTips Compare two worksheet ranges using VBA in Microsoft Excel
Delete Tip from MyTips Changing the Standard Font
Delete Tip from MyTips Copying Formatting in Excel 2007
Delete Tip from MyTips Pasting Multiple Copied Ranges Using the Clipboard
Delete Tip from MyTips Create a hyperlink from a string in Microsoft Excel
Delete Tip from MyTips Selecting a Sheet from a Sorted Sheets List
Delete Tip from MyTips Adding Euro format to the number format in Microsoft Excel
Delete Tip from MyTips Calculating Total Time Worked on a Specific Day
Delete Tip from MyTips Encoding a Sequence of Letters
Delete Tip from MyTips Copying Formulas and Pasting Them in a Transposed Direction Without Changing the Relative References
Delete Tip from MyTips Change the cursor appearance to hourglass using VBA in Microsoft Excel
Delete Tip from MyTips Returning the Entire Contents of the Row Containing the Highest Math Grade
Delete Tip from MyTips Insert/Delete a Row/a Column in Excel 2007
Delete Tip from MyTips Display AutoFilter criteria after filtering using VBA in Microsoft Excel
Delete Tip from MyTips Workbook events using VBA in Microsoft Excel
Delete Tip from MyTips Multiplying a Range by -1 in One Operation
Delete Tip from MyTips Add a procedure to a module using VBA in Microsoft Excel
Delete Tip from MyTips Determining Which Quarter a Specified Date Corresponds With
Delete Tip from MyTips Sorting Options in Excel 2007
Delete Tip from MyTips Problem: Date Formatting Cannot Be Changed in Excel 2007
Delete Tip from MyTips Private Profile Strings using INI-files 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 Displaying Formula Syntax
Delete Tip from MyTips Summing the Visible Filtered List
Delete Tip from MyTips Retrieving Values Using Range Names as References
Delete Tip from MyTips Eliminate screen flashing while running a macro using VBA in in Microsoft Excel
Delete Tip from MyTips Add unique values using VBA in Microsoft Excel
Delete Tip from MyTips Performing a Quick Calculation in the Formula Bar
Delete Tip from MyTips Combining Text and a Formatted Date into a Single Entity
Delete Tip from MyTips Copying/Moving a Cell(s) Between Sheets/Workbooks
Delete Tip from MyTips Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel
Delete Tip from MyTips Identifying Duplicate Rows within a Range
Delete Tip from MyTips Add and Save new Workbook using VBA in Microsoft Excel
Delete Tip from MyTips Transposing a Column into Successive Rows of a Specified Length
Delete Tip from MyTips Copying/Moving a Cell(s) Between Sheets/Workbooks in Excel 2007
Delete Tip from MyTips Highlight a selected range with a MsgBox using VBA in Microsoft Excel
Delete Tip from MyTips Identifying the Case of Letters within Strings
Delete Tip from MyTips Find the Alphabetically Lowest Letter in a List
Delete Tip from MyTips Watch Calculation Results Immediately in Excel 2007
Delete Tip from MyTips Inserting Subtotals Quickly
Delete Tip from MyTips Displaying the Serial Number Behind the Date
Delete Tip from MyTips Adding a Picture to a Header/Footer
Delete Tip from MyTips Copying or Applying Color to Groups and Outlines in Excel 2007
Delete Tip from MyTips Unnecessary Blank Characters in Cells in Excel 2007
Delete Tip from MyTips Insert headers and footers using VBA 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