Changing the default font of Excel 2010 comments on a cell

With the following VBA code, you can change the font size and the font of the comments in cells, but it can’t change the font colors. please use the following VBA as:

1. Click Developer > Visual Basic, a new Microsoft Visual Basic for applications window will be displayed, click Insert > Module, and then copy and paste the following codes in the module:

Sub FormatAllComments()

Dim ws As Worksheet

Dim cmt As Comment

For Each ws In ActiveWorkbook.Worksheets

For Each cmt In ws.Comments

With cmt.Shape.TextFrame.Characters.Font

.Name = “Times New Roman”

.Size = 14

End With

Next cmt

Next ws

End Sub

In the above code, you can set the.Name and.Size variables as you would like.

2. Then click button to run the code. And then click Review > Show all comments to view the comments, all of the comment formats in the whole workbook have been changed. See screenshots:

---

A handy tool to change all comment formats quickly and time-saving

If you want to quickly change other types of format for all comments, you may try to use the Cell Comment Tools of Kutools for Excel.

Kutools for Excel: with more than 120 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now

After installing Kutools for Excel, please follow the following steps to change the comment formats:

1. Format one comment with the style that you want to apply to other comments.

2. Click Kutools > More > Cell Comment Tools, see screenshot:

3. In the Cell Comment Tools dialog box, click Format tab, and choose the scope that you want to change the comment format, you can choose Active sheet or All sheets. Then click Specify the comment cell button to select the cell which contains the specific comment format you want to apply. See screenshot:

4. Then click Close button to close the dialog box, and the selected cell comment format has been applied to other comments.

Microsoft Office 2013 or Office 365 hangs during setup.

Solution:

There can be many possible reason for office 2013 setup application hangs during installation.

You can try following steps to make it up and running.

Please try to repair office 2013 from control panel and do online repair to complete the installation process.

1.) Open Control panel–>Add Remove Programs–>Microsoft Office -> Repair.

2.) Wait for the installation process and do not open any application.

If setup hangs between 80% and 90%, stop the print spooler service on your PC.

Problems with the print spooler service may cause setup to hang between 80% to 90%.

You can temporarily stop the service, try to install Office again and then restart the service to fix the problem:

 

1. On a Windows 8 PC, type services.msc from the Start screen and tap or click services in the list of results.

2. On a Windows 7 PC, click Start > Run, type services.msc, and then click OK.

Look through the list of services, find Print Spooler, and open it.

3. Tap or click Stop, and then tap or click OK.

4. Try installing Office again.

5. Once Office is installed on your PC, go back to the list of services and open Print Spooler.

6. Tap or click Start, and then tap or click OK.

 

If setup hangs right at 94%, restart the PC

If you haven’t already tried restarting the PC, do this if setup hangs right at 94%.

We couldn’t free up space on the clipboard. Another program might be using it right now.

While dragging the cells or Merging the cells in excel 2013 you might get the error.

“We couldn’t free up space on the clipboard. Another program might be using it right now”

Cause:

There could be any reason for this error message and it occurs when your memory usages will increase.

Like using skype,bing desktop toolbar,Zone allarm,Multimon taskbar,team viewer,Ask Toolbar.

Solution:

Step 1: Look into event viewer for the error code.You can type Eventvwr.msc in Run Window.

Step 2: Open Task bar and close and exit the that process which might causing the issue.

Step 3: If possible un install all those programs mentioned above to check the status.

Step 4 : Try to increase the Virtual Memory of your computer.You can right click on mycomputer-> properties -> Advanced -> Visual effects -> update the max memory to your computer.

Hope this will fix the issue.

Excel 2013 crashes in windows 8.1.

Open the following path in your computer.

Or

Search for the osf.dll file in your computer.

 

1) C:\Program Files\Microsoft Office 15\Root\Office15\

 

2) Look for osf.dll and rename it to osf.dll.old

 

3) Close the application.

 

4) Restart the application.

 

I Hope this will fix the issue.

 

Please leave your comments if this the fix.

Outlook 2013 crash on calendar invite?

Solution:

There might be couple of reasons for this issue but one can perform the following troubleshooting.

1)Try to Repair office 2013 from control panel and go for a full on-line repair.

2)Try removing the windows update from the list.(http://support.microsoft.com/kb/2817631)

Or

1. Close Outlook 2013

2. Navigate to C:\Program Files (x86)\Microsoft Office\Office15

3. Rename WWLIB.DLL to WWLIB-ORIG.DLL

4. Download the older WWLIB.DLL (15.0.4517.1505) from here: https://citrix.sharefile.com/d/s2d8d60fbe2b4d3d8

5. Place WWLIB.DLL into C:\Program Files (x86)\Microsoft Office\Office15

6. Open Outlook.

How to Use your Windows phone as a remote control for Office on your PC.

Solution:

Please follow the instructions below:

1) Go to Bluetooth settings > Bluetooth > On.

2) On your Phone, go to Settings > Bluetooth > On.

3) When your computer’s name appears on the phone screen, tap tap to pair.

4) On your PC, select Ready to pair > Pair.

5) While pairing, the same PIN will appear on both devices. When you confirm this, the devices will indicate that they’re connected.

Tip    If this status later changes to “not connected”, don’t worry. Once the two devices are paired, there’s

After you’ve paired your phone with the PC, do the following:

1) On your PC, open the file you want to present and on the Office Remote tab, select Office Remote, Turn On.

