Get my FREE
Excel Tips
NEWSLETTER
Check your email in a few minutes. You will need to click on the confirmation link before you begin receiving the tips
|
Home
FREE Weekly Tips Newsletter
FREE QuickTips
FREE Tutorials
BONUS Non-Excel Tips
NEW ! Downloads
Who is the
Excel Addict?
|
Here you will find many of the Microsoft Excel spreadsheet "QuickTips" that have been featured in my FREE newsletter
"Spreadsheet Tips From An Excel Addict"
Subscribe Now!
I can promise you that if you start using these tips, you'll immediately begin saving yourself valuable time creating and updating your Excel spreadsheets.
A Brief Comment on Comments
When Clearing Cells Is A Drag
Spice Up Your Borders
Extract The Year, Month, or Day From A Date
Creating Page Breaks
Print Your Entire Workbook
Unhide A Particular Column
Color Your Sheet Tabs
Printing Cell Comments
Just Print It!
Saving The Current Workbook With A New Filename
Zipping Through Your Sheet Tabs
Quickly Sum Non-Contiguous Cells
Quickly Apply Currency Number Format
Updating Links To The Current Workbook
Hide Excel's Gridlines
Change Excel's Default Font
Hiding An Individual Sheet
The Little-Known, Seldom-Used AutoComplete Trick
One Date Only
The Trouble With Editing
Editing Using Your Keyboard
Open As Copy
Easily Duplicate A Worksheet
Pasting Text From A Web Page To Excel
This Makes Cents
Select Sheet Tabs Without A Mouse
Make Lightning-Quick Jumps With F5
When The Formula Bar Gets In The Way
Print Preview Scrolling
Use Pictures For Your Hyperlinks
Select All Cells On A Worksheet
Create An Instant Chart
Help Is At Your Fingertips
Have You Tried Excel's Post-It Notes?
Format Your Cells Fast
Save Time By Quickly Duplicating Data Values
Quickly Insert New Sheets
Quickly Identify Cells Referred To By A Formula
Quickly Moving To A Specific Cell
Naming Your Sheets
Fastest Bold (Keyboard Shortcut)
Restrict Where To Find and Replace
Close All Excel Workbooks At Once
Setting The Print Area With One Click
Quickly Switching Between Sheets In Excel
Find/Replace Across All Sheets
Hiding Rows (keyboard method)
Hiding Columns (keyboard method)
Calculate A Person's Age
Quickly Create A Series Of Dates
Double-Clicking Saves Scrolling
Copy And Paste Even Quicker
Viewing Your Worksheet Formulas
Show The Current Date In A Cell
Navigating Your Sheets
Adjusting Column Widths And Row Heights
To get more tips like these, subscribe to my newsletter "Spreadsheet Tips From An Excel Addict"
|
P.S. If you have any comments or questions on these tips or if you have any suggestions for new tips, please
send them to me at fhayes(AT)theexceladdict(DOT)com
|
|
|
