0
votes
5answers
38 views
Custom toolbars in Office 2007
My company recently upgraded from Office 2003 to Office 2007. When I was working in Office 2003 I created a really useful little floating toolbar with lots of useful little tools. …
3
votes
5answers
32 views
How can I get the traditional menus back in Word and Excel 2007?
While the new Office 2007 ribbon is neat / cute / whatever, this particular old dog is familiar with the traditional Word and Excel menus. How can I get those menus back? Is ther …
0
votes
1answer
20 views
How do pivot tables work in Excel?
I've come across the concept of Pivot Tables, but don't really understand them. Can anyone enlighten me?
0
votes
1answer
60 views
Shortcut key to insert a new Pivot Table in Excel
I use Pivot Tables a lot and I find myself clicking through the wizard every time i need to perform a quick pivot. Is there a shortcut to quickly create a pivot of the selected ra …
2
votes
6answers
11 views
Useful MS Word shortcut keys
What are some short-cut key strokes that you find the most useful for MS Word.
Obviously Ctrl-C, Ctrl-V.. but any other than that?
2
votes
2answers
19 views
Creative ways to play Jeopardy using PowerPoint
Hi,
I am an educator and want to use PowerPoint to play a quiz-like gameshow with my class - like Jeopardy. Getting started, this looks to be quite a task. I have slides prepare …
0
votes
2answers
24 views
VBA code to compact and repair Access database
This should be a fairly simple request:
I am looking for the VBA code to execute a compact and repair on the current database.
Thanks
2
votes
3answers
17 views
Splitting full name into First Name and Last Name columns
I have a column containing the full name of a person, such as John Smith. I need to split this single column into two individual columns with FirstName in one and LastName in the …
1
vote
2answers
17 views
Create copy of spreadsheet data only - without formulas.
I need to send copies of calculated data to other departments on a regular basis, but I do not want them to be able to see (or change) the formulas I use to arrive at the calculate …
1
vote
1answer
18 views
How to hide menus and table browser in Access on startup
I am working on an Access application that will auto-start when a user opens the file. I would like to restrict the user from being able to edit forms, tables, and queries within …
1
vote
3answers
16 views
Openoffice vs. Ms Office?
I hear Openoffice can do the same as Ms Office, but for free.
Is it true?
0
votes
3answers
16 views
Reminder in Outlook that Subject Line is empty, like in Gmail
Gmail has a great feature to let you know that the subject line is empty when you attempt to fire off an email without providing a subject.
Is there a setting in Outlook that can …
1
vote
1answer
18 views
Images in PowerPoint are showing up as red X with error
I have pulled some slides from another PowerPoint presentation into my current presentation, and all of the images are appearing as a red "X" I am also receiving the following err …
0
votes
3answers
59 views
Add Padding to text in Excel
I have Contracts that are of varying size but I need them to be 14 characters. This is how I do it.
A1=A1234567
A2=A123456789
B1=MID('00000000000000',1,14-LEN(A1)) & A1 --> …
0
votes
1answer
15 views
Creating a tear-off flyer for distributing phone number and address info in Word
Hi all,
I need to create a "tear-off" flyer to advertise a bike that I am trying to sell. I am not very proficient in word, especially tables in word.
Are there any good templ …
