How to Easily Move Worksheets from One Workbook to Another with Excel VBA

If you want to move sheets from one workbook to other workbooks, follow this article and create your own tool to automate the task. Quickly select necessary sheets and copy it swiftly to all other target workbooks Let's Prepare the GUI This tool needs a single sheet in the macro-enabled workbook. Rename the Sheet 1 in the workbook as "ControlPanel". As shown in the image, create necessary fields to allow the user to pick the source workbook, display sheets from the selected workbook and an...

Read more »

4 Methods to Remove Footnote or Endnote Separator in Your Word Document

In this post, we would like to share with you 4 methods to remove footnote or endnote separator in your Word document. If you ever insert a footnote or endnote into document, you will find there is always a horizontal line over the texts. This separator marks out the footnote or endnote area clearly. Yet, some people may find it annoying and would like to get rid of it. This article will provide you with 4 methods to do so. Method 1: Remove Footnote Separator Manually Firstly, click...

Read more »

3 Ways to Batch Change Text Format in All Text Boxes in Word Document

In this article bellow, we want to show you 3 ways to batch change text format in all text boxes in your Word document. Text boxes are often seen in out documents. While format document texts, we cannot forget those in text boxes. However, text boxes scattering in a document can make you hard to select all texts inside once and for all. Therefore, out of formatting purposes, it’s urgent to learn some trick to do the batch processing. Method 1: Utilize “Advanced Find” Feature ...

Read more »