• Create Your Own Personalized Quick Access Toolbar


• A Super-Quick Trick to Convert Formulas to Values


• Create Custom Default Worksheet And Workbook Templates


• How To Create A Personal Macro Workbook


• Calculate The Number Of Days Months Or Years Between Two Dates
  
  
• Fill The Gaps In Imported Data


• Stop Changing My (c) To A Copyright Symbol Damn It !


• Save a Workbook, a Worksheet or Just a Range of Cells as a PDF Document


• How To Create Simply-Amazing Hyperlinks


• Make Your Spreadsheet Fit Your Screen


• Display Your Quick Access Toolbar (QAT) Above or Below the Ribbon


• Create Your Own Custom AutoFill Lists


• Add A Dynamic Date Range Title To Your Report


• Help With Understanding Worksheet Functions


• How To Find The Last Value In A Row or Column


• Extract A Month's Name From A Date


• Count Cells That Include Specific Text


• The Format Painter Pattern Swipe


• How To Recover A Workbook That You Forgot To Save Changes To


• Quickly Identify Cells With Conditional Formatting


• How To Locate All Merged Cells On A Worksheet


• Access Your Recent List of Workbooks From the Windows Taskbar


• Find (and/or Replace) All Blanks Resulting From Formulas


• Prevent Auto Incrementing of Numbers


• Open the Last-Saved Version of an Open Workbook


• Printing Without Color


• How to Monitor Changes in Key Cells Throughout a Workbook


• It's Easier to Concatenate without CONCATENATE


• Use AutoCorrect to Quickly Recall Your Impossible-to-Remember, Complex Formulas


• How to Insert Degree Symbols in Your Worksheet


• View Data From Separate Areas of the Same Worksheet at the Same Time


• Adjust A Range Of Numbers By A Specific Amount Or Percentage

If you've found these tips helpful, please consider signing up for my FREE weekly Excel tips newsletter...

To get more tips like this one every week...

Sign up for my FREE twice-weekly Newsletter

'Spreadsheet Tips From An Excel Addict'