How to: Hide spelling error/wavy red/blue lines in Microsoft Word How to: Disable spelling/grammar check in MS Word

When we have spelling error or grammar errors in our document, Word will underline them with wavy red or blue lines. Sometimes we don’t want to see those lines.

The symptom:

e.g. in a Lorem ipsum document

Lorem ipsum document with wavy red lines and blue lines
Lorem ipsum document with wavy red lines and blue lines

The Fix

1 Click on the “File” on menu bar

Click on "File"
Click on “File”

2 Click on “Options”

Click on "Options"
Click on “Options”

3 Click on “Proofing” – Scroll to bottom – Check “Hide spelling errors in this document only’ – Check “Hide grammar errors in this document only” – Click on “OK” button

Click on "Proofing - Scroll to bottom - Check both Hide spelling errors and Hide grammar errors options - OK"
Click on “Proofing – Scroll to bottom – Check both Hide spelling errors and Hide grammar errors options – OK”

4 Now there is no spelling and grammar check for this document hence there is no red and blues lines in the document

Document without spelling and grammar check, no red and blue lines
Document without spelling and grammar check, no red and blue lines

5 If you want to keep the settings, so that next time when you open the document there will be no lines as well then Save the file by click on “Save” button, if you want to see those lines again next time for this document, then Click on “Don’t Save”

Save, or Don't Save
Save, or Don’t Save

How to: Compare two Microsoft Word documents easily and quickly rather than read word by word manually

1 Launch the Microsoft Word

2 Navigate to “Review -> Compare” click on “Compare”

Microsoft Word - Review - Compare - Compare
Microsoft Word – Review – Compare – Compare

3 Click on the folder icons to load correct Word documents, then click on “OK” button

Compare Documents - Select files
Compare Documents – Select files

4 By default, it uses “Simple Markup”, this is not very clear for finding differences, we can change it to “All Markup” to make it easier for us

Simple Markup
Simple Markup
Change to All Markup
Change to All Markup

5 Now we can see the difference easily

Compare results
Compare results

How to: Migrate/Move from Microsoft StaffHub to Microsoft Teams Shifts with PowerShell

1 Migration

1.1 Launch Microsoft PowerShell in Admin mode (Make sure you have Microsoft Office 365 Admin global admin account)

1.2 Chances are you might need to run following command first, if you are not sure, just run it, won’t hurt

Set-ExecutionPolicy Unrestricted

1.3 Try to install MicrosoftTeams PowerShell Module with following commands

Install-Module MicrosoftTeams
 
Import-Module MicrosoftTeams

If the above command failed, continue to try following

Install-Module -Name PowerShellGet -Force
 
Install-Module -Name MicrosoftStaffHub -RequiredVersion 1.0.5-alpha- AllowPrelease

1.4 Close the PowerShell window then relaunch PowerShell in admin mode again

1.5 If you are using basic authentication, execute following command to login

$crd = Get-Credential
 
Connect-MicrosoftTeams -Credential $crd
 
Connect-StaffHub -Credential $crd

1.6 If you are using two factor authentication or Multi-factor authentication (MFA) use following command to login instead

Connect-MicrosoftTeams -AccountId [email protected]
Connect-MicrosoftTeams - AccountId username@contoso.com
Connect-MicrosoftTeams – AccountId [email protected]

1.7 Connect to StaffHub in PowerShell and login (Compatiable with MFA)

Connect-StaffHub
Connect-StaffHub
Connect-StaffHub

1.8 Get StaffHub teams information with following command

Then Note down the Team “Id” “TEAM_xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx” which you want to migrate to Microsoft Teams Shifts

Get-StaffHubTeamsForTenant
Get-StaffHubTeamsForTenant
Get-StaffHubTeamsForTenant

1.9 Move StaffHub team to Microsoft Teams

(Remember to note down the JobId from following the command result)

Move-StaffHubTeam -TeamId "TEAM_xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
Move the team to Microsoft Teams (The team ID TEAM_...  is the one we have noted down in step 7)
Move the team to Microsoft Teams (The team ID TEAM_… is the one we have noted down in step 7)

Check the Migration status

Once done with the Migration steps, we can check the migration job status

2.1 Use following command to check the migration job status

(Use the Job ID that we have recorded from step 1.9)

Get-TeamMigrationJobStatus -JobId "JOB_xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
Team Migration Job Status
Team Migration Job Status

2.2 Check if the StaffHub Teams is managed by Teams

