Essential Excel tips
50 essential Excel tips
Your users can save a lot of time and effort working with Excel if they know a few tricks and shortcuts.
These valuable tips originally appeared in our Excel e-newsletter, which has now been beefed up to
include productivity tips for the entire Microsoft Office suite. To begin receiving this free, valuable
resource every Wednesday, visit our e-newsletter subscription center.
Table of contents
Easy data-posting to the Web......................................................................... 3
Open Web pages right in Excel ...................................................................... 3
Detect And Repair........................................................................................... 3
User-level prevention is a magic cure............................................................. 4
Opening multiple windows .............................................................................. 4
Creating custom lists....................................................................................... 4
Copying styles between workbooks................................................................ 5
A macro that pulls source data from charts .................................................... 5
Update for Excel 2000 text export................................................................... 5
Creating a workspace in Excel........................................................................ 5
Printing formulas ............................................................................................. 6
Shifting a scatter chart's axis .......................................................................... 6
Recovering data with the SYLK format ........................................................... 6
Faster access to worksheets .......................................................................... 7
Inserting the full file path in headers and footers ............................................ 7
Exceeding the 30-