File Recovery Archive

After inserting many comments in an Excel workbook, you may want to customize the fonts of all the comments. In this situation, you can refer to this article. Here we will share you 2 easy methods.

As we can see, the comments inserted in Excel automatically use the default font. At times, you may want to alter the comments’ fonts. If there are a few comments, you can simply use the following Method 1 to manually change them. However, if there are hundreds of comments, you are better off selecting the latter means.

Method 1: Change One by One

  1. First off, select a comment in the worksheet.
  2. Then, right click on it and select “Format Comment” from the context menu.

    Select "Format Comment" Menu Item

  3. Next, in the small popup dialog box, you can select fonts and styles to your liking.

    "Format Comment" Dialog

  4. Ultimately, click “OK”.
  5. Later, you can use this way to manually change comments one by one.

Method 2: Batch Change via VBA

  1. For a start, launch Excel VBA editor with reference to “How to Run VBA Code in Your Excel“.
  2. Then, in the “Microsoft Visual Basic for Applications” window, put the VBA code below into a project or module.
Sub BatchChangeFontsOfAllComments()

    Dim objWorksheet As Excel.Worksheet

    Dim objComment As Excel.Comment

   

    'Process all worksheet one by one

    For Each objWorksheet In ThisWorkbook.Worksheets

        If objWorksheet.Comments.Count > 0 Then

           For Each objComment In objWorksheet.Comments

               With objComment.Shape.TextFrame.Characters.Font

                    'Specify font name and size

                    .Name = "Comic Sans MS"

                    .Size = 10

                    'Use RGB function to create a color value

                    .Color = RGB(255, 0, 0)

                    .Italic = True

                    .Bold = True

               End With

           Next

        End If

    Next

End Sub

 

VBA Project

  1. Later, run this macro simply by pressing “F5” key button.
  2. Eventually, after macro finishes, back to the worksheets.
  3. As you can see, the fonts of all comments have been changed, as shown in the following screenshot:

Change Comment Font Result

Comparison

Advantages Disadvantages
Method 1 Quick and easy to process a small amount of comments Very troublesome in case of too many comments
Method 2 Very efficient regardless of the number of comments Increase risks of virus infection

Restore Compromised Excel File

When your computer suddenly shut down, if some Excel files haven’t been saved, the next time when PC boots back up, you may find the Excel files are corrupted. At this point, if you would like to get back the files, you have no choice but to take aid of a powerful and reliable Excel recovery tool, like DataNumen Excel Repair, which can recover corrupted Excel data with effortless ease.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including fix sql and outlook repair software products. For more information visit www.datanumen.com

Many users complain a lot about the pretty long time when they attempt to restore an iTunes backup to iPhone. Now, in this article, we will teach you how to fix it in 6 easy troubleshooting steps.

To avoid data loss, one of the most effective approaches is to back up data on a regular basis, no matter in terms of your computer or phone data. For example, when you encounter PST corruption, if you have backups, you can easily restore PST data without needs to repair PST file. However, at times, some troubles may occur when restoring backups. For instance, some iPhone users are disturbed by the issue that restoring iTunes backup to iTunes appears to take forever. Here we will guide users to fix it in 6 steps.

Restoring iTunes Backup Takes Very Long Time

Step 1: Disconnect iPhone

First off, you need to disconnect the iPhone from the computer. Please remove it safely instead of directly ejecting it violently. Otherwise, it’ll damage your iPhone without letting you know. One day, you may find some apps inaccessible or some files are compromised and so on.

Step 2: Upgrade iTunes

Then, you ought to check if the iTunes on your computer is the latest version. At times, the outdated iTunes may contain some vulnerable bugs, which can lead to the excessively long restoring time. Hence, in this step, you have to upgrade your iTunes application.

Step 3: Reboot iPhone & Computer

After that, you have to reboot both your iPhone and computer. It is because that the culprit may be the phone or computer itself. For instance, there may be too many processes running on your computer in the background, which leads to this issue. At this point, a simple reboot can assist you to eliminate such troubles with ease.

