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.
3,277
questions
0
votes
0
answers
22
views
How to remove your name from the title bar of Microsoft Office apps?
Microsoft Office apps display your Microsoft Account name in the title bar:
How to hide/edit/remove it?
People were asking this since showing the name was introduced into Office, and have even come ...
0
votes
0
answers
23
views
Fix blurry view of embedded Visio diagram in OneNote
From within OneNote, I inserted a new Visio File.
Everything looks good in Visio, but when I switch to OneNote the resolution of my Visio view in OneNote is blurry.
Note: It has an odd artifact when I ...
0
votes
0
answers
12
views
How to change the ink colour and size of the pen tool in the slideshow of Microsoft office in Android version? [migrated]
I have Microsoft office paid account.
And it's for Android.
So I am using it in my samsung tablet.
I am using it for teaching purpose, so I must use the pen tool in slideshow. But the pen tool in ...
-3
votes
1
answer
49
views
i have lost office 10 and outlook on my pc
I have lost my office 10 on my PC! I can see all my folders but they are empty. Can I get it back by installing 365?
If my question has all these elements but is still blocked for not meeting quality ...
1
vote
2
answers
71
views
Command Line to Open specific Outlook 365 Calendars
Questions:
How can I open a specific outlook calendar via a command line?
How do I find the values to use in the /select switch?
Work already done:
Using "c:\program files\microsoft office\...
-1
votes
1
answer
43
views
Recommended ways to automatically update several word documents with specific info
I have several word documents (20+) that need to be updated with info like dates, names, addresses, titles. What are some recommended ways to automatically update all of them?
Ideally, I would like to ...
0
votes
0
answers
21
views
Office MS 365 Apps for Enterprise restart withoutsave
I have Office MS 365 Apps for Enterprise installed and after resuming Windows 10 Enterprise after hibernate the office applications sometimes restart.
This would not be so bad except that the content ...
0
votes
1
answer
93
views
In Microsoft Word, is there a way to conditionally format the cell properties of a MS Word Table (like in Microsoft Excel)?
Background: So, in Micrsoft Excel, you may colorize or affect the design/style of a cell via the "Conditional Formatting" feature that is present in the standard/plain vanilla version of ...
0
votes
0
answers
28
views
In Microsoft Word, is there a way to assign particular Bullet Styles automatically to a Heading Style through the Design Features (Themes and Styles)?
What? My goal here is to have Microsoft Word automatically adjust the Bullet List Style in a conditional manner, where the condition is the specific heading style (i.e., heading 1, heading 2, heading ...
0
votes
0
answers
13
views
Reusing (or linking to) a powerpoint slide, with automatic updates from master
I am building a deck in which I need to use the same slide in several places.
Not as a divider with different highlights each time - the slides need to be exactly identical.
Is there a way to "...
-1
votes
1
answer
59
views
Returning value within two column when it match 3 criteria
I would like to return a value 4.42295, if i choose MYR. If I choose SGD will return 1.32963 as picture show below. I had tried some formula in the picture but seem like cannot solve what i need. ...
0
votes
1
answer
57
views
How to make document dimensions match printouts
I would like to be able to specific dimensions in MS Word (*) and have them match in the real world. This seems straight forward, but when I try this they don't match.
A minimal example is an empty ...
1
vote
1
answer
102
views
Excel formula to search a cell value in a row and fill it with an equivalent value?
I have this example excel file:
I want to write a formula in B (column) to search names in A (column) in second table and if it exists, fill it with it's ID value. Is it possible? Final result should ...
0
votes
1
answer
161
views
Cannot change microsoft office 2019 language into English
I have bought and downloaded Microsoft Office 2019 from the international site (where the site language is English) of software-guru.shop - hopefully, a legitimate product. I received a key to ...
-1
votes
1
answer
140
views
Why do Office 16.x installs create "Microsoft Office 15" and "Office15" folders in $PROGRAMFILES and its subfolders?
My laptop has Microsoft 365, and has never had Office 2013 installed on it. But it does have a C:\Program Files\Microsoft Office 15 directory as well as the expected C:\Program Files\Microsoft Office.
...
0
votes
1
answer
199
views
what is preventing activating MS Office 365 on Mac
This is an extremely technical question.
I'm installing and activating Microsoft 365 (was 'Office') on my Mac running 14.1.2. I signed up for a trial subscription, and the software installation goes ...
0
votes
0
answers
28
views
Old publisher file will open with moved objects
I have an old publisher file, when I open it with the latest publisher version (2023) some images and objects are moved to a different location!
But when I open it with the 2007 version everything is ...
0
votes
0
answers
17
views
Publisher 2007 will open files in black and white
I have an old publisher file, it will open in the 2023 version in color mode.
But will open in the 2007 version in black-and-white mode.
What is the problem?
0
votes
2
answers
66
views
How to TEXTJOIN/CONCATENATE based on constraints for specific no of rows count
I need to concatenate certain attribute value based on the sequence number for specific material number and a formula to automate the process.
I have columns as listed in the below screen shot and I ...
0
votes
1
answer
55
views
Command line switch to start excel directly into new a new blank workbook?
When I start excel I get a welcome screen where I can pick a recent document, a new blank workbook, a new template, and other options. I would like to have Excel automatically just open a new blank ...
0
votes
1
answer
195
views
Disable autosave in Office 2019 when logged into OneDrive?
MS Community Question
I have Office 2019, as well as a OneDrive account, and Office 365 on some machines..
When I use Excel 365 and save to OneDrive it defaults to autosave, however I can use the ...
1
vote
1
answer
33
views
How to plot data from separate files and axis intervals onto one chart?
I am running a simulation that exports data as a csv file(things like elapsed time, energy etc).
I have a few million rows of data (but only 5-6 columns), meaning I cannot actually open this file in ...
0
votes
1
answer
216
views
Microsoft 365 - disabling autosave and touch/mouse mode in the Quick Access Toolbar [UPDATE]
I just renewed my MS365 software and I've noticed that when I load Excel or Word, "Automatically Save" and "Touch/Mouse Mode" in the Quick Access Toolbar pop up. I'm able to ...
0
votes
1
answer
93
views
How to move some mails from Outlook.com to free up some space while keeping the complete conversation view in Outlook of Office?
Due to the recent policy changes to the Outlook.com, i.e. 5GB limit on attachment, my email account is running out of space online, and I’m thinking to move some mails offline to free up some space.
...
0
votes
1
answer
210
views
Microsoft Office: Your account has multiple licenses
So I have an older laptop which came with Office Home & Student 2016 for PC. I now got a new laptop with Office Home & Student 2021.
Both laptops use the same live.com account for the licenses....
1
vote
2
answers
125
views
Excel 365 - retain all changes to a file beyond 60 days
Our order review process requires that we be able to tell when a company rep has corrected or changed anything on an order form. The order form is currently an Excel 365 spreadsheet.
A recent revision ...
1
vote
1
answer
2k
views
Word always shows markup/comments automatically when opening a document, even after saving it with "No Markup"
Office Word automatically opens this comment section whenever I open the file, until I select No Markup in the section that says Simple Markup.
But it is annoying to have to do this every time I open ...
1
vote
0
answers
140
views
How to remove custom Office meeting template?
A long time ago I set up a custom meeting template in Outlook Calendar that would include some basic information, a link to a web meeting tool, and some default agenda. When I double-click in my ...
0
votes
1
answer
73
views
How do I stop this install of Office
For a few days now, after a boot, I see this error
Microsoft Office Professional Plus 2010
The feature you are trying to use is on a network resource that is unavailable.
Click OK to try again, or ...
0
votes
0
answers
105
views
How to create Excel histogram from frequency table?
I have an Excel table with two rows.
One header row with positive integers representing different event properties and another row with the frequency of events with said property number.
Here's a ...
0
votes
1
answer
972
views
How can I put this MASSIVE excel spreadsheet as an appendix in word?
I am writing a math report and in it I need to include appendices, the only issue is that two of them are absolutely massive excel spreadsheets with over 2000 rows each that would just not be ...
0
votes
0
answers
1k
views
Missing Registry keys: HKEY_CURRENT_USERS\Software\Microsoft\Office
I have a bit of a pickle: One of my clients does not have an Office Directory in their Registry (HKEY_CURRENT_USERS\Software\Microsoft\Office). We use M365 and the Office Suite was installed through a ...
0
votes
0
answers
154
views
Offline Installation and Updating of Microsoft 365 on Remote Desktop Services (RDS) Server
In an environment where my RDS 2019 server lacks internet connectivity, what steps should I follow to download Microsoft 365 installation files to another machine, transfer them to the server, and ...
1
vote
1
answer
440
views
How to apply the MATCH() function only to a filtered range? Or is there another way to do that?
I have a filtered list of values. Let's say I have the numbers from 0 to 5, and 2 is filtered out:
A (with auto-filter against "2")
0
1
3
4
5
Now I want to find out whether one of the ...
1
vote
1
answer
168
views
Hyperlink does not change along with cell when filtered
I’m having a problem with hyperlink when using filters. So let’s say I have these table rows:
A
B
C
I have a hyperlink to cell C using the usual hyperlink option. But if I change the filter from “A to ...
2
votes
3
answers
810
views
How to back up Documents with OneDrive, while also using another cloud service?
I use OneDrive for Business on Windows 11 and I want to back up the Documents folder on my harddrive to OneDrive.
In the OneDrive settings I go to "Sync and backup > Manage backup". Here, ...
0
votes
1
answer
58
views
when I try to output the final version of my document as pdf, my cool new Google (or other) TrueType font changes weight
I love how many fonts are available for free from Google and other places, as well as from subscriptions like your Adobe plan.
When I finished a document recently with a popular TrueType font from ...
0
votes
2
answers
94
views
Does the Outlook 365 UI in Cached Exchange Mode periodically lock up for everyone with a spotty Internet connection?
I spend a lot of time in Outlook in-flight where the connection is spotty. For years, I've noticed the UI often freezes for several seconds, sometimes longer, if it loses connection with Exchange ...
0
votes
0
answers
22
views
How to change the order of explorer-contextmenu
I've created a contectmenu in Explorer on desktop with 9 options for Office :)
How can I change the order of the items?
For me the most important App is Excel then outlook, word, Access, ...
But ...
1
vote
1
answer
190
views
If Excel has an accuracy of 15 significant figures, why are there presets for number styles with > 15 decimal places?
And what is the difference if it was 0,############... or #,########...?
0
votes
0
answers
63
views
Cmd uninstall string not working
I have to remove a software from several computers with remotely. Uninstall-Package and wmic commands seems working but not working, the software still there.
I thought I can uninstall with uninstall ...
0
votes
0
answers
49
views
Main Office 365 (O365) left navigation pane keeps opening and closing
When I'm logged into Microsoft O365 on the main/primary dashboard, the left navigation pane that shows all your applications keeps opening and closing on its own. What is causing this and how can I ...
0
votes
0
answers
128
views
How do I make calendar entries for a Microsoft 365 dynamic group appear in the member's individual calendars?
I have a Microsoft 365 dynamic group with a number of calendar items in it. If a member views the group calendar in Outlook they can see the items but this requires them to manually select the ...
0
votes
0
answers
43
views
(Microsoft Word) How to stop styles opening in a box?
I'm trying to make some text be in the style of Header 1, Header 2, Header 3, etc
When I change the style of text, it opens up in this box instead of staying normal text that is in line with the rest ...
0
votes
1
answer
158
views
Outlook 365 online, Outlook online, creating folders: View contents of subfolder in parent folder for team emails
I am super new to MS, windows and Office since I worked in Apple my whole life. here is my goal which I could do in Apple mail, thunder mail and others.
Folder My sales team.
Subfolders
Bill, jack, ...
1
vote
1
answer
433
views
Can a hyperlink in MS Word or Excel open in a non-default browser?
Environment: Windows 11, Office 2021 running on computer, not in "cloud".
My default browser is Firefox and I don't want to change that. But some websites are not compatible with Firefox, so ...
1
vote
1
answer
381
views
How to fix legacy and third-party systems that send emails to office365 users?
Esp. in the last couple of years, we have seen steadily increasing problems when our internal applications/servers send emails (reports, alerts, warnings, and what-not info) to our internal employees/...
1
vote
0
answers
93
views
Prevent Microsoft Word from reducing image resolution when publishing *.docx as web page
When saving as a web page from Word (365), is there any chance of having the images on the web page thus created in high resolution?
Although the maximum resolution for images is set in all ...
0
votes
2
answers
165
views
Get unique IDs with date 1 or date 2. For IDs with both date, obtain row with most recent of the 2 dates
I have been trying to retrieve the row in the following sheet (sheet1) where the dates are matching dates in sheet2 without duplicating the IDs in Sheet1 (Column B)
Sheet1
Sheet2
In other words, I ...
0
votes
0
answers
43
views
Open a server hosted file (from a desktop) using IP not working, but using name works
I've a strange issue when trying to open a Word .doc, docx or an excel file .xlsx (haven't tried other files types):
If I double click a file hosted on Windows 2019 by traversing to it with a desktop ...