Hide multiple sheets at one time with vba
I would like to hide specific sheets while using an if then statement when two other sheets are already hidden. Here is what I have: If Sheets("A").visible=False And Sheets("B").visible=False Then…
Microsoft 365 and Office | Excel | For home | Windows
how do I fix this formula?
I am getting a name error. Someone else wrote it and cannot reach them for help. I am not good with formulas this advanced. thank you =_xlfn.IFS(OR(ISBLANK(K2)), "", (K2=0), "Does not meet", (K2=1), "No response to 1st…
Microsoft 365 and Office | Excel | For home | Windows
Can't find Outlook 2016 after install
I just uninstalled Office 365 because I don't want to pay the year-after-year subscription fee anymore, and I don't want the constant updates. I purchased and installed the Office Home 2016 suite. Install went successfully without error messages. I'm …
Microsoft 365 and Office | Install, redeem, activate | For home | Windows
Maximum number of displayed values in SharePoint Online Refinement Web Part limited to 50?
Hi, I'm working with a client on SharePoint Online that is using navigation terms to tag documents. This comes through in search as RefinableString00. In a summary/landing page, we are using a Content Search Web Part to return search results for the…
Microsoft 365 and Office | SharePoint | For business | Windows
How to make Navigation Pane open embedded within an existing window instead of in its own separate window? Word 2013
I accidentally hit something that is making the Navigation Pane open in its own separate window. It's very confusing. I want it to be embedded within the window of my document the way that the Reviewing Pane is. How to fix this?
Microsoft 365 and Office | Word | For home | Windows
I just discovered something about Excel on conditional formatting based on formulas you made.
That when one pastes a worksheet based on values, that the color assigned to the cell is not retained, but will be amended depending on the changes you made in the rows/columns. Well, I do hope that in the future when pasting based on values, that the…
Microsoft 365 and Office | Excel | For home | Windows
Tech Issue: Cursor runs left in MS Word document. After it reaches the beginning document, MS Word is stuck minimized/inactive
I'm on ASUS laptop, Windows 10. This has happened to me several times while I was typing in MS Word document. Suddenly, after a certain keypress or something, my cursor started running left as if I was holding down the left arrow key. Nothing I did…
Microsoft 365 and Office | Word | For home | Windows
Office 2016 professional plus misssing morphing effect in Powerpoint
Hello. In company that I work for we have Office 2016 professional plus subscription, and I got my copy of Office installed today. I relised that Powerpoint douesn't have Morphing effect at all on trasnition tab. Is it possible that in highest level of…
Microsoft 365 and Office | PowerPoint | For home | Windows
Adding DNS records to a domain name
Hi, Have just signed up for a Office 365 Business Essentials account and elected to manage my own DNS records but stuck at Step 3 - which relates to adding DNS records to domain so hope someone in the community forum can assist. There is a line which…
Microsoft 365 and Office | Install, redeem, activate | For home | Windows
Office 2016 Version 1609 (Build 7870.2038)
Can anybody please tell what's in this update? I downloaded this a few days ago; however, I cannot find any information about it. The link at https://technet.microsoft.com/en-us/office/mt465751?f=255&MSPPError=-2147217396 only shows Office…
Microsoft 365 and Office | Install, redeem, activate | For home | Windows
"Discover" part of OneDrive
I noticed a lot of documents that I am not sure I should have visbility to show up when I click on the "Discover" sub-tab of my OneDrive. What determines if a document shows in that space? Is it people in my organization posting to a public…
Microsoft 365 and Office | OneDrive | For home | Windows
Closing PPT and returning to desktop
I have a training presentation that is set up in kiosk mode and saved as .ppsx (show)file. When someone finishes the training, I need for them to be able to close the file and go back to the desktop screen so the next person is able to click on a…
Microsoft 365 and Office | PowerPoint | For home | Windows
Office 365 OneDrive - Delete Unique Permissions for all items in a folder
Permissions for files in a user's subfolder do not match the permissions of the subfolder itself. I can change the permissions by clicking on Sharing>Advanced>"Delete Unique Permissions" to restore the permissions back to the subfolder…
Microsoft 365 and Office
onenote hyperlinks on images
Hi. Our students use the onenote with tablets. When we paste an image in the onenote notebook and create a hyperlink in this image the onenote notebook users are able to open the hyperlinks holding ctrl + left click. Every other hyperlinks are opened…
Microsoft 365 and Office | OneNote | For home | Windows
Excel suddenly turned gray
Several times recently, I have been in the middle of using excel when this has happened: My curser is stuck on the vertical arrows for expanding cell height and will not allow me to click anything in the gray area or the formula box. I can click on the…
Microsoft 365 and Office | Excel | For home | Windows
My copy and paste jobs of single=spaced documents appear as double-spaced in teh e-mails I'm sending.
Why is it when I copy a single lined document )a poem) and maybe 5 at a time and paste them into my e-mail to be sent to an editor they either come out double-spaced at once or as I read them in the sent box and/or a cc sent to myself they appear as…
Microsoft 365 and Office | Word | For home | Windows
Goal Seek Macro for Multiple Cells
I have forecast, sales and forecast accuracy columns. I want to calculate the revised forecast if I increase forecast accuracy by 20%. Is there a way to use Goal Seek to calculate the revised forecast without running it for each line of data? There…
Microsoft 365 and Office | Excel | For home | Windows
How do I increase the number of recent files?
I wish to increase the number of recently worked on files, that are displayed in the drop down window when I click "File". There are presently only four (4), of the most recent documents showing. Thanks, Larry [Original title: Microsoft…
Microsoft 365 and Office | Word | For home | Windows
Shared mailbox not showing up in Outlook 2013/2016
We've created a shared mailbox in Office 365 Admin center, added a few users as members but none of them seeing the share mailbox in outlook. As per the link below, it is supposed to show up automatically. Given that all members has both read write…
Microsoft 365 and Office | Subscription, account, billing | For home | Windows
Updating "Shapes" in PowerPoint
As a powerpoint designer currently in the design process, I want to be able to edit a logo that is used on many slides in many different positions on the slides so that a single edit to the logo will update all the logos on all the slides that utilize…