Improve Your Excel.com
Everything you need to improve your Excel in one place!
Home Categories Tips By Email Search Contact Us Other Links Your Questions Answered

  • How To Disable Hyperlink Warning Messages In Excel 2003



  • A Quick Solution With Goal Seek


  • Add A New Window For A Better View


  • An Alternative To Cell Comments


  • AutoFit Columns Based On Selected Cells Only


  • Avoid Numeric Heading Errors In Your Formulas


  • Bullet Lists In Excel


  • Change The Format Of Excel's Comments


  • Change The Header or Footer Font


  • Cool Formatting In Four Clicks


  • Copy Column Widths To Another Sheet


  • Create 3D Effects With Your Cells


  • Create A Hyperlink To Another Workbook


  • Create A Linked Picture Of A Range Of Cells


  • Creating A Custom Number Format


  • Custom Auto Fill - Wow! That's cool!


  • Display Values With Dollars And Cents Symbols


  • Easily Center Your Report Headings


  • Easily Duplicate Cell Formatting


  • Editing A Range Within A Formula By Dragging


  • Email That Excel Workbook Fast


  • Extracting Unique Items From Data In A Column


  • Fast Editing Using Your Keyboard


  • Hiding Unused Rows And Coluumns


  • How To Avoid #DIV/0! Errors


  • How To Center Numbers And Still Keep Decimals Aligned


  • How To Combine Text in Cells


  • How To Create A Table Of Contents In Excel


  • How To Create Cumulative Totals


  • How To Create Vertical Titles For Your Reports


  • How To Display A User Input Message


  • How To Find and Replace Wildcard Characters (* ?)


  • How To Password Protect A Workbook


  • How To Paste A Hyperlink


  • How To Use Excel's IF Function


  • How To Use Fractions In Excel


  • How To Use Named Ranges


  • Indent Text Without Adding Extra Spaces


  • It Doesn't Add Up Without Rounding !


  • Keep Those Headings Visible


  • Learn To Function Smarter


  • Move Formulas Without Changing Their Relative References


  • Page Break Preview


  • Pasting Part Of Your Worksheet To Another Document


  • Prevent Duplicate Entries In A Range


  • Preventing The Display Of Zeros


  • Print The Same Cell Range On Multiple Excel Worksheets


  • Print Your Report Headings On Every Page


  • Quickly Convert Text To Lower Case


  • Quickly Delete Blank Rows From A Long List


  • Report Your Numbers In Thousands


  • Rotate Your Column Headings


  • Round Numbers To The Nearest 1000


  • Showing Just The Day Of The Week


  • Spice Up Your Worksheet With A Picture Or Two


  • Sum Only Data That Meets A Condition You Specify


  • Tabbing Through Input Cells


  • The Fill Handle Secret


  • The Secret Of Pasting Multiple Items In One Step


  • Use Autoshapes To Highlight Information


  • Use Linked AutoShapes To Make Your Data Really Stand Out


  • Using Headers and Footers


  • Display Text In A Cell On Multiple Lines


  • 2006 Excel User Conference


  • 5 power tips for Microsoft Excel 2002


  • 5 tips for working with multiple worksheets in Excel


  • Activating a Hyperlink


  • Add visual appeal through background shading in Word


  • Adding a Macro to a Toolbar


  • Adding Buttons to Your Worksheet


  • Adding the Set Print Area Tool


  • Adjust row heights to make Excel spreadsheets easier to read


  • Adjusting Values with Formulas


  • Administration of shared workbooks


  • Advanced Gantt Charts in Microsoft Excel (updated)


  • Anchor controls and resizing userform


  • Announcing: Excel Name Manager 4.0 Beta


  • Announcing: Name Manager 4.0 for Excel 2007


  • Announcing: Release of Autosafe 3.5


  • Applying a Style


  • Arbitrary Gridlines and Axis Labels


  • Area Combination Chart for Monthly Temperatures


  • Assign Qualified Employees to Single Task Per Day


  • Assigning a Macro to a Keyboard Combination


  • Autosafe Update: Auto-update included.


  • Axis Label Cut Off


  • Better Use of Heading Space


  • Books on Excel.


  • Box and Whisker Plots - Update


  • Box and Whisker Plots - Updated Utility


  • Box and Whisker Plots and Utility - Updated


  • Broken Y Axis - Updated


  • Build TOC Another Approach


  • Business Productivity User Group Meeting


  • Calculating the Day of the Year


  • Calculating the Interval Between Occurrences


  • Calculating Week-Ending Dates


  • Calculation Problems When Custom Function Creates a Defined Name


  • Canceling an Edit


  • Catching Paste Operations


  • Catching Paste Operations


  • Category / Excel Help


  • Category / Excel Resources


  • Category / FinancialFunctions


  • Change Multiple Page Fields


  • Change Page Fields With Cell Dropdown


  • Change Page Fields With Cell Dropdown


  • Change Series Formula - Updated Utility


  • Change your Excel worksheet defaults to fit your working environment


  • Changing Cell References


  • Changing Column Width


  • Changing Directories in a Macro


  • Changing Excel''s Starting Date


  • Changing Months in a Workbook


  • Changing the number of sheets in a new workbook


  • Changing the Starting Page Number


  • Changing the text size in Excel's Help


  • Chart Pattern Fills Add-In


  • Chart Types Not Native to Microsoft Excel


  • Charting Dynamic Normalized Ranges


  • Cleaning Text


  • Clearing the Print Area


  • Clearing the Undo Stack in a Macro


  • Close all workbooks quickly


  • Colors and Fonts for Worksheet Tabs


  • Combination Charts for Monthly Temperatures


  • Combining Cell Contents


  • Compare workbook data side-by-side with Excel 2003


  • Comparing Lists for Duplicates


  • Concatenate with Separators and Quotes with Exclude !


  • Conditional highlighting axis labels


  • Contingent Validation Lists


  • Continuing Macro Lines


  • Controlling Display of the Scroll Bars


  • Controlling the Display of Toolbars


  • Controlling the Printer in a Macro


  • Convert Numbers to Words


  • Convert Numbers to Words


  • Convert trailing minus signs


  • Converting an Unsupported Date Format


  • Converting Mainframe Date Formats


  • Converting Numbers to Strings


  • Converting Time Notation to Decimal Notation


  • Converting to Hexadecimal


  • Converting Units


  • Copy an Excel formula without changing its cell references


  • Copy Page Setup settings to other sheets


  • Copying a Cell without Formatting


  • Count Text or Numeric Entries with COUNTA instead of COUNT


  • Counting Cells with specific content


  • Counting Colors of Cells


  • Counting Non-Blank Cells


  • Counting Only Money Winners


  • Counting Precedents and Dependents


  • Create a number format that displays leading zeroes in Excel


  • Create a SharePoint Team Services list with Excel


  • Create Calculated Items and Fields


  • Create Calculated Items and Fields


  • Creating a CSV File


  • Creating a Directory in a Macro


  • Creating An Undo Handler To Undo Changes Done By Excel VBA


  • Creating Paired Comparison Charts in Microsoft Excel


  • Creating Styles


  • Data Validation Lookup


  • Data Validation Lookup


  • De formules in een tabel transponeren


  • Defining and Using Custom Colors


  • Delays in Saving Workbooks


  • Deleting a Chart


  • Deleting a Hyperlink


  • Deleting a View


  • Deriving an Absolute Value in a Macro


  • Determining a Value of a Cell


  • Determining Combinations to Make a Total


  • Determining the Hour of the Day


  • Determining the Length of a Text File


  • Develop Macros In Their Own Workbook


  • Deviation Column Charts


  • Display Comment Text


  • Display Comment Text


  • Displaying a Hidden First Column


  • Displaying Path Names in the Menu Bar


  • Does Tablet-PC rime with Excel ?


  • Dokken van vensters in de VBE


  • Dot Plots and Utility


  • Dot Plotter Utility - Updated


  • Download examples of Excel forms


  • Drawing Lines


  • Drawing Simple Objects


  • Easily Adding Blank Rows


  • Easily Deploying Customizations


  • Easy Value Hiding


  • Editing Custom Dictionaries


  • Editing Reports


  • Editing the Same Cell in Multiple Sheets


  • Elapsed Days as Years, Months and Days


  • Embedding an Excel Chart in a Word Document


  • End-of-Month Calculations


  • Entering Parameters in a Web Query


  • Establishing a FLOOR and CEILING


  • Evaluating job applicants in Excel


  • Excel -- Credit Card Transaction Tracker


  • Excel -- Named Ranges


  • Excel -- Navigation Toolbar for Workbook Sheets


  • Excel -- Survey Form With Option Button


  • Excel -- UserForm With ComboBoxes


  • Excel -- UserForm With ComboBoxes


  • Excel -- Worksheet Functions -- INDIRECT


  • Excel -- Worksheet Functions -- INDIRECT


  • Excel / DropDownLists


  • Excel calendar templates for 2004


  • Excel drop down lists


  • Excel Filters -- Advanced Filter


  • Excel Filters -- AutoFilter Basics


  • Excel Filters -- AutoFilter Tips


  • Excel Newsgroup Postings -- Selected Statistics


  • Excel Newsgroup Postings -- Selected Statistics -- Annual Totals


  • Excel Support Center


  • Excel VBA: Registering a User Defined Function with Excel.


  • Excel VBE Multiline Search And Replace.


  • Excel XY Chart Variations with VBA


  • Expiration Date for Excel Programs


  • Exporting a Graphics Group


  • Extracting Targeted Records from a List


  • F9 formula in the formula bar


  • Faster Text File Conversions


  • Figuring Out a Page Number


  • Filter All Columns


  • Filter All Columns


  • Filter Latest Date for Customer


  • Filter Latest Date for Customer


  • Filter Pivot Table from Worksheet Date Range


  • Filter Pivot Table from Worksheet Date Range


  • Filtering Columns for Unique Values


  • FinancialFunctions / DB


  • FinancialFunctions / HomePage


  • FinancialFunctions / SLN


  • FinancialFunctions / SYD


  • Find a perfect match in a lookup table in Excel


  • Finding and Deleting Links


  • Finding Wayward Links


  • Fixing "Can''t Find Files" Errors


  • Fixing Docking Of Windows In The VBE


  • Fixing Help


  • Fixing the Decimal Point


  • Flexfind for Excel 2007


  • Forcing Input to Uppercase


  • Forecast the future with Excel trendlines


  • Forget your password?


  • Formatting Raw Data


  • Formatting the Border of a Legend


  • Friendly and Informative Error Handling


  • Full Path Names in Headers or Footers


  • Generating a List of Macros


  • Generating a Web Page


  • Get Excel to calculate formulas with circular references


  • Getting 6 conditional font colors without macros


  • Getting Audible Feedback


  • Getting Rid of Non-Printing Characters Intelligently


  • Google Spreadsheets


  • Google Toolbar Slows Excel


  • Headings for Navigation


  • Headings for Navigation


  • Help using Excel spreadsheet functions - Offset, Choose


  • Help using Excel spreadsheet functions - vlookup, isna, match


  • Hide Excel's error values in your printout


  • Hide Marked Columns


  • Hide Marked Columns


  • Hiding Objects


  • Highlight row without losing color formatting


  • Highlighting the Rows of Selected Cells


  • History of Excel


  • How Excel Treats Disk Files


  • How Many Rows and Columns Have I Selected?


  • How Operators are Evaluated


  • How to AutoFilter Records Based on Cell Formatting


  • How to autoFilter Records Based on Cell Formatting in Excel 2000


  • How to calculate and display the largest value


  • How to call Excel Functions from Within Microsoft Access 2000


  • How to Create a Dynamic Named Range on a Worksheet in Excel


  • How to create a Link to a Worksheet within an Excel WorkBook in FrontPage 2000


  • How to Determine Top/Bottom Used Cells in a Sparse Array


  • How to eliminate redundant data in an Excel list


  • How to Perform a CaseSensitive Lookup


  • How to perform a TwoDimensional Lookup in Excel 2000


  • How to Rank Duplicate Values Sequentially


  • How to rank Duplicate Values Sequentially in Excel 2000


  • How to Return the First or Last Match in an Array


  • How to Select Cells/Ranges Using Visual Basic Procedures in Excel


  • How to Use INDEX and MATCH Worksheet Functions with Multiple Criteria


  • How to use the Excel Lookup Wizard (Lookup.xla) in Excel 2000


  • How to Use the INDIRECT Function to Create References


  • How to Use the LOOKUP Function


  • How to use the SUBTOTAL Function with AutoFiltered Lists in Excel 2000


  • How to Use the VLOOKUP Function


  • Icons on the worksheet in Excel


  • Importing a text file into a worksheet


  • Importing Custom Lists


  • Inconsistent Output for Empty Columns in a CSV File


  • Increasing Font Size In Worksheet Tabs


  • Index and Match instead of VLOOKUP?


  • Index of Help for Excel functions, graphs and testing


  • Insert Rows using a Macro


  • Inserting a Voice Annotation in Your Worksheet


  • Inserting and Deleting Rows in a Protected Worksheet


  • Inserting Different Dashes


  • Inserting references into online discussions in Excel


  • Inserting Rows


  • Inserting Symbols


  • Installing An Excel Add-in Using Setup Factory.


  • Interactivity on www.jkp-ads.com


  • Intersection points between line and circle


  • Invert if Negative


  • Jumping to Alphabetic Worksheets


  • Keep track of worksheet changes with Excel's shared worksheet feature


  • Large Toolbar Buttons


  • Let Excel be your calculator


  • Let Excel enter decimal points for you


  • Library Not Registered Error


  • Limit Data Validation Selection


  • Limit Data Validation Selection


  • Limiting Input to a Format


  • Listing an Object''s Properties and Methods


  • Locking Callouts to a Graph Location


  • Main / CreateLinks


  • Main / EditAnExistingPage


  • Main / RequestANewTopic


  • Main / WikiSandbox


  • Maintaining the Active Cell


  • Make Excel charts easier to read by adjusting data markers


  • Make Excel data easier to read with these tips


  • Make Excel worksheets and charts easier to read with custom number formats


  • Making a Cell''s Contents Bold within a Macro


  • Making a worksheet very hidden


  • Making an exact copy of a range of formulas


  • Making the Formula Bar Persistent


  • Manage your personal budget with Excel


  • Managing Comments


  • Members / Registration


  • Miscellaneous Code fragments of Worksheet functions


  • Move Items to Order Form


  • Move Items to Order Form


  • Moving a Worksheet to Another Workbook


  • Moving and Copying Cells


  • Moving and Copying Graphics Objects


  • Moving and Selecting Sheets With the Keyboard


  • Moving Cells Using the Mouse


  • Moving from Sheet to Sheet


  • Music Playlist Creator


  • Music Playlist Creator


  • Name Manager 4.0 for Excel 2007 RTM: Released


  • Name Manager 4.0: Bugfix


  • Name Manager 4.0: Small Bugfix


  • Navigating Excel's sheets


  • New Article: Getting a range from the user with VBA (Bug in Application.InputBox function)


  • New article: The New Excel 2007 File Format; Changing properties of Form controls


  • New download: CopyVBAProject for Excel VBA


  • New page: Excel Headlines


  • New Tool: RefTreeAnalyser


  • Non-Tiled Background Pictures


  • Nudging a Graphic


  • Number and List Comments


  • Number and List Comments


  • Odd Arrow Key Behavior


  • Opening a Recently Used Workbook


  • Opening a Workbook as Read-Only


  • Override Excel's Text Import Wizard


  • Overture Keyword Spreadsheet


  • Overview of Excel 2002 SP2 Update: October 16, 2002


  • Page update: Copy a range from closed workbooks (ADO)


  • Pagina bijgewerkt: Excel opstart Problemen oplossen


  • Panel Chart Example - Chart with Vertical Panels


  • Panel Charts with Different Scales


  • Parsing Non-Standard Date Formats


  • Pasting a Hyperlink


  • Pasting Leading Zeroes


  • Pausing Macros for User Input


  • Performing a Lookup with Unsorted Data in Excel


  • Pick your fantasy football team with Solver


  • Plan payments and savings with Excel


  • Plot an Equation.


  • PmWiki / BasicEditing


  • Positioning Headers and Footers


  • Prevent an Excel spreadsheet from displaying preliminary results


  • Prevent Excel spreadsheet headers and footers from printing over your data


  • Preventing Changes to Formatting and Page Size


  • Print Selected Items in an Order Form


  • Print Selected Items in an Order Form


  • Print Top Items


  • Printing a Chart


  • Printing a Chart Across Multiple Pages


  • Printing a Single Column in Multiple Columns


  • Professional Looking Fractions


  • Profiles / Hazz


  • Protecting cells, sheets, workbooks, and files


  • Protecting Excel Files from Word


  • Provide users with an easy-to-use toolbar for their Excel spreadsheets


  • Putting a Graphic in a Header or Footer


  • Putting Headers and Footers On Multiple Worksheets


  • Query Master


  • Query Master


  • Quick Chart VBA Examples


  • Quickly Changing Windows


  • Quickly Entering Data


  • Quickly Updating Values


  • Random Numbers


  • Reducing File Size


  • Refreshing Web Discussions


  • Relative References within Named Ranges


  • Remove Duplicate Pivot Caches


  • Remove Duplicate Pivot Caches


  • Remove internal worksheet/workbook protection


  • Remove personal Information from a workbook


  • Removing a Macro from a Shortcut Key


  • Renaming a Toolbar


  • Reordering Last Name and First Name


  • Repairing corrupted files in Excel


  • Reset Data Validation Cells


  • Reset Data Validation Cells


  • Reset the last cell of your Excel worksheet


  • Resetting Page Setup


  • Resize Excel's sheet tabs


  • Resizing a Drop-Down List


  • Resizing A4 worksheets for printing


  • Resources / Excel Help Forums


  • Resources / ExcelBlogs


  • Resources / ExcelForums


  • Resources / More


  • Resources / Other


  • Restrict cursor movement to unprotected cells


  • Returning the MODE of a Range


  • Returning Zero When a Referenced Cell is Blank


  • Reversing Cell Contents


  • Reversing Dimensions


  • Rounding to the Nearest $50


  • Rounding to the Nearest Half Dollar


  • Running a Macro When a Worksheet is Deactivated


  • Running a macro when Excel starts


  • Running a Procedure when a Workbook is Opened


  • Saving a text file to a Web server


  • Saving Common Formulas


  • Search for invalid data in your Excel file


  • Searching for Wildcards


  • Seating Plan


  • Seeing All Open Workbook Names


  • Selecting a Column


  • Selecting a Word


  • Selecting Random Names


  • Selectively Importing Records


  • Sequentially Inputting Information


  • Setting a Default File Format


  • Setting Column Width in a Macro


  • Setting Horizontal Alignment


  • Share your spreadsheets on the Web


  • Sharing AutoCorrect shortcuts


  • Sharing Your Workbook


  • Show or Hide Chart


  • Show or Hide Chart


  • Showing Filter Criteria on a Printout


  • Site / EditForm


  • SNAKECOLS, How to snake columns to use fewer pages


  • Software / ExcelAdd-Ins


  • Software / Sundera


  • Solver in VBA


  • Solving common setup problems


  • Sorting Files


  • Sorting ZIP Codes


  • Specifying an Order for Drawing Objects


  • Speech recognition commands in Excel


  • Speeding Up Printing


  • Sum values within a certain date range in Excel


  • Summarizing Data Examples (an Overview)


  • Synchronizing Lists


  • Taking Pictures


  • Task List and Calendar


  • Task List and Calendar


  • Taskbar Setting isn''t Sticky


  • Testing your spreadsheets - tips on good design


  • Text files: how to output custom format


  • The New Excel 2007 File Format, Working With Worksheet Data In An Excel 2007 File


  • Too Many Formats when Sorting


  • Toolbar Nuisances


  • Totaling Across Worksheets


  • Track your home remodeling costs with Excel


  • Track your progress with Excel and Word


  • Tracking career opportunities in Excel


  • Transposing the Formulas in a Table of Cells


  • Troubleshoot speech playback in Excel


  • Turning Off AutoFiltering


  • Turning Off Error Checking


  • Turning Off Names


  • Turning Off Sharing


  • Underlining


  • Understanding Conditional Formatting Conditions


  • Understanding Names


  • Understanding Outlining


  • Understanding Phantom Macros


  • Understanding Subroutines


  • Undo mogelijk maken voor macro''s in Excel VBA


  • Update to article ''Creating An Add-in From An Excel Macro.''


  • Update to AutosafeVBE


  • Update to AutosafeVBE: bugfix


  • Update to Fixing Excel problems page


  • Update to Flexfind: bugfix


  • Update to Setup utility.


  • Update to: Working with Tables in Excel 2007


  • Update: CopyVBAProject for Excel VBA (build 004)


  • Update: CopyVBAProject for Excel VBA (build 005)


  • Update: Excel Name Manager 4.0 Beta new build


  • Update: Name Manager (version 4.1, build 590)


  • Update: Updating an Excel Addin Through the Internet


  • Updating an Excel Addin Through the Internet


  • Use a function to count cells between two values in Excel


  • Use conditional formatting in Excel to identify data trends


  • Use Excel's formatting tools to attractively arrange charts on a sheet


  • Use Excel's MS Query Wizard to query Access databases


  • Use Excel's statistical functions to analyze data across worksheets


  • Use Filter by Selection to change query output in Access


  • Use Find to edit selected cells in an Excel worksheet all at once


  • Use Index and Match to lookup a cell to the left of your key cell


  • Use your mouse for special paste operations in Excel


  • Userform Clock


  • Using a Graphic for a Background


  • Using a Protected Worksheet


  • Using a workspace file


  • Using bar codes in Excel


  • Using Custom Number Formats


  • Using Data Forms


  • Using Drag-and-Drop to Create a Hyperlink


  • Using Excel with Other Office Applications (updated)


  • Using Multiple Print Settings


  • Using Parameters With Web Queries


  • Using Print Preview


  • Using Text Boxes


  • Using the COLUMN Function


  • Using the FORECAST Function


  • Using the Loan amortization and Loan analysis templates


  • Using the WEEKNUM Function


  • Viewing an XML file in Excel


  • Viewing Your Work Full-Screen


  • VLOOKUP Worksheet Function


  • Waterfall Charts and Utility - Updated


  • Waterfall Charts and Utility - Updated Utility


  • Web Site Redesign


  • Welcome to ExcelPragma.com !


  • Who Has the File Open?


  • Why use -- in SUMPRODUCT formulae


  • Why your sum is a penny off...


  • Workbook Events


  • Working While a Macro is Running


  • Working with Data Tables in Excel 2007


  • Working with Record Numbers


  • Working with Tables in Excel 2007 (VBA)


  • Worksheet Data Entry Form


  • Worksheet Data Entry Form


  • Wrap text in a cell


  • Wrapping Formulas In An Error Test


  • XML - Introductory Article on MSDN


  • XML en Excel 2003


    • Want more tips? Subscribe to our Free Newsletter today and we will send them to you.
    Most Popular Categories |Bar_Charts |Charts |Pie_Charts |Excel Counting |Excel Filters |Pivot_Tables |Excel_Keyboard_Shortcuts |Conditional_Formating |VLookup |Games |Names_and_ranges |VBA_Examples |Macros