Get-StaffHubTeamsForTenant
Get-StaffHubTeamsForTenant
Get-StaffHubTeamsForTenant

Now we have successfully migrated from Microsoft StaffHub to Microsoft Teams Shifts

Resource

Move your Microsoft StaffHub teams to Shifts in Microsoft Teams


How to Fix: OneDrive Error … is unavailable, if the location is on….

The Error

When opening the File Explorer/This PC, following error pops up:

“C:\Users\%username%\Folder Name is unavailable. If the location is on this PC, make sure the device or drive is connected or the disc is inserted, and then try again. If the location is on a network, make sure you’re connected to the network or Internet, and the try again. If the location still can’t be found, it might have been moved or deleted.”

Usually this occurs after the reported folder has being deleted or moved.

The Fix

1 Exit OneDrive

2 Create the missing folder, e.g. if the missing folder mentioned in the error is “C\Users\Jack\Desktop”

Then create corresponding folders “C\Users\Jack\Desktop”

3 Start the OneDrive or OneDrive for business again, the error should be gone now


How to Fix: Microsoft Word Error, can’t save to OneDrive, can’t save…

The Error

Word saving files to onedrive

Sorry we couldn’t find https://……… is it possible it was moved, renamed or deleted?
The file you are merging into is currently in use, Please try again later.

The Fix

We need to repair the Office.

Method 1

1 Use start menu to search “Control” then open control panel or Use Win + R key combination to open “Run window”

Microsoft Windows - Run window
Microsoft Windows – Run window

Then type “appwiz.cpl” then hit Enter key to bring up the “Programs and Features” window

2 Find office, click on “Change -> Repair”

Method 2

If you are using office 365, you can just download the office installation file from Microsoft, then repair install.

Possible Errors during installation/rearing

If the following error appears

Installing office
Something went wrong
Error Code: 30010-4

Close all windows related to the office and office rearing properly.

Restart the Windows Operating System.

Then try to install office again.

When the rearing or installation is done, there should be on problem to save to OneDrive, OneDrive for business, or save to local hard drive.


How to: Keep leading zero in Microsoft Excel

Usually, when entering leading zeros in a number cell or general cell, the leading zeros will not retain and will be removed.

If we want to keep the leading zeros, here is how:

1 Right click on the cell which we want to keep leading zeros for, then click on “Format Cells…”

Microsoft Excel
Microsoft Excel

2 Follow the steps, Click on “Custom” then type zeros under the “Type”, if you want to Three digits then enter three zeros, then click on “OK” button to save the changes for this cell

Microsoft Excel - Format Cells
Microsoft Excel – Format Cells

3 Now we can see the leading zero retained for the cell if the value is less than 100.

Microsoft Excel - Format Cells - 000
Microsoft Excel – Format Cells – 000

Extended Reading- Alternatives

We can also format the cell to “Text” format rather than “Number” if we are not doing any calculation with that cell.

There are 2 ways to do this

Method 1

Instead of type 001 in the cell, we can type ‘001, this way it’s stored as text, the leading zeros will be kept as well.

Method 2

Using the “Format Cells” mentioned in the beginning, we can click on “Text” instead of “Custom”, the leading zeros will be retained.

Bottom line/Rule of thumb

If you don’t care what format the data should be stored as, then use whichever method you are happy with.

Generally, we should store data in correct, it might save us huge amount of time in the unknown future, that means, if there is only numbers going to be saved in the cells, then it’s better to format those cells as “Number”


How to fix: Cannot move or copy folders. Cannot copy folder. A top-level cannot…

The Error

When copy and paste folders/contacts in Outlook/Office 365 from/to public folders, the following error pops up.

Cannot move or copy folders. Cannot copy folder. A top-level cannot be copied to one of its subfolders. Or, you may not have approriate permissions for the folder. To check your permissions for the folder, right-click the folder, and then click Properties on the shortcut menu.

The Fix

1 Open Exchange admin center (https://outlook.office365.com/ecp)

2 Navigate to “public folder -> public folders”

Exchange admin center - public folders
Exchange admin center – public folders

3 Navigate to the public folder which is having the problem.

4 Assign that user as “Owner” of that specific public folder

Exchange admin center - public folders
Exchange admin center – public folders
Exchange admin center - public folders - Public folder permissions
Exchange admin center – public folders – Public folder permissions
Exchange admin center - public folders - Public folder permissions
Exchange admin center – public folders – Public folder permissions

5 Try the operation again, once finished, change back the permission for that user to “Author” or other permission.