| Please note
that due to some changes made by Google recently, you
may find that some of the images and links in my web
pages are not working. Please be patient as I work to correct these problems over then next several weeks. |
How To Create
Simply-Amazing HyperlinksMake Your Spreadsheet Fit Your Screen
A Super-Quick Trick to Convert Formulas to Values
Create Custom Default Worksheet And Workbook Templates
How To Create A Personal Macro Workbook
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 Worksheet Functions
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
To get more tips like these, sign up for my newsletter below...
|
For more FREE Excel Tips like these get my twice-weekly newsletter "Spreadsheet Tips From An Excel Addict" 'Excel in Seconds' (Tuesday) and 'Excel in Minutes' (Thursday) Now being read by more than 37,000+ Excel Addicts all over the world |
Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.