How to auto-fill the file path in the footer when printing MS Excel
Have you ever lost track of the destination folder for Excel workbooks printed on paper?
This article will show you how to automatically enter the file path in the footer when printed on paper for such occasions.
The way to do this is to create and edit a macro that fills in the footer with the file path and displays a print preview. Then place the macro’s button on the Quick Access Toolbar.
Step 1: Record a macroIn the tab View, click on Macros and select Record Macro.
Rewrite the macro n ...
Comparison of how to convert MS Word document to PDF for free
Microsoft Word has an export function that converts a document to PDF and saves it.
However, the image quality of the PDF may be worse than expected, and the file size may become large.
In addition, bookmarks may not be displayed correctly in Word 2016 and later versions.
Therefore, this article will investigate and compare four free PDF conversion methods available, focusing on the following three points:
Image quality
File size
Bookmarks
MS Word’s PDF export functionWord 2007 and later ve ...
How to optimize images to reduce document file size in MS Word
This article examines how to insert images in a Microsoft Word document so that the file size of it is smaller.
The conclusion is that the following four points are important to reduce the file size while keeping the image from being too blurry.
How to choose a format
Image width should be 640px
The working order should be as follows: 1. Crop / Resize, 2. Compress, 3. Insert into MS Word
Check MS Word option "Do not compress images in file"
How to choose a formatAs a result of the experimen ...
How to deal with the “bookmark” bug when saving a Microsoft Word document as a PDF
This article describes a bug that causes the bookmarks to display incorrectly when saving a document as PDF in Microsoft Word 2016 and how to deal with it.
The conclusion is that in order to convert documents created in Word 2016, 2019 to PDF without the bug about bookmarks, open the document in Word2010, 2013 and save it as a PDF or convert the document to PDF using Adobe.com.
What are bookmarks in PDF?The bookmarks in PDF are the “hyperlinks to the headings” that appear in the left panel as ...
How to refresh the caption numbers, heading numbers, and table of contents in Microsoft Word
In the last three articles, I’ve shown you how to number figures, headings, and tables of contents in Microsoft Word. This article describes how to update the numbers that will be out of sequence when you replace the text.
If you read the following three articles first, you will understand the contents of this article well.
How to number headings in a Word document using styles and multilevel listsWhen writing "headings" in a document created in Microsoft Word, using styles and multilevel list ...
How to Insert Figures and Captions in Microsoft Word
This article describes how to insert figures into a document created in Microsoft Word. I will also show you how to insert captions linked to heading numbers.
"Order" is very important when inserting figures and captions.
If you make a mistake in the order, it will increase the trouble, so be careful.
TutorialStep 1: Set headings with styles and multilevel listsWhen setting up captions, headings must be set in the styles and multilevel lists before ins ...
How to add table of contents and page numbers in Microsoft Word
This article describes how to add a table of contents and page numbers to a document created in Microsoft Word.
Note that in order to create a table of contents, the style “Heading” must be applied to the paragraph that should be the heading.
The following article shows how to set the style “Heading.”
How to number headings in a Word document using styles and multilevel listsWhen writing "headings" in a document created in Microsoft Word, using styles and multilevel lists to number the "headin ...
How to set heading colors and indentations in Microsoft Word
This article will show you how to set the color and indentation of headings among Microsoft Word features.
Target appearanceThe target document format for this article is shown below.
The main points of this setup are as follows
The background of Heading 1 style is dark gray and the text of it is white so that the boundaries of each chapter can be easily identified.
The indentation of Heading 2 style should be deleted.
The indentation of Heading 3 style should be 20.
Please read the follo ...
How to number headings in a Word document using styles and multilevel lists
When writing “headings” in a document created in Microsoft Word, using styles and multilevel lists to number the “headings” will not only make it easier to keep the appearance of the document consistent, but also make it easier to edit, such as replacing sentences.
If you’re manually numbering or changing the font size for each headline when writing a “headline,” you should read this post.
The version used in this post is Word 2016.
TutorialStep 1: Set the style to the paragraph for headings ...
How to create an easy-to-update chart using PivotTables / PivotChart from data combined by Power Query
This article will show you how to create a chart showing the total amount of each group after combining multiple Excel books with Power Query.
This method allows you to easily recreate tables and charts even if data is replaced or added.
Excel books used in this tutorialThe Excel Book to be used this time is an Excel Book that combines three Excel books with Power Query.
The combined Excel book has data as shown in the figure.
This is an Excel book ...