×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

*
*
*
*

Thanks. We have received your request and will respond promptly.

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here
Home > Forums > MIS/IT > Office Suites > Microsoft: Office

Microsoft: Office FAQ Index

FAQ Index
FAQ Title Author Date Rating/#
How do I make a web site with Publisher?   faq68-1612 Gort 11 Mar 02 5.8 / 5
 

Best of Excel
FAQ Title Author Date Rating/#
An AutoSave Add-In for Excel XP   faq68-4060 Bowers74 25 Aug 03 8.5 / 6
_How To Print Disjointed Ranges on ONE Page   faq68-1161 DaleWatson123321 12 Oct 01 8.5 / 39
A query that takes parameters from a cell in the spreadsheet   faq68-2951 paron 30 Dec 02 7.3 / 3
Be Aware: Excel can Change Your Data   faq68-7375 SkipVought 16 Aug 10 10.0 / 1
Better Alternative to VLookup and Hlookup   faq68-6255 Chance1234 23 Mar 06 4.0 / 2
Creating a Popup Calendar in Excel   faq68-3216 PeterMoran 20 Feb 03 7.5 / 6
Delete Duplicates   faq68-5446 gizmo1973 28 Sep 04 6.3 / 6
Get all data in ONE SHEET   faq68-7319 SkipVought 26 Feb 10 10.0 / 1
How can I create a SUMIF or IF Statement based on cell or font color   faq68-4620 16robert 21 Dec 03 3.0 / 11
How can I find colored cells?  faq68-6657 SkipVought 29 May 07 10.0 / 1
How can I find the first row in a table?   faq68-1327 SkipVought 5 Dec 01 4.7 / 3
How can I rename a table as it changes size  faq68-1331 SkipVought 26 Mar 07 7.5 / 22
How can I shade alternate rows automatically?   faq68-4744 KenWright 20 Jan 04 9.9 / 14
How do I count records when I have more then one criteria?   faq68-4725 bluedragon2 28 Jan 04 9.8 / 20
How do I create a graph in Excel and get it to ignore blanks or zeros?   faq68-1277 Hasit 15 Nov 01 6.8 / 12
How do I recover data from a corrupt excel workbook   faq68-1022 ETID 21 Aug 01 6.1 / 17
How do I show a number to a particular number of significant figures   faq68-5066 TonyJollans 21 Apr 04 9.3 / 6
How do I show the sheet name / filename in a cell  faq68-2561 xlbo 5 Mar 04 8.5 / 35
How does SUMPRODUCT() work for Multiple Criteria Aggregations?  faq68-7898 SkipVought 30 Jan 17 --
How does VLOOKUP work??   faq68-4743 KenWright 20 Jan 04 7.7 / 10
How to automate Excel Charts with multiple queries and parameters   faq68-5428 misscrf 14 Sep 04 4.0 / 1
How to export those hashed (##) text cells   faq68-7256 bigfoot 30 Sep 09 --
How to extend a formula a loooong way down   faq68-3311 PepeLeMokko 11 Mar 03 8.5 / 12
How to fill in the blanks in a list of data.  faq68-4741 KenWright 12 Mar 04 9.3 / 7
How to Format a Cell for Engineering Notation   faq68-7052 BJZeak 9 Aug 08 --
How to return results from a current user selection   faq68-1344 issactan 14 Dec 01 10.0 / 1
How to select ALL your data with ONE CLICK   faq68-6887 SkipVought 18 Feb 08 --
How to start Excel with different switches.   faq68-1371 Hasit 19 Dec 01 7.7 / 15
How to translate functions   faq68-5422 01Patrik 10 Sep 04 10.0 / 1
It says I have macros - BUT I DON'T!! - Why???   faq68-4745 KenWright 17 Feb 04 9.9 / 8
Link an Access table or query to an Excel spread sheet   faq68-1403 ETID 28 Dec 01 7.0 / 12
Mail Merge in Excel  faq68-4223 SkipVought 21 Dec 10 4.9 / 7
Missing close/maximize/and minimize buttons?   faq68-2377 BradSQLGuy 26 Aug 02 9.4 / 5
NORMALIZE Your Table using the PivotTable Wizard  faq68-5287 SkipVought 28 Jun 17 8.8 / 16
Printing Excel 2010   faq68-7531 metmanners 7 Dec 11 --
Removing unwanted links from Worksheets   faq68-4470 PeterMoran 21 Nov 03 7.7 / 3
SQL.REQUEST function for Excel   faq68-4089 Bowers74 30 Aug 03 5.0 / 1
Summarize data with a single equation   faq68-660 JVFriederick 28 May 03 7.4 / 14
The Excel CAMERA Feature   faq68-7518 SkipVought 2 May 21 10.0 / 1
Using MS Query to get data from Excel  faq68-5829 SkipVought 17 Jul 12 5.0 / 16
Using Named Cells with VBA   faq68-1075 dsi 6 Sep 01 8.3 / 3
What are LIST & TABLE PRINCIPLES for Spreadsheet Users  faq68-5184 SkipVought 13 Jun 07 5.8 / 5
When is a NUMBER not a NUMBER?   faq68-6659 SkipVought 1 Jun 18 10.0 / 4
Which of these numbers add up to my target number??  faq68-4742 KenWright 9 May 04 8.0 / 8
Why do dates and times seem to display incorrectly?   faq68-707 SimonDavis 4 May 01 6.4 / 10
 

Conditional Cell Formatting
FAQ Title Author Date Rating/#
Is there a cell formula that can change the color of the cell based on its content   faq68-6518 oscarse 19 Jan 07 --
 

Conversion Issues
FAQ Title Author Date Rating/#
Office 2000 to Office 2003   faq68-5245 randysmid 28 Jun 04 10.0 / 1
 

Date/Time Functions
FAQ Title Author Date Rating/#
How to calculate dates for holidays  faq68-7549 BobJacksonNCI 12 Feb 12 --
How to convert hours/mins/seconds greater than one day to seconds   faq68-5445 Mikeauz 27 Sep 04 7.0 / 3
How to determine Date of the week knowing Week Number  faq68-6900 xlhelp 24 Mar 08 5.5 / 2
Understanding Dates and Times & why they seem to be so much trouble?  faq68-5827 SkipVought 2 Jul 15 5.8 / 30
What are some of Excel's date functions?  faq68-4037 Bowers74 4 Mar 06 9.0 / 21
 

How to
FAQ Title Author Date Rating/#
Chart Bars or Columns that change color based on data values.   faq68-7367 SkipVought 16 Jul 10 --
Excel: Add Carriage Return in a Cell   faq68-4515 Garridon 1 Dec 03 7.3 / 12
How can I create multiple and independent tables of contents in a single Word document?   faq68-4539 BlueHorizon 3 Dec 03 6.0 / 2
How can I perform a LOOKUP with MULTIPLE CRITERIA to return a SINGLE VALUE?  faq68-7708 SkipVought 31 Mar 14 10.0 / 1
How Do I [blank] in 2007 like I did in 2003?   faq68-6918 Bandenjamin 21 Apr 08 7.0 / 1
Permanently Hide the Office Clipboard Toolbar   faq68-5884 shetlandbob 24 May 05 --
Troubleshooting corrupted MS Office files  faq68-7514 jrbarnett 14 Sep 11 --
Turn off "Curly" Quotes   faq68-4391 Garridon 4 Nov 03 7.5 / 2
 

Microsoft Publisher
FAQ Title Author Date Rating/#
File Size   faq68-1699 jbits 27 Mar 02 5.3 / 3
 

Office Running Slow
FAQ Title Author Date Rating/#
Does Excel take a long time to Load   faq68-7500 assets 5 Jul 11 --
Does the Print Dialog Box in Word take a LONG time to load  faq68-7499 assets 6 Jul 11 --
 

Outlook 2000 Macros
FAQ Title Author Date Rating/#
No rules to automatically send and print an email ?   faq68-764 toony 28 May 01 6.7 / 3
 

Outlook FAQs
FAQ Title Author Date Rating/#
Access Web-Based E-Mail From Outlook 2000   faq68-2785 nosugar 20 Nov 02 4.8 / 4
Adding a Send and File Button  faq68-7560 markdmac 18 May 12 --
How to send an Email and Attachment using Visual Basic and Outlook   faq68-2823 red54 3 Dec 02 6.0 / 3
How to send Outlook email from other MS Office Apps.   faq68-4272 SQLBI 23 Jan 04 6.0 / 3
Lost personal folder (PST) password and need help?   faq68-2269 BradSQLGuy 1 Aug 02 6.4 / 10
Missing body text in emails intermittenly Outlook2000   faq68-2270 BradSQLGuy 1 Aug 02 6.5 / 4
Out of Office Rules Profile Corrupt   faq68-2994 mishmm 8 Jan 03 3.7 / 3
Send a response to multiple emails   faq68-5413 misscrf 2 Sep 04 --
Understanding Outlook Folders, up to Outlook 2000   faq68-1597 Dreamboat 6 Mar 02 7.3 / 16
 

PivotTable Tips
FAQ Title Author Date Rating/#
Find the original field name for a changed PivotField   faq68-7101 SkipVought 13 Nov 08 --
Normalize your data using the PivotTable Wizard   faq68-7103 SkipVought 13 Nov 08 10.0 / 1
Old Pivot Items causing PivotTable problems   faq68-7102 SkipVought 13 Nov 08 --
Viewing the Specific Source Data Rows for a PivotTable Summary Value  faq68-7580 SkipVought 24 Aug 12 --
 

Tips and Tricks
FAQ Title Author Date Rating/#
A Checklist for Backing Up MS Office 97 or 2000 Files   faq68-648 Dreamboat 13 Apr 01 8.0 / 7
A VLOOKUP formula appears to be written correctly but will only return Error messages.   faq68-7385 gpeterman 10 Sep 10 --
Accents & Characters û why they give problems   faq68-5592 Madawc 31 Dec 04 --
Are there other ways to use cut, copy, and paste besides the usual uses in Microsoft Office programs?  faq68-199 mnobles 22 Aug 00 4.8 / 11
Bulleted Lists in Excel  faq68-7219 xlhelp 6 Jul 09 --
Bullets Change to Something Else   faq68-616 Garridon 3 Apr 01 7.7 / 7
Computer Codes & Sorts Vary Between Machines   faq68-5591 Madawc 31 Dec 04 1.0 / 1
Excel File Cleanup or PreCorruption Cleanup   faq68-619 Dreamboat 4 Apr 01 8.5 / 13
Exporting from a Database to Excel   faq68-6745 Glowball 3 Oct 07 --
Get MS Word Copy/Paste-text to word wrap properly   faq68-1449 SkipVought 2 Sep 03 8.4 / 10
Getting the best from Excel when Changing Jobs/Offices   faq68-5384 gizmo1973 13 Aug 04 6.0 / 3
How do I select a range of cells that won't stay still!   faq68-597 SimonDavis 28 Mar 01 8.4 / 15
How to Insert Foreign Characters in Office   faq68-2616 tgmoon 22 Oct 02 7.5 / 4
How to start Word with different switches.   faq68-1269 Hasit 13 Nov 01 6.6 / 20
MS Office File Corruption Fixes   faq68-580 Dreamboat 21 Mar 01 6.4 / 36
Office Automation   faq68-973 Databaseguy 7 Aug 01 6.5 / 12
Red Xs in Your Files   faq68-557 Dreamboat 16 Mar 01 5.3 / 7
Rules for Master/SubDocuments   faq68-574 Dreamboat 20 Mar 01 9.2 / 9
Short way to the desktop   faq68-3347 PepeLeMokko 17 Apr 03 8.6 / 10
Steps for Troubleshooting Microsoft Word 97 & 2000   faq68-646 Dreamboat 12 Apr 01 7.4 / 25
Unhide Personal.xls to Edit Macros  faq68-201 LarryDeLaruelle 22 Aug 00 7.5 / 11
Using AutoText in Word   faq68-1333 Hasit 7 Dec 01 6.0 / 5
Using Linked Charts in PowerPoint Presentations   faq68-617 Garridon 3 Apr 01 7.3 / 4
 

Using Access Database As Word
FAQ Title Author Date Rating/#
Alternative Mailmerge In Word Using Access Database That Does Not Use Words Mailmerge.  faq68-452 mdav2 5 Feb 01 8.3 / 4
 

VB for apps
FAQ Title Author Date Rating/#
How do I add in a custom Macro/Function?   faq68-1271 logius 13 Nov 01 4.8 / 10
How to release memory on Acces/close all open recordsets   faq68-6184 patyavila 20 Jan 06 --
Loop Through All Word Documents in Directory   faq68-1223 GeekGirlau 30 Oct 01 8.0 / 4
Return Network UserID example   faq68-1077 ETID 6 Sep 01 6.0 / 7
 

Word 2000/2002 Macros
FAQ Title Author Date Rating/#
How can I export Word documents to W3C-compliant HTML instead of Microsoft-specific HTML?   faq68-2730 rasx 7 Nov 02 --
 

Word FAQ
FAQ Title Author Date Rating/#
Using FormFields In Word - Part 1 - Overview  faq68-5299 fumei 10 Jul 04 8.7 / 15
Using FormFields in Word Part 2 û Coding with Form Fields   faq68-5300 fumei 9 Jul 04 8.5 / 4
 

Word Mail Merge
FAQ Title Author Date Rating/#
How Can I Use Mail Merge to Create a List Sorted by Category   faq68-582 AyJayEL 22 Mar 01 --
How to MAIL MERGE and PRINT each Recipient Separately  faq68-6655 SkipVought 25 May 07 --
How to MAIL MERGE and SAVE EACH DOCUMENT SEPARATELY   faq68-5187 SkipVought 7 Jun 04 --
Muplitple Instances of Access Opening   faq68-983 Databaseguy 9 Aug 01 7.5 / 4
 

Title :
Author :
Date :
11 Mar 02
Rating/# :
5.8 / 5
 

Best of Excel

Title :
Author :
Date :
25 Aug 03
Rating/# :
8.5 / 6
Title :
Author :
Date :
12 Oct 01
Rating/# :
8.5 / 39
Title :
Author :
Date :
30 Dec 02
Rating/# :
7.3 / 3
Title :
Author :
Date :
16 Aug 10
Rating/# :
10.0 / 1
Title :
Author :
Date :
23 Mar 06
Rating/# :
4.0 / 2
Title :
Author :
Date :
20 Feb 03
Rating/# :
7.5 / 6
Title :
Author :
Date :
28 Sep 04
Rating/# :
6.3 / 6
Title :
Author :
Date :
26 Feb 10
Rating/# :
10.0 / 1
Title :
Author :
Date :
21 Dec 03
Rating/# :
3.0 / 11
Title :
Author :
Date :
29 May 07
Rating/# :
10.0 / 1
Title :
Author :
Date :
5 Dec 01
Rating/# :
4.7 / 3
Title :
Author :
Date :
26 Mar 07
Rating/# :
7.5 / 22
Title :
Author :
Date :
20 Jan 04
Rating/# :
9.9 / 14
Title :
Author :
Date :
28 Jan 04
Rating/# :
9.8 / 20
Title :
Author :
Date :
15 Nov 01
Rating/# :
6.8 / 12
Title :
Author :
Date :
21 Aug 01
Rating/# :
6.1 / 17
Title :
Author :
Date :
21 Apr 04
Rating/# :
9.3 / 6
Title :
Author :
Date :
5 Mar 04
Rating/# :
8.5 / 35
Title :
Author :
Date :
30 Jan 17
Rating/# :
--
Title :
Author :
Date :
20 Jan 04
Rating/# :
7.7 / 10
Title :
Author :
Date :
14 Sep 04
Rating/# :
4.0 / 1
Title :
Author :
Date :
30 Sep 09
Rating/# :
--
Title :
Author :
Date :
11 Mar 03
Rating/# :
8.5 / 12
Title :
Author :
Date :
12 Mar 04
Rating/# :
9.3 / 7
Title :
Author :
Date :
9 Aug 08
Rating/# :
--
Title :
Author :
Date :
14 Dec 01
Rating/# :
10.0 / 1
Title :
Author :
Date :
18 Feb 08
Rating/# :
--
Title :
Author :
Date :
19 Dec 01
Rating/# :
7.7 / 15
Title :
Author :
Date :
10 Sep 04
Rating/# :
10.0 / 1
Title :
Author :
Date :
17 Feb 04
Rating/# :
9.9 / 8
Title :
Author :
Date :
28 Dec 01
Rating/# :
7.0 / 12
Title :
Author :
Date :
21 Dec 10
Rating/# :
4.9 / 7
Title :
Author :
Date :
26 Aug 02
Rating/# :
9.4 / 5
Title :
Author :
Date :
28 Jun 17
Rating/# :
8.8 / 16
Title :
Author :
Date :
7 Dec 11
Rating/# :
--
Title :
Author :
Date :
21 Nov 03
Rating/# :
7.7 / 3
Title :
Author :
Date :
30 Aug 03
Rating/# :
5.0 / 1
Title :
Author :
Date :
28 May 03
Rating/# :
7.4 / 14
Title :
Author :
Date :
2 May 21
Rating/# :
10.0 / 1
Title :
Author :
Date :
17 Jul 12
Rating/# :
5.0 / 16
Title :
Author :
Date :
6 Sep 01
Rating/# :
8.3 / 3
Title :
Author :
Date :
13 Jun 07
Rating/# :
5.8 / 5
Title :
Author :
Date :
1 Jun 18
Rating/# :
10.0 / 4
Title :
Author :
Date :
9 May 04
Rating/# :
8.0 / 8
Title :
Author :
Date :
4 May 01
Rating/# :
6.4 / 10
 

Conditional Cell Formatting

Title :
Author :
Date :
19 Jan 07
Rating/# :
--
 

Conversion Issues

Title :
Author :
Date :
28 Jun 04
Rating/# :
10.0 / 1
 

Date/Time Functions

Title :
Author :
Date :
12 Feb 12
Rating/# :
--
Title :
Author :
Date :
27 Sep 04
Rating/# :
7.0 / 3
Title :
Author :
Date :
24 Mar 08
Rating/# :
5.5 / 2
Title :
Author :
Date :
2 Jul 15
Rating/# :
5.8 / 30
Title :
Author :
Date :
4 Mar 06
Rating/# :
9.0 / 21
 

How to

Title :
Author :
Date :
16 Jul 10
Rating/# :
--
Title :
Author :
Date :
1 Dec 03
Rating/# :
7.3 / 12
Title :
Author :
Date :
3 Dec 03
Rating/# :
6.0 / 2
Title :
Author :
Date :
31 Mar 14
Rating/# :
10.0 / 1
Title :
Author :
Date :
21 Apr 08
Rating/# :
7.0 / 1
Title :
Author :
Date :
24 May 05
Rating/# :
--
Title :
Author :
Date :
14 Sep 11
Rating/# :
--
Title :
Author :
Date :
4 Nov 03
Rating/# :
7.5 / 2
 

Microsoft Publisher

Title :
Author :
Date :
27 Mar 02
Rating/# :
5.3 / 3
 

Office Running Slow

Title :
Author :
Date :
5 Jul 11
Rating/# :
--
Title :
Author :
Date :
6 Jul 11
Rating/# :
--
 

Outlook 2000 Macros

Title :
Author :
Date :
28 May 01
Rating/# :
6.7 / 3
 

Outlook FAQs

Title :
Author :
Date :
20 Nov 02
Rating/# :
4.8 / 4
Title :
Author :
Date :
18 May 12
Rating/# :
--
Title :
Author :
Date :
3 Dec 02
Rating/# :
6.0 / 3
Title :
Author :
Date :
23 Jan 04
Rating/# :
6.0 / 3
Title :
Author :
Date :
1 Aug 02
Rating/# :
6.4 / 10
Title :
Author :
Date :
1 Aug 02
Rating/# :
6.5 / 4
Title :
Author :
Date :
8 Jan 03
Rating/# :
3.7 / 3
Title :
Author :
Date :
2 Sep 04
Rating/# :
--
Title :
Author :
Date :
6 Mar 02
Rating/# :
7.3 / 16
 

PivotTable Tips

Title :
Author :
Date :
13 Nov 08
Rating/# :
--
Title :
Author :
Date :
13 Nov 08
Rating/# :
10.0 / 1
Title :
Author :
Date :
13 Nov 08
Rating/# :
--
Title :
Author :
Date :
24 Aug 12
Rating/# :
--
 

Tips and Tricks

Title :
Author :
Date :
13 Apr 01
Rating/# :
8.0 / 7
Title :
Author :
Date :
10 Sep 10
Rating/# :
--
Title :
Author :
Date :
31 Dec 04
Rating/# :
--
Title :
Author :
Date :
22 Aug 00
Rating/# :
4.8 / 11
Title :
Author :
Date :
6 Jul 09
Rating/# :
--
Title :
Author :
Date :
3 Apr 01
Rating/# :
7.7 / 7
Title :
Author :
Date :
31 Dec 04
Rating/# :
1.0 / 1
Title :
Author :
Date :
4 Apr 01
Rating/# :
8.5 / 13
Title :
Author :
Date :
3 Oct 07
Rating/# :
--
Title :
Author :
Date :
2 Sep 03
Rating/# :
8.4 / 10
Title :
Author :
Date :
13 Aug 04
Rating/# :
6.0 / 3
Title :
Author :
Date :
28 Mar 01
Rating/# :
8.4 / 15
Title :
Author :
Date :
22 Oct 02
Rating/# :
7.5 / 4
Title :
Author :
Date :
13 Nov 01
Rating/# :
6.6 / 20
Title :
Author :
Date :
21 Mar 01
Rating/# :
6.4 / 36
Title :
Author :
Date :
7 Aug 01
Rating/# :
6.5 / 12
Title :
Author :
Date :
16 Mar 01
Rating/# :
5.3 / 7
Title :
Author :
Date :
20 Mar 01
Rating/# :
9.2 / 9
Title :
Author :
Date :
17 Apr 03
Rating/# :
8.6 / 10
Title :
Author :
Date :
12 Apr 01
Rating/# :
7.4 / 25
Title :
Author :
Date :
22 Aug 00
Rating/# :
7.5 / 11
Title :
Author :
Date :
7 Dec 01
Rating/# :
6.0 / 5
Title :
Author :
Date :
3 Apr 01
Rating/# :
7.3 / 4
 

Using Access Database As Word

Title :
Author :
Date :
5 Feb 01
Rating/# :
8.3 / 4
 

VB for apps

Title :
Author :
Date :
13 Nov 01
Rating/# :
4.8 / 10
Title :
Author :
Date :
20 Jan 06
Rating/# :
--
Title :
Author :
Date :
30 Oct 01
Rating/# :
8.0 / 4
Title :
Author :
Date :
6 Sep 01
Rating/# :
6.0 / 7
 

Word 2000/2002 Macros

Title :
Author :
Date :
7 Nov 02
Rating/# :
--
 

Word FAQ

Title :
Author :
Date :
10 Jul 04
Rating/# :
8.7 / 15
Title :
Author :
Date :
9 Jul 04
Rating/# :
8.5 / 4
 

Word Mail Merge

Title :
Author :
Date :
22 Mar 01
Rating/# :
--
Title :
Author :
Date :
25 May 07
Rating/# :
--
Title :
Author :
Date :
7 Jun 04
Rating/# :
--
Title :
Author :
Date :
9 Aug 01
Rating/# :
7.5 / 4
 
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close