Questions tagged [microsoft-office]
Application suite from Microsoft which includes always Word, PowerPoint and Excel. Depending on what edition of Microsoft Office you have you can also have OneNote, Outlook, Publisher and Access.
258
questions
4
votes
5
answers
3k
views
Bulk upload to Skydrive?
I have a bunch of Office documents sitting on my harddrive. I would like to upload them all to my Skydrive account. Is there an automated way to do this?
4
votes
5
answers
64k
views
How can I add new languages to Microsoft Office's spellcheck?
How can I add new languages to Microsoft Office's spell check? I've Googled around a bit, but it's not clear to me.
In particular, I'd like to be able to add Polish spell checking. Is this ...
3
votes
2
answers
13k
views
How to create formatted tooltips in Microsoft Word
Some documents I saw years ago have a feature that, when a word ismouseovereda small popup is displayed with info in it, and when the mouse is moved away from the word, the small popup closes. Maybe ...
3
votes
2
answers
6k
views
Microsoft Excel - Copy Pasting while maintaining reference to a single cell
Let's say that I have a value in cell A5 that is being used to calculate a value in A3.
Example:
A3 = (A1 + A2) * A5
When I copy paste cells A1:A3 and paste onto B1:B3, I'd like the resulting ...
3
votes
1
answer
2k
views
Prompt to enter (custom) document property in Microsoft Word
I created a template with a custom document property called "myproperty". I can access this using fields with the DOCPROPERTY "myproperty" command.
I want to make Word prompt the user for a value and ...
3
votes
2
answers
2k
views
What is a good tool to scrub MetaData from files? [closed]
I am curious if there is a good program that will remove MetaData from multiple document types? Some programs have a "prepare document" feature but it generally only applies to one file type or ...
3
votes
1
answer
133
views
Is it possible to set a style to show line continuations in Microsoft Word?
Sorry if the title is a little unclear. Here's the situation:
I have a bunch of code in a Word document, with a style specifically for code. However, in a few cases it is not clear that a line has ...
3
votes
3
answers
12k
views
Overwrote my presentation with a new blank file, now can't recover it
I had a PowerPoint file with 140 slides that accidentally overwrote with a new blank file of the same name.
I always save my files on SharePoint but this time I forgot it.
I tested applications like ...
3
votes
1
answer
6k
views
Calligraphic letters in MathType
I am trying to typeset equations using MathType in Microsoft Publisher. I think Publisher is an important requirement for me since I am creating an A0 poster.
Is it possible to typeset calligraphic ...
3
votes
3
answers
8k
views
Set Default Paste Format In Microsoft Office Products
I want to change the defaults for pasting in Microsoft Office.
Right now, it appears to default to keeping the source formatting, but I'd like to set the default to match the destination formatting.
...
3
votes
3
answers
14k
views
Can I set up the printer in Word to print in black even if the file has colours?
How can I set up the printer in Word to print in black even if the file has colours?
I noticed if the file has coloured parts, they are not printed.
My printer, Canon MP190, has only black ink.
One ...
3
votes
3
answers
30k
views
Microsoft Word - unable to open https link within document
I cannot open links that starts with https://app.asana.com/ within MS Word 365 documents. I get:
Unable to open http.://... . Cannot download the information you requested
I'm using Windows 10 1803 ...
3
votes
1
answer
6k
views
MS office files downloaded from gmail are not opened
when i download any office file (doc, ppt, xls) from g-mail or any other website they dont open and error msg is displayed that the file is corrupted. i have re-installed MS Office but the problem is ...
3
votes
4
answers
6k
views
Page numbers in contents and footer
I've been trying to work out how to make page numbers skip the first two pages (title page and contents), and also how to have the footer say "page x of y", rather than just the current page which ...
3
votes
2
answers
27k
views
Using Office 2003 normal.dot in Office 2010?
I have a user who I have upgraded from office 2003 to Office 2010. This user relies on his custom auto correct that he built into his normal.dot file for Word 2003. He would not like to have to ...
3
votes
3
answers
2k
views
Launch a batch script as shell instead of explorer in Windows 10
In Windows 10, the default shell is explorer.exe, giving you the taskbar, desktop icons and start menu.
Since Windows 10 v1909, and possibly v1903, Microsoft has decided to use the hyper key (CTRL-...
3
votes
1
answer
6k
views
Excel Validation to Prevent Entry of Two Specific Characters
I'd like to place some validation against a cell in Excel that allows all characters except a "-" (hyphen) and any white space. I've attempted the following but this doesn't seem to work.
=ISERROR((...
3
votes
1
answer
8k
views
OneDrive for Business giving 'Credentials Needed' error on every file
Since changing my password, OneDrive for Business (Office 2013) will no longer sync any files.
It is showing sync errors against every file saying ‘Credentials Needed’ when I click any of these sync ...
3
votes
2
answers
4k
views
Can I still make my Microsoft Office 2010 Starter work again after an Office trial I installed has expired?
I have Microsoft Office 2010 Starter on my Windows 7 laptop when I bought it. At some point, I installed a trial version of Microsoft Publisher 2010. Now, neither Word Starter nor Excel Starter ...
3
votes
3
answers
14k
views
How can I change "save as" behaviour back to path of current document as default?
I use Windows 7. Since a few weeks, the behavior of "Save as" changed under all MS office programs I use (Excel, Word, Project). The behavior now is:
I open a document say D:\dir1\subdir1\subdir2...\...
3
votes
1
answer
1k
views
Ubuntu program most compatible with Microsoft Office?
Microsoft Office uses closed document standards, and anyone who wants to read/write compatible files with a different program has to reverse engineer the formats. This process is often imperfect.
...
3
votes
2
answers
2k
views
MS Word : Priority management between table and paragraph styles
Within a table, some parameters can be set in both the table style and the paragraph style.
How does Word manage priorities between those conflicting settings ?
I made some tests and the rule seems ...
3
votes
1
answer
8k
views
Word 2010 - Mail Merge with Superscript Formatting
I have a user with a letter in Word 2010, built for a mail merge. The source document for the addresses is another Word document. The source document includes addresses that have super-scripted ...
3
votes
1
answer
745
views
Office 365 in English but changing default editing language
I have a quite frustrating problem. I want to use Windows and Office 365 in default English language but use my local (Czech) language as editing one. My problem is that no matter how many times I ...
2
votes
1
answer
6k
views
Ribbon Size in office 2016
When I collapse my ribbon Word 2016, so it autohides, everything looks good:
When I pin it, it changes the size of the ribbon:
It does the same thing in Excel, Outlook, PowerPoint, ...
How do I ...
2
votes
1
answer
2k
views
Microsoft Word 2007 - Force 'Word Count' to just count a specific part of document
In Microsoft Word 2007, I'd like the 'Word Count' feature to just count the words/characters in a specific part of the document automatically.
I know that if I highlight a specific section, it will ...
2
votes
1
answer
6k
views
Excel: Filter on column merged downwards
I have an excel spreadsheet with 3 columns. The first column is merged downwards to be the length of the other cells and contains a document name. The other 2 columns contain an id and some text ...
2
votes
3
answers
2k
views
Outlook 2007 font sizes
Something really strange seems to have happened to my Outlook 2007.
Everything was working fine for a long time now but at the end of today, all of a sudden, all of the fonts in Outlook are messed ...
2
votes
1
answer
28k
views
Oulook '16: Room Finder Button missing / not working after adding it (a second time) to the Ribbon Menu
I noticed I am missing the Room Finger Button in the Ribbon Menu of the New Appointment Windows of Outlook 2016.
I already read this article and checked what is set in my Registry:
https://support....
2
votes
3
answers
487
views
Getting the value in one column from a formula on another column in excel
I have an excel table that looks like this:
Date Original Actual
11/10/10 15 12
12/10/10 12 10
...
24/10/10 2 1
25/10/10 -2 ...
2
votes
2
answers
18k
views
Outlook Categories Not Appearing in Drop Down Menu
This is the issue with Outlook categories drop down menu(in the picture). Problem is that not all categories are appearing. I'm assuming that drop down has a fix number of categories that it can ...
2
votes
4
answers
3k
views
Using Outlook XP and Outlook 2007/2010 side by side on the same PC
I think there are a few questions around whether Office 2000/XP vs. Office 2007/2010 can be installed side by side on the same Windows (XP).
My case currently uses Outlook/Office XP and I am ...
2
votes
2
answers
7k
views
How to check the office version remotely?
If you have a scenario where you are an administrator and you have to check your office version, how can you manage this without going to each PC, disturbing the user and checking it locally?
Is ...
2
votes
1
answer
6k
views
License - Can I use Office 365 Home Premium on a business computer?
I'm thinking about buying Office 365 (aka. 2013) for my own PCs (2), and I could give one copy to the PC here that belongs to a company. The PC also got an Office 2007 (legal), but I'm no legal expert....
2
votes
3
answers
653
views
Office Protected View necessary when I have antivirus?
MS Office 2010 has a "Protected view" feature where it opens documents originating from the internet in read-only mode to protect me from vulnerabilities. I do have an antivirus program (Avira) though....
2
votes
1
answer
962
views
Split rows into different sheets based on a column's value in Excel
+-----+----------+----------+
| a | b | c |
+-----+----------+----------+
| 101 | 12:13:00 | employee |
| 102 | 12:15:00 | customer |
| 103 | 12:20:00 | employee |
| 102 | 12:16:00 | ...
2
votes
7
answers
17k
views
Swap words next to each other in Word?
If I have a Word-document and want 2 words next to each other to change places with oneanother is that possible with some function or logic in Word?
2
votes
1
answer
15k
views
MS Word figure numbers are wrong
I'm working on a Word 2010 document (editing in Word 2013 with compatibility turned on). The document has captions on figures with chapter (set) and number on them, such as "Figure 3-1" for chapter 3, ...
2
votes
1
answer
661
views
How do I find the version number in 'ribbon' versions of Excel?
How do I find the version number in 'ribbon' versions of Microsoft Office?
The Help menu is gone, and menu Help/About had the version information in earlier versions of Microsoft Office.
2
votes
2
answers
16k
views
How to set a textbox to wrap a word to the next line in Microsoft PowerPoint 2016?
A PowerPoint 2016 template used in my office has textboxes that don't wrap words to the next line. So the textboxes appear something like what is shown below.
What should I do to rectify this?
2
votes
3
answers
27k
views
Microsoft Office Compatibility Pack "The converter failed to open the file" error & "This is a pre-release version"
What issues have people encountered with older OS's (2000, XP) and olders versions of Microsoft Office (2000, XP, 2003) with the 'Microsoft Office Compatibility Pack'?
I have a couple of Windows 2000 ...
2
votes
2
answers
260
views
word breaks are in really stupid locations for CamelCase words
Instead of breaking at the word breaks in a CamelCase word, MS Word wants to put in breaks in really stupid locations - not even where the breaks are in the words if they were standalone. Under the ...
2
votes
2
answers
20k
views
How to change icons For MSOffice applications in Windows 7/8 Explorer?
Update: This is NOT for fixing corrupt icons - this is for changing icons, corrupt or not.
Original queston
This is NOT for the library icon nor for the Metro icons. This is for Windows 8 Explorer ...
2
votes
3
answers
29k
views
How to change Microsoft Office Language?
I have Legal license of Microsoft Office 2010 and Legal license of Windows 8.
The OS, Windows 8 is English and the Microsoft Office is Hebrew. It's very uncomfortable, because Hebrew is a Right-To-...
2
votes
3
answers
18k
views
Is it possible to make a custom shortcut to "undo" in Word 2013?
It appears it does not exist in custom shortcuts window and even if I make a custom ribbon item with it in it, it does not appear in the list. Let me know if I miss something.
2
votes
2
answers
10k
views
How can I get a list of cross-references in Microsoft Word?
I wish to know how to see the list of cross references in Microsoft Word. How can I see the things (tables, figures, etc...) that are cross referenced in one table or in one list?
My end goal is to ...
2
votes
1
answer
870
views
Excel validation - can it be used to make sure duplicates are not entered?
I have an excel spreadsheet - is it possible to have validation so that a column cannot contain a value that already exists in the column?
2
votes
1
answer
143
views
Dragon Naturally Speaking 10 enters bad characters in certain text editors in Windows XP
I use DNS 10 in Win 7 without any problems for dictating in office XP and office 2007. I have installed it too on a computer under WinXP and there, with office XP and office 2003 it enters wrong ...
2
votes
4
answers
15k
views
Same RGB-colors looks different in same document (Office 2011 Mac)
I made PowerPoint template on PowerPoint 2010 for PC and everything seemed to be just fine.
But when I opened it on my Mac (PPT 2011), I could see the background color was wrong. So I tripple checked ...
2
votes
1
answer
954
views
Where can I get Offfice 365 Microsoft Store version not the Click-to-Run? [closed]
We had developed a VSTO add-in for PowerPoint. So far (From 2007 - Present) our users are able to install our add-in on traditional MSI base Office (2010,2013,2016) and the Office 365 with Click-to-...