Step 4: Try iTunes Restore Again

At present, when iPhone and computer boots back up, you can retry to restore an iTunes backup to your iPhone. On the iPhone, launch “Restore from Backup with iTunes”. Then, connect iPhone to computer and let restoring backups go on to see if the problem persists.

Step 5: Restore iCloud Backups Instead

Assuming that iTunes backup restoration is still in such a dilemma, perhaps it is the time for you to consider the other iPhone backup features, such as iCloud. Do you have iCloud backups? If so, you can try to restore iCloud backups instead.

Step 6: Contact Apple Support

Last but not least, provided that you still persist to restore iTunes backups, you have no alternative but to contact the relevant experts, such as the official Apple support. They promise to provide users with free support in its warranty. Hence, you must be able to gain effective helps from them.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql fix and outlook repair software products. For more information visit www.datanumen.com

When flagging a contact, some users hope to get a standard Outlook task in To-Do List instead of a flagged contact. Now, in this article, we will introduce a method to let Outlook auto create a task for call the contact person later when flagging a contact.

As we all know, when flagging a contact, the contact will display in the To-Do list. But, most of time, what we really want is a standard task for calling this contact later and contains the telephone numbers of the contact only in task body. Hence, here we will introduce a method to configure Outlook to auto create such a task. Read on to get more details.

Auto Create a Task to Call the Contact Person Later when Flagging a Contact

  1. At first, launch Outlook VBA editor with reference to “How to Run VBA Code in Your Outlook“.
  2. Then, open the “ThisOutlookSession” project and put the following code into it.
Private WithEvents objContacts As Outlook.Items

'Works for contacts in the default Contact folder
Private Sub Application_Startup()
    Set objContacts = Outlook.Application.Session.GetDefaultFolder(olFolderContacts).Items
End Sub

Private Sub objContacts_ItemChange(ByVal Item As Object)
    Dim objContact As Outlook.ContactItem
    Dim objTask As Outlook.TaskItem

    If TypeOf Item Is ContactItem Then
       Set objContact = Item

       If objContact.IsMarkedAsTask = True Then
          If objContact.TaskCompletedDate = "1/1/4501" Then
             'Create a task for calling this contact
             Set objTask = Outlook.Application.CreateItem(olTaskItem)
             With objTask
                  .Subject = "Call " & objContact.FullName
                  .StartDate = objContact.TaskStartDate
                  .DueDate = objContact.TaskDueDate
                  .Attachments.Add objContact
                  .Body = "Business: " & objContact.BusinessTelephoneNumber & vbCr & "Home: " & objContact.HomeTelephoneNumber & vbCr & "Other: " & objContact.OtherTelephoneNumber & vbCr & vbCr
                  .ReminderSet = True
                  .ReminderTime = objContact.ReminderTime
                  .Save
                  .Display
             End With
             objContact.ClearTaskFlag
             objContact.Save
        End If
      End If
   End If
End Sub

VBA Code - Auto Create a Task to Call the Contact Person Later when Flagging a Contact

  1. After that, put cursor in the “Application_Startup” subroutine and press “F5” key to activate this macro.
  2. Finally, exit the VBA editor and try this macro right away.
  • Select or open a contact and flag it.Flag a Contact
  • At once, a new task will be displayed, like the following screenshot.Popup Task
  • Meanwhile, as you can see, the contact’s flag is automatically removed.

Repair Compromised PST Files

Like Word documents, Outlook PST file is also prone to corruption. Many users have been plagued by the problems related to inaccessible PST files. Fortunately, Outlook comes pre-installed with an inbuilt repair utility – Scanpst. It is indeed able to fix a majority of small PST issues. Yet, when confronting seriously corrupt PST file, it seems ineffective. Thereby, at that time, you have to take aid of a more powerful tool, like DataNumen Outlook Repair.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql recovery and outlook repair software products. For more information visit www.datanumen.com