[Office 2007] Tips and Tricks

**Sazar** · May 20th, 2008

We don't appear to have any stickied threads on how-to's and tips and tricks regarding the most widely used office application out there

Figured this would be a good place to start. Please post some useful tips and tricks for all users. If you want to talk about a competing product, start another thread

My first tip is pretty simple. If you are using Office 2007 applications such as Word, PowerPoint, Excel and others, instead of clicking on the different ribbon tabs to open them, simply move your pointer onto the ribbon that has current focus and scroll using your mouse wheel. It will automatically cycle through the ribbons and is more accurate and faster than clicking individual tabs.

**kcnychief** · May 20th, 2008

A few other resources I can recommend -

Add on to search within the ribbon:

http://www.officelabs.com/projects/s...s/default.aspx

How To do things in Office 07 by doing them in Office 03

Word - http://office.microsoft.com/en-us/wo...744321033.aspx
Outlook - http://office.microsoft.com/en-us/ou...221621033.aspx
Excel - http://office.microsoft.com/en-us/ex...491511033.aspx
PPT - http://office.microsoft.com/en-us/po...490761033.aspx
Access - http://office.microsoft.com/en-us/ac...388991033.aspx

**fitz** · May 20th, 2008

or if you want the classic menus back and don't want the ribbon interface, you can use the Classic Menu Add-in For Office 2007

**kcnychief** · May 21st, 2008

Very nice Fitzy - didn't know about that one

**Sazar** · May 21st, 2008

The ribbons are far more effective for productivity once you get over the learning curve though Fitz

Going back to the classic is like taking a brand new, super-charged super-car and sticking an old-school carburetor engine in it.

But, nice link for those who want to enjoy the old-school feel

**fitz** · May 21st, 2008

Oh.. I use the ribbons and love them. I just know people that despise them

**kcnychief** · May 21st, 2008

Is it per-program specific? Would be cool to ease people into it like give them classic for 3 out of the 4 or whatever instead of a "shock and awe"

roirraW "edor" ehT · May 21st, 2008

Yes, you can enable or disable it separately for Access, Excel, Outlook, Power Point and Word. Each one individually has some other options. You can choose to hide some or all of the Microsoft tabs, or none of course.

Notice, Outlook itself doesn't have ribbons, but it's stripped down version of Word that's built-in does and that's what the Outlook setting affects.

I switch back and forth between menus and the standard ribbons (menus are just on a new tab that Classic Menu adds) depending on what I'm doing. I'm an old fart, so I can't learn any new tricks.

I've been using it for over a year.

Eagle710 · June 2nd, 2008

How would I reset a password on a pst file? Any body know any tricks to get this done?

**Dark Atheist** · June 2nd, 2008

Originally Posted by Sazar

We don't appear to have any stickied threads on how-to's and tips and tricks regarding the most widely used office application out there

tip/trick - don't install it

roirraW "edor" ehT · June 2nd, 2008

Outlook Key which can be bought separately or as part of Passware Kit. Neither is particularly cheap, but compared to the full Passware Kit, Outlook Key is "reasonable" if your PST is that important.

I haven't used the Outlook portion of this. I've only used Passware Kit to reset the Admin account password on Windows XP once. They do have demos of both products to download. Don't know if the demo will permanantly give you access to your stuff or what it's trial limitations are.

The demo of Outlook key is only 521.1 KB!

**Sazar** · June 2nd, 2008

Originally Posted by Eagle710

How would I reset a password on a pst file? Any body know any tricks to get this done?

Not sure I follow.

Is this your file that you have already set a password on?

If so, can you not just log back in and change the password?

**fitz** · June 2nd, 2008

http://office.microsoft.com/en-us/ou...513931033.aspx

To open the .pst file, you must enter the correct password. Remember that .pst passwords are case-sensitive. Try to remember whether the password that you assigned used uppercase and lowercase letters and make sure that your CAPS LOCK key is not on.

Passwords cannot be reset or recovered if lost. Microsoft is not able to retrieve lost .pst passwords.

That being said, there are other ways to crack or reset the password on the pst. Depending on what version of Outlook you are running, if you have a non-unicode PST (ie: created prior to Outlook 2003) you can use a couple Microsoft utilities that have the side effect of removing the password from the PST file..

