record time !
Weekly Newsletter
"Spreadsheet Tips From An Excel Addict"
|
record time ! |
Weekly Newsletter "Spreadsheet Tips From An Excel Addict" |
|
You are just one step away from
unlocking a vast treasure chest of
Excel spreadsheet tips, tricks, shortcuts, and techniques that will
launch
you on a journey of discovery. A journey that will open your eyes to
the
hidden spreadsheet secrets that Excel experts have been using
for years to
turbo-charge their spreadsheets (and their careers).
"There's got to be an easier way to do this!"
How many times have you said to yourself,
Well, you've just found it !My weekly newsletter"Spreadsheet Tips From An Excel Addict"
Emailed To You In Seconds
|
|
||||||||||||||||||||
|
Copyright Francis J Hayes © All Rights Reserved 8 Lexington Place, Conception Bay South, NL Canada A1X 6A2 Phone 709-834-4630 |
||||||||||||||||||||||
| These are just some of the Excel tips, shortcuts, tricks and tutorials that you'll find on my website and in my Spreadsheet Tips From An Excel Addict newsletter ... A Brief Comment on Comments , A Formula To Return A Sheet Name, A is for All, A Quick Solution With Goal Seek , A Very Quick Double-Click Trick (Fill Handle), Add A Calculator To Your Toolbar , Add A New Window For A Better View , Add a Picture to a Comment , Add Google To Your Internet Explorer Toolbar , Adding Your Favourite Text Editor To The 'Send To' Menu, Adjust Text Size In Internet Explorer , Adjust The Width Of Your Horizontal Scroll Bar , Advanced Windows Calculator , Aligning Objects With Cell Borders , An Alternative To Cell Comments , An Easier Way To Maximize Or Restore A Window , Ask Before Emailing Large Attachments , AutoFit Columns Based On Selected Cells Only , Autoshape Perfection , Avoid Numeric Heading Errors In Your Formulas , Avoid Vertical Alignment Problems With Wrapped Text , Bring Order To Your Programs Menu , Bullet Lists In Excel , Calculate The Number Of Days, Can't Remember That Great Website? , Change Excel's Default Font , Change How Files And Folders Are Displayed In Windows Explorer , Change The Format Of Excel's Comments , Change The Header or Footer Font , Change The Shape Of A Cell Comment, Check Spelling Across All Sheets, Check Your Spelling , Choose Your Own Default File Location , Clear Just The Number Cells, Clear Some Or All AutoComplete Information , Clearing Your Recent Documents List , Color Your Sheet Tabs , Cool Formatting In Four Clicks , Copy Column Widths To Another Sheet , Copy Formulas And Maintain The Original Cell References , Copy Pictures And Graphics From A Web Page , Cover Your Tracks In Internet Explorer , Create 3D Effects With Your Cells , Create A Hyperlink To Another Workbook , Create A Linked Picture Of A Range Of Cells , Create A 'Running Total' Formula, Create An Instant Chart , Creating A Custom Number Format , Creating Page Breaks , Cursor Dexterity , Custom Auto Fill - Wow! That's cool! , Custom Menu Access To Frequently Used Workbooks , Cycling Through Font Colors , Definitions By Google , Delete A Workbook Without Leaving Excel , Delete Text The Easy Way , Dialog Box Tip, Disable That Annoying Image Toolbar In IE6, Display A File First In A Folder , Display Text In A Cell On Multiple Lines , Display Values With Dollars And Cents Symbols , Display Your Numbers As Thousands , Don't Get Fooled By Internet Hoaxes, Downloading Audio Files From The Web, Drag and Drop Files To Open , Dragging And Dropping Safely , Drawing Multiple Shapes Tip , Dynamic Row Numbering , Easier Data Entry Using Data Forms, Easily Center Your Report Headings , Easily Copy Your Print Settings From One Sheet To Another , Easily Duplicate A Worksheet , Easily Duplicate Cell Formatting , Easily Move Sheets Between Workbooks , Easily Save Web Graphics , Editing A Range Within A Formula By Dragging , Editing Using Your Keyboard , Email A Webpage Link To A Friend , Email That Excel Workbook Fast , Escaping From Drag-And-Drop , Extract The Year, Month, or Day From A Date , Extracting Unique Items From Data In A Column , Fast Editing Using Your Keyboard , Fastest Bold (Keyboard Shortcut) , Find It Fast! , Find That Lost File , Find That Missing Web Page , Finding That Recently Used Office File , Finding That Shortcut On Your Desktop , Fix Split Web Links In Your Email, Fonts and Cell Backgrounds In Every Color Of The Rainbow, Format Only Part Of The Text Within A Cell , Format Your Cells Fast , Formula To Calculate Last Day Of The Month, Formula To Put The Sheet Name In A Cell , Free Up Hard Drive Space With WinXP Disk Cleanup Utility, Free up some more screen space in Internet Explorer , Full Screen (Seeing The Bigger Picture), Get Me A Calendar, Get Rid Of The Grey , Get The Day Of The Week From A Date , Getting Rid of Those #$ & Spaces In Imported Data , Give Instructions Using Data Validation , Give Me The Full Menu! , Got Questions? Find Answers , Have You Tried Excel's Post-It Notes? , Help Is At Your Fingertips , Hide Excel's Gridlines , Hide The Task Pane On Startup, Hide Worksheets In Excel , Hiding An Individual Sheet , Hiding Rows and Columns (Keyboard Method) , 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 Convert Wrongly Formatted Dates , How To Create A Table Of Contents In Excel , How To Create Cumulative Totals , How To Create Vertical Titles For Your Reports , How To Disable Hyperlink Warning Messages In Excel 2003 , How To Display A User Input Message , How To Display A User Input Message , How To Edit Windows' Recently Used Documents List, How To Enter Multiple Sum Formulas In One Step , How To Find and Replace Wildcard Characters (* ?) , How To Format Your Subtotal Rows To Stand Out , How To Password Protect A Workbook , How To Paste A Hyperlink , How To Prevent Duplicate Entries In A Range Of Cells , How To Print Just A Small Section Of Your Worksheet , How To Really Delete A File, How To Re-organize Your Programs Menu , How To Squeeze Your Worksheet To Print One Page Wide , How To Subtotal A List, How To Sum Values Based On A Condition , How To Use Excel's AutoFilter , How To Use Excel's IF Function , How To Use Fractions In Excel , How To Use Named Ranges , Identify Your Input Cells , Increase The Viewing Area Of Your Browser , Indent Text Without Adding Extra Spaces , Insert Time and Date Stamps In Your Worksheet , Instant List Filter , Instant Online Dictionary/Thesaurus Lookup , Invert Your File Selection In Windows Explorer , Is Your Taskbar A Little Crowded? Expand It! , It Doesn't Add Up Without Rounding ! , Just Print It! , Justify Your Text , Keep Those Headings Visible , Keep Your Quick Launch Bar Uncluttered , Learn To Function Smarter , Let Excel Read To You (Text To Speech) , Link A Text Box To Data In A Cell , Maintenance-Free Subtotals On Your Reports , Make Lightning-Quick Jumps With F5 , Make Your Spreadsheet Fit Your Screen , Minimize All Windows In One Click , Missing Decimals In Imported Numbers, Months Or Years Between Two Dates , Move A Little Closer , Move Formulas Without Changing Their Relative References , Moving An EXE file , Moving The Cell Pointer Around A Selected Range , Moving Within A Selected Range Of Cells, Naming Your Sheets , No More Counting Characters , No Need To Type All Those Filenames , Not Sure If You Should Open That Email? , Number Of Characters In A Cell , Numbers With Minus Sign On Right-Hand Side , One Date Only , Open A Text File In A Non-Associated Program , Open As Copy , Open Two Workbooks With The Same Name, 'Open With' File Options , Opening A Link In A New Browser Window , Opening That File With The Right Program , Page Break Preview , Paste All Except Borders , Pasting Part Of Your Worksheet To Another Document , Pasting Text From A Web Page To Excel , Path Of The Current Workbook, Prevent A Text Box From Printing, Prevent Duplicate Entries In A Range , Prevent N/A Error When Using VLOOKUP , Prevent Unwanted AutoFilling , Preventing The Display Of Zeros , Print Preview Scrolling , Print Row And Column Headings On Your Printout , Print The Same Cell Range On Multiple Excel Worksheets , Print To Fit On x Pages , Print Your Entire Workbook , Print Your Logo At The Top Of Each Sheet , Print Your Report Headings On Every Page , Printing Background Colors In Internet Explorer , Printing Cell Comments , Printing Files Directly From Windows Explorer , Printing Multiple Sheets With Consecutive Page Numbering, Printing Web Pages That Are Too Wide , Protect Files By Making Them Read-Only, Put A Checkmark In A Worksheet Cell, Put An End Long Lines In Email Messages, Putting an Ampersand (&) In Your Header/Footer, Quick Access To The Address Toolbar , Quick Data Input Using 'Pick From List' Option , Quickly Access Your Computer Display Settings , Quickly Apply Currency Number Format , Quickly Change Your HomePage (Internet Explorer) , Quickly Close Multiple Windows , Quickly Convert Positive Values To Negative , Quickly Convert Text To Lower Case , Quickly Copy A File To Your Floppy , Quickly Copy Files In Windows Explorer , Quickly Delete Blank Rows From A Long List , Quickly Duplicate A Value From The Cell Above , Quickly Enter The Months Of The Year , Quickly Entering Long Names , Quickly Identify Cells Referred To By A Formula , Quickly Insert New Sheets , Quickly Move Or Copy Cells , Quickly Moving To A Specific Cell , Quickly Repeating Formulas, Quickly Select Your List , Quickly Selecting IE's Address Bar, Quickly Selecting IE's Address Bar, Quickly Selecting Items In A List, Quickly Send A File As An Attachment , Quickly Sum Non-Contiguous Cells, Quickly Sum Non-Contiguous Cells , Quickly Switch Among Windows Applications , Quickly Toggle Between Excel Workbooks , Quickly Toggle Formulas On And Off , Really? I Can Right-Click With My Keyboard?! , Recover A Deleted Sheet , Remove All Page Breaks, Removing The > Marks When Forwarding Email , Rename Your Favorite Website Links, Replacing A Formula With A Value , Report Your Numbers In Thousands , Restore Those Taskbar Buttons In Windows XP , Rotate Cell Contents Vertically , Rotate Your Column Headings , Round Numbers To The Nearest 1000 , Run A Shortcut To The Internet, Safely Edit Hyperlinks , Save Time By Quickly Duplicating Data Values , Saving The Current Workbook With A New Filename , Searching Your IE Favorites , Seldom-Used AutoComplete Trick, Select All Blanks Cells In A Range, Select All Cells On A Worksheet , Select Sheet Tabs Without A Mouse , Select The Current Range Around The Active Cell , Shortcut For Entering A Website Address , Show The Full Path And Filename In Your Worksheet , Showing Just The Day Of The Week , Shrinking Text To Fit In A Cell , Simple Tips For Better Web Searching , So That's What That Key Is For! , Sorting By Absolute Value, Sorting Sideways, Spice Up Your Borders , Spice Up Your Worksheet With A Picture Or Two , Start Your Internet Search Without Your Browser Open , Stop Your Browser From Automatically Resizing Large Images , Stress-Free Editing Cell Comments, Sum Only Data That Meets A Condition You Specify , Sum Your Data Based On A Condition , Surfing The Net Without A Mouse , Tabbing Backwards , Tabbing Through Input Cells , Take Me To Your Folder , tant Access To Your Favorite Search Engine , The Advantage Of Working With Multiple Windows , The Easiest Way To Rename A File , The Extend Selection Mystery , The Fastest Way To Select A Block Of Cells , The Fastest Way To Select A Block Of Cells , The Fill Handle Secret , The Little-Known, The Secret Of Pasting Multiple Items In One Step , The Trouble With Editing , This Is What I Call Full Screen! , This Makes Cents , This Tip Is Wheel Cool! , Time-Saving Internet Explorer Links , Tired Of Waiting For The Download , Trapped In A Webpage (Internet Explorer) , Troubleshoot Long Formulas , Troubleshooting Formulas , Turn Any Folder Into An Easily Accessible Menu , Turn Off The Paste Options Button, Turning The Tables , Uncovering Your Sheet Tabs , Understanding And Using The Print Screen Key , Understanding Background Calculation, Understanding Custom Views, Unhide A Particular Column , Updating Links To The Current Workbook , Use Autoshapes To Highlight Information , Use Linked AutoShapes To Make Your Data Really Stand Out , Use Pictures For Your Hyperlinks , Using A Validation List From Another Sheet , Using Bcc To Keep Forwarded Email Addresses Safe , Using Headers and Footers , Using Windows Calculator From Your Keyboard , View Two Parts Of A Worksheet Simultaneously , Website Not Found -- It May Have Just Moved, Website Not Found -- It May Have Just Moved , What Column Number Is It ? , What do you do with a frozen mouse? , What size font do you want? , What's Printing? , When Clearing Cells Is A Drag , When The Formula Bar Gets In The Way , Yet Another Way To Copy , Zipping Through Your Sheet Tabs , F4, One Of Excel's Hidden Gems , Quick, Grab A Calendar! |