2) On your phone, open Office Remote. The file you opened in step 1 and any others that are open on your PC should appear.

3) Tap to open one and start presenting.

Download: To get the latest version of Office Remote on your PC, download it here.

http://office.microsoft.com/en-us/mobile/redir/XT104146176.aspx?CTT=5&origin=HA104142493

Right-Click is not working in office 2010?

1.) Try to open word in safe mode.

 

      a) Open RUN Window(Window key+R).

 

      b) Type Winword /Safe.

 

2) Disable All the third party addins from word.

 

      a) Go to the File menu in Word and choose options > Add-Ins.

 

      b) In the list above click add-in. Choose “Manage COM Add-Ins” at the buttom and click “go”.

 

      c) Disable or Delete all the third pary (Non Microsoft) addins.

There was a problem sending the command to the program Excel 2013 Error.

Solution:

There could be different reasons for this error to appear in office 2013 applications after upgrading from the old office versions.

 

Fix it:

1.Open RUN window(Windows Key + R).

2.Type Regedit and press enter key.

 

3. Click on file and Export a back of registry on desktop.

 

4. Navigate Hey_Classes_Root\Key\Excel.openspredsheet.12\shell\open\command

 

5. Change the key value: EXCEL.EXE /dde < to >  EXCEL.EXE /e “%1”.

 

6.Save it by pressing F5 key from keyboard.

 

7. Try to open your excel documents.

 

Note: If after changing the above registry value did not resolve the issue.You can try to changing the same value for all other excel key hives in registry.

 

You can also try doing this.

1.Click the File tab, and then click Options.

 

2.Click Advanced, scroll down to the General section, and then clear the Ignore other applications that use

 

3.Dynamic Data Exchange (DDE) check box in the General area.

 

4.Click OK.

Outlook 365 Error:”Can’t set up Outlook 365 Exchange email account”.

Cause:

1.If you are trying to configure your outlook 2013 with auto discover mode(Auto).

2.If the previous version of outlook had some settings that new outlook 2013 doesn’t support.

3.If the Existing outlook profile do not recognize the default settings.

 

Solution:

1.Configuring Outlook Anywhere

 

In most cases, when your company has made Outlook Anywhere available to you, Auto Account Setup will be able to find the correct settings for you via AutoDiscover. In that case, all you have to do is provide your name, email address and password, wait until Outlook locates your settings and you are good to go.

 

Note: In some cases, you might get prompted for your username and password again in a separate dialog. Depending on the configuration of the Exchange infrastructure and domain of your company, you may need to change the username in that password dialog from your email address to the domain\username format. Ask your Exchange administrator for more support if that isn’t accepted either.

 

If you are setting up your Exchange account manually, click the More Settings… button, select the Connection tab, enable the option “Connect to Microsoft Exchange using HTTP” and then click on the Exchange Proxy Settings… button. You can now fill out the Outlook Anywhere settings.

 

If you do not know if Outlook Anywhere has been made available to you or which settings are required, you’ll have to ask your Exchange administrator or IT support department.

2. Creating a new profile for outlook 2013.

If you are not able to get rid of the error message, Try to create a new outlook 2013 profile.

1.Open control panel.

2.Locate Mail icon in control panel.

3.Click on profiles.

4.Create a new profile for outlook 2013.

5.Make the new profile default for outlook.

6.Configure the email account as per the settings you have for it.

7.Close control panel and open outlook 2013.

Outlook 2013 Error” Cannot start Microsoft Outlook. Cannot open the Outlook window.”

Solution:

While there are various reasons for this to occur in outlook 2010/2013.
In these instances, the configuration file for the Navigation Pane gets corrupted and prevents Outlook from starting successfully.

To recover, you can start Outlook with the resetnavpane switch;

Method 1

Windows 8 and 8.1

Window button+R ->outlook.exe /resetnavpane

 

Windows Vista and Windows 7

Start-> type; outlook.exe /resetnavpane

 

Windows XP

Start-> Run; outlook.exe /resetnavpane

 

Please note the space between outlook.exe and /resetnavpane.

 

Method 2

1. Click Start, and then click Run.

 

2. Copy and paste, or type the following command in the Open box, and then press ENTER: control panel

 

Note If you are using a 64-bit version of Windows, double-click View 32-bit Control Panel in Control Panel to display the Mail icon.

 

3. Open the Mail Setup dialog box:

 

For Windows 7:

If Control Panel is in either Large icons or Small icons view, click Mail. The Mail Setup dialog box appears.

 

If Control Panel is in Category view, under View by, click to select either Large icons or Small icons, and then click Mail. The Mail Setup dialog box appears.

 

For Windows Vista or Windows XP:

If Control Panel is in Classic View, double-click Mail. The Mail Setup dialog box appears.

If Control Panel is in Category View, under Control Panel, click Switch to Classic View for Windows XP, or click Classic View for Windows Vista, and then double-click Mail. The Mail Setup dialog box appears.

 

4. In the Mail Setup dialog box, click Show Profiles.

5. On the General tab, under When starting Microsoft Office Outlook, use this profile, click

Prompt for a profile to be used, and then click Add.

6. In the Profile Name box, type the name that you want to use for the new email profile, and then click OK.

7. In the E-mail Accounts dialog box, click Add a new e-mail account, and then click Next.

8. Click the appropriate server type for your new email account, and then click Next.

9. Type your account information in the required boxes, and then click Next.

10.Click Finish, and then click OK.