http://www.slipstick.com/problems/lostpw.asp

Eagle710 · June 11th, 2008

How can I check to see if a password has been set on a pst?

Does anyone know a good guide on the techinal overview of Outlook like pst and ost?

roirraW "edor" ehT · June 11th, 2008

When you try to load the PST in Outlook it would ask for a password if one's been set.

Eagle710 · June 23rd, 2008

Everyone,

I have followed this guide to make a very handy Email Template toolbar. I was wondering if there was a way in to create an applet or something that when I select a specific email it prompts me for specific information (eg. DATE, name, system)?
Any hints on how I could go about doing this?

**Sazar** · June 23rd, 2008

Originally Posted by Eagle710

Everyone,

I have followed this guide to make a very handy Email Template toolbar. I was wondering if there was a way in to create an applet or something that when I select a specific email it prompts me for specific information (eg. DATE, name, system)?
Any hints on how I could go about doing this?

I am not sure I follow.

Are you looking for search functionality? Are you looking to manually change the information on the email? What are you needing to do good sir

roirraW "edor" ehT · June 23rd, 2008

Sounds like Eagle710 wants it to prompt him for the answers to various fields as specified in his email templates. I don't know the answer to his question, however.

My experience with related solutions is limited to advanced "mail merge" (I don't know if they call it that any more, or if they ever called it that under Windows applications) using Excel and Word.

Eagle710 · July 3rd, 2008

Originally Posted by roirraW "edor" ehT

Sounds like Eagle710 wants it to prompt him for the answers to various fields as specified in his email templates. I don't know the answer to his question, however.

That is correct. You hit that dead on the nose. Any help or guidance?

roirraW "edor" ehT · July 4th, 2008

I wish I could but I don't use templates at all and have no idea what to suggest first. Of course, you were probably asking if anyone else has any guidance.

May 20th, 2008	Top \| #1
Sazar F@H - Is it in you? Joined: April 2002 Location: Between Austin and Tampa Posts: 14,941 Reputation: 4110 Power: 287	[Office 2007] Tips and Tricks We don't appear to have any stickied threads on how-to's and tips and tricks regarding the most widely used office application out there Figured this would be a good place to start. Please post some useful tips and tricks for all users. If you want to talk about a competing product, start another thread My first tip is pretty simple. If you are using Office 2007 applications such as Word, PowerPoint, Excel and others, instead of clicking on the different ribbon tabs to open them, simply move your pointer onto the ribbon that has current focus and scroll using your mouse wheel. It will automatically cycle through the ribbons and is more accurate and faster than clicking individual tabs.
	Media Server: Intel Q9450 \| 8GB Corsair XMS2 \| 4870 1GB \| 1.5 TB Storage \| Logitech G-15/G-9 \| Windows 7 Ultimate x64 HTPC: AMD 4400+ \| 2GB Corsair \| 2 TB Storage \| 8800 GTS (G92) \| Logitech Edge \| Hauppauge 1600 \| Windows 7 Ultimate x86 Notebook Dell E6400 \| Core2Duo 8400 \| 4GB \| Encrypted 160GB with FFS \| WXGA+ LED \| Quadro NVS 160 \| Windows 7 Enterprise x64 Folding @ Home \| XBL / PSN / Steam : SAZARIUS \| Zune Social : SAZAR99

May 20th, 2008	Top \| #2
kcnychief █▄█ ▀█▄ █ Joined: April 2005 Location: Massachusetts Posts: 16,974 Reputation: 4941 Power: 279	Re: [Office 2007] Tips and Tricks A few other resources I can recommend - Add on to search within the ribbon: http://www.officelabs.com/projects/s...s/default.aspx How To do things in Office 07 by doing them in Office 03 Word - http://office.microsoft.com/en-us/wo...744321033.aspx Outlook - http://office.microsoft.com/en-us/ou...221621033.aspx Excel - http://office.microsoft.com/en-us/ex...491511033.aspx PPT - http://office.microsoft.com/en-us/po...490761033.aspx Access - http://office.microsoft.com/en-us/ac...388991033.aspx
	XBOX Live Gamertag: kcnychief

May 20th, 2008	Top \| #3
fitz *XPista7eopardix Joined: April 2004 Location: Chicagoland Posts: 3,917 Reputation: 2599 Power: 136**	Re: [Office 2007] Tips and Tricks or if you want the classic menus back and don't want the ribbon interface, you can use the Classic Menu Add-in For Office 2007
	Hee-hee! Evil makes my buttocks tingle.

May 21st, 2008	Top \| #4
kcnychief █▄█ ▀█▄ █ Joined: April 2005 Location: Massachusetts Posts: 16,974 Reputation: 4941 Power: 279	Re: [Office 2007] Tips and Tricks Very nice Fitzy - didn't know about that one
	XBOX Live Gamertag: kcnychief

May 21st, 2008	Top \| #5
Sazar F@H - Is it in you? Joined: April 2002 Location: Between Austin and Tampa Posts: 14,941 Reputation: 4110 Power: 287	Re: [Office 2007] Tips and Tricks The ribbons are far more effective for productivity once you get over the learning curve though Fitz Going back to the classic is like taking a brand new, super-charged super-car and sticking an old-school carburetor engine in it. But, nice link for those who want to enjoy the old-school feel
	Media Server: Intel Q9450 \| 8GB Corsair XMS2 \| 4870 1GB \| 1.5 TB Storage \| Logitech G-15/G-9 \| Windows 7 Ultimate x64 HTPC: AMD 4400+ \| 2GB Corsair \| 2 TB Storage \| 8800 GTS (G92) \| Logitech Edge \| Hauppauge 1600 \| Windows 7 Ultimate x86 Notebook Dell E6400 \| Core2Duo 8400 \| 4GB \| Encrypted 160GB with FFS \| WXGA+ LED \| Quadro NVS 160 \| Windows 7 Enterprise x64 Folding @ Home \| XBL / PSN / Steam : SAZARIUS \| Zune Social : SAZAR99

Latest News Posts

Latest Forum Posts

Latest Member Blogs

May 21st, 2008	Top \| #6
fitz *XPista7eopardix Joined: April 2004 Location: Chicagoland Posts: 3,917 Reputation: 2599 Power: 136**	Re: [Office 2007] Tips and Tricks Oh.. I use the ribbons and love them. I just know people that despise them
	Hee-hee! Evil makes my buttocks tingle.

May 21st, 2008	Top \| #7
kcnychief █▄█ ▀█▄ █ Joined: April 2005 Location: Massachusetts Posts: 16,974 Reputation: 4941 Power: 279	Re: [Office 2007] Tips and Tricks Is it per-program specific? Would be cool to ease people into it like give them classic for 3 out of the 4 or whatever instead of a "shock and awe"
	XBOX Live Gamertag: kcnychief

May 21st, 2008	Top \| #8
roirraW "edor" ehT Builder/Installer Joined: May 2008 Posts: 530 Reputation: 742 Power: 35	Re: [Office 2007] Tips and Tricks Yes, you can enable or disable it separately for Access, Excel, Outlook, Power Point and Word. Each one individually has some other options. You can choose to hide some or all of the Microsoft tabs, or none of course. Notice, Outlook itself doesn't have ribbons, but it's stripped down version of Word that's built-in does and that's what the Outlook setting affects. I switch back and forth between menus and the standard ribbons (menus are just on a new tab that Classic Menu adds) depending on what I'm doing. I'm an old fart, so I can't learn any new tricks. I've been using it for over a year.

June 2nd, 2008	Top \| #9
Eagle710 OSNN Senior Addict Joined: March 2005 Location: Toronto, Ontario, Canada Posts: 308 Reputation: 40 Power: 65	Re: [Office 2007] Tips and Tricks How would I reset a password on a pst file? Any body know any tricks to get this done?

June 2nd, 2008	Top \| #10
Dark Atheist I never said I was nice Joined: April 2003 Location: In The Void Posts: 6,496 Blog Entries: 8 Reputation: 1877 Power: 167	Re: [Office 2007] Tips and Tricks Originally Posted by Sazar We don't appear to have any stickied threads on how-to's and tips and tricks regarding the most widely used office application out there tip/trick - don't install it

June 2nd, 2008	Top \| #11
roirraW "edor" ehT Builder/Installer Joined: May 2008 Posts: 530 Reputation: 742 Power: 35	Re: [Office 2007] Tips and Tricks Outlook Key which can be bought separately or as part of Passware Kit. Neither is particularly cheap, but compared to the full Passware Kit, Outlook Key is "reasonable" if your PST is that important. I haven't used the Outlook portion of this. I've only used Passware Kit to reset the Admin account password on Windows XP once. They do have demos of both products to download. Don't know if the demo will permanantly give you access to your stuff or what it's trial limitations are. The demo of Outlook key is only 521.1 KB!
	Gigabyte full tower GZ-FA2CA-AJB Gigabyte motherboard MA790X-UD4P HIS Radeon HD 4850 512MB AMD Athlon 64 X2 4400+ 2.3GHz Corsair TWIN2X4096-6400C4DHX 4-4-4-12 4x1TB SATA RAID 0+1/2x640GB SATA RAID 0/Misc. PATA Windows 7 x64

June 2nd, 2008	Top \| #12
Sazar F@H - Is it in you? Joined: April 2002 Location: Between Austin and Tampa Posts: 14,941 Reputation: 4110 Power: 287	Re: [Office 2007] Tips and Tricks Originally Posted by Eagle710 How would I reset a password on a pst file? Any body know any tricks to get this done? Not sure I follow. Is this your file that you have already set a password on? If so, can you not just log back in and change the password?
	Media Server: Intel Q9450 \| 8GB Corsair XMS2 \| 4870 1GB \| 1.5 TB Storage \| Logitech G-15/G-9 \| Windows 7 Ultimate x64 HTPC: AMD 4400+ \| 2GB Corsair \| 2 TB Storage \| 8800 GTS (G92) \| Logitech Edge \| Hauppauge 1600 \| Windows 7 Ultimate x86 Notebook Dell E6400 \| Core2Duo 8400 \| 4GB \| Encrypted 160GB with FFS \| WXGA+ LED \| Quadro NVS 160 \| Windows 7 Enterprise x64 Folding @ Home \| XBL / PSN / Steam : SAZARIUS \| Zune Social : SAZAR99

June 2nd, 2008	Top \| #13
fitz *XPista7eopardix Joined: April 2004 Location: Chicagoland Posts: 3,917 Reputation: 2599 Power: 136**	Re: [Office 2007] Tips and Tricks http://office.microsoft.com/en-us/ou...513931033.aspx To open the .pst file, you must enter the correct password. Remember that .pst passwords are case-sensitive. Try to remember whether the password that you assigned used uppercase and lowercase letters and make sure that your CAPS LOCK key is not on. Passwords cannot be reset or recovered if lost. Microsoft is not able to retrieve lost .pst passwords. That being said, there are other ways to crack or reset the password on the pst. Depending on what version of Outlook you are running, if you have a non-unicode PST (ie: created prior to Outlook 2003) you can use a couple Microsoft utilities that have the side effect of removing the password from the PST file.. http://www.slipstick.com/problems/lostpw.asp
	Hee-hee! Evil makes my buttocks tingle.

June 11th, 2008	Top \| #14
Eagle710 OSNN Senior Addict Joined: March 2005 Location: Toronto, Ontario, Canada Posts: 308 Reputation: 40 Power: 65	Re: [Office 2007] Tips and Tricks How can I check to see if a password has been set on a pst? Does anyone know a good guide on the techinal overview of Outlook like pst and ost?

June 11th, 2008	Top \| #15
roirraW "edor" ehT Builder/Installer Joined: May 2008 Posts: 530 Reputation: 742 Power: 35	Re: [Office 2007] Tips and Tricks When you try to load the PST in Outlook it would ask for a password if one's been set.
	Gigabyte full tower GZ-FA2CA-AJB Gigabyte motherboard MA790X-UD4P HIS Radeon HD 4850 512MB AMD Athlon 64 X2 4400+ 2.3GHz Corsair TWIN2X4096-6400C4DHX 4-4-4-12 4x1TB SATA RAID 0+1/2x640GB SATA RAID 0/Misc. PATA Windows 7 x64

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Microsoft Office 12 will named Office 2007	RavenMaster	Windows Desktop Systems	10	January 25th, 2006 7:54pm
Wireless tips & tricks videos	tdinc	Windows Desktop Systems	1	March 20th, 2005 6:08am
GTA Vice City tricks/tips	Teddy	PC Gaming	22	May 19th, 2003 6:35pm
Awesome XP Tips and Tricks	andrewjm	Windows Desktop Systems	18	February 3rd, 2002 3:46am

June 23rd, 2008	Top \| #16
Eagle710 OSNN Senior Addict Joined: March 2005 Location: Toronto, Ontario, Canada Posts: 308 Reputation: 40 Power: 65	Re: [Office 2007] Tips and Tricks Everyone, I have followed this guide to make a very handy Email Template toolbar. I was wondering if there was a way in to create an applet or something that when I select a specific email it prompts me for specific information (eg. DATE, name, system)? Any hints on how I could go about doing this?

June 23rd, 2008	Top \| #17
Sazar F@H - Is it in you? Joined: April 2002 Location: Between Austin and Tampa Posts: 14,941 Reputation: 4110 Power: 287	Re: [Office 2007] Tips and Tricks Originally Posted by Eagle710 Everyone, I have followed this guide to make a very handy Email Template toolbar. I was wondering if there was a way in to create an applet or something that when I select a specific email it prompts me for specific information (eg. DATE, name, system)? Any hints on how I could go about doing this? I am not sure I follow. Are you looking for search functionality? Are you looking to manually change the information on the email? What are you needing to do good sir
	Media Server: Intel Q9450 \| 8GB Corsair XMS2 \| 4870 1GB \| 1.5 TB Storage \| Logitech G-15/G-9 \| Windows 7 Ultimate x64 HTPC: AMD 4400+ \| 2GB Corsair \| 2 TB Storage \| 8800 GTS (G92) \| Logitech Edge \| Hauppauge 1600 \| Windows 7 Ultimate x86 Notebook Dell E6400 \| Core2Duo 8400 \| 4GB \| Encrypted 160GB with FFS \| WXGA+ LED \| Quadro NVS 160 \| Windows 7 Enterprise x64 Folding @ Home \| XBL / PSN / Steam : SAZARIUS \| Zune Social : SAZAR99

June 23rd, 2008	Top \| #18
roirraW "edor" ehT Builder/Installer Joined: May 2008 Posts: 530 Reputation: 742 Power: 35	Re: [Office 2007] Tips and Tricks Sounds like Eagle710 wants it to prompt him for the answers to various fields as specified in his email templates. I don't know the answer to his question, however. My experience with related solutions is limited to advanced "mail merge" (I don't know if they call it that any more, or if they ever called it that under Windows applications) using Excel and Word.
	Gigabyte full tower GZ-FA2CA-AJB Gigabyte motherboard MA790X-UD4P HIS Radeon HD 4850 512MB AMD Athlon 64 X2 4400+ 2.3GHz Corsair TWIN2X4096-6400C4DHX 4-4-4-12 4x1TB SATA RAID 0+1/2x640GB SATA RAID 0/Misc. PATA Windows 7 x64

July 3rd, 2008	Top \| #19
Eagle710 OSNN Senior Addict Joined: March 2005 Location: Toronto, Ontario, Canada Posts: 308 Reputation: 40 Power: 65	Re: [Office 2007] Tips and Tricks Originally Posted by roirraW "edor" ehT Sounds like Eagle710 wants it to prompt him for the answers to various fields as specified in his email templates. I don't know the answer to his question, however. That is correct. You hit that dead on the nose. Any help or guidance?

July 4th, 2008	Top \| #20
roirraW "edor" ehT Builder/Installer Joined: May 2008 Posts: 530 Reputation: 742 Power: 35	Re: [Office 2007] Tips and Tricks I wish I could but I don't use templates at all and have no idea what to suggest first. Of course, you were probably asking if anyone else has any guidance.
	Gigabyte full tower GZ-FA2CA-AJB Gigabyte motherboard MA790X-UD4P HIS Radeon HD 4850 512MB AMD Athlon 64 X2 4400+ 2.3GHz Corsair TWIN2X4096-6400C4DHX 4-4-4-12 4x1TB SATA RAID 0+1/2x640GB SATA RAID 0/Misc. PATA Windows 7 x64