fixed : add total number of pages to page numbers in Word for Mac

Question :
I am working in Word (from Microsoft Office for Mac) on a multi-page document and I want to include the page numbers including the total number of pages.

How do I do that ?


Answer :
In Word 16 (the current version of the texteditor from Microsoft Office for Mac) it is straight forward to include page numbers. To include page numbers in your Word document, do this :
– have your document open in the Word.app
– click on ‘Insert’, either in the top menu bar or in het document’s menu bar
– then click on ‘Page Numbers’
-and in the small ‘Page Numbers’ popup screen that now opens, set the desired position (Top/Header or Bottom/Footer), the desired alignment (Left, Center, Right, Insides or Outsides) and put a checkmark if you wish to have the ‘Page number shown on first page’ also
– then click ‘OK’ and page numbers will automatically appear on all pages

However… if you also want to include the total number of pages next to the page numbers, you cannot do that this way or any similar way… you will need a completely different method :
– have your document open in Word.app
– first make sure you are on the first page of your document
– now, click on ‘View’ in the top menu bar
– then, in the pulldown menu, click on ‘Header and Footer’
– then, click with your cursor in either the Header or the Footer, depending on where you want the page numbers
– click on ‘Insert’ in the top menu bar
– in the pulldown menu, click on ‘AutoText’
– and in the next pulldown menu, click on ‘Auto-text’
– in the ‘AutoCorrect’ popup window that now appears, click on the ‘AutoText’ tab/button
– then scroll though the alphabetical list and choose “Page X of Y” andd click the blue ‘Insert’ button
– now, eacht page will have both page number and total number of pages in the Footer (or Header) of each page
– so, basically you’re done now
– but… if you want do do some customization, you can…
– to change the font of the page numbering, just select the text “Page 1 of 22” (if your document has 22 pages) and choose the desired font and font size
– to change the “Page 1 of 22” into something like “1 of 22” or “1 ( 22 )”, just select the part of the “Page 1 of 22” text that you want to change and adjust it to your liking [ and if you accidentally delete either the page number or the total number of pages, just redo from start ]

That’s it !

enjoy 😉

fixed : place a picture behind an Excel chart or graph

Question :

I am using Excel (from Microsoft Office) and I want to put the chart I’ve just made on top of a picture. How can I do that ?

Answer :

In Excel v14 (from MS Office 2011 for Mac), this can be done like this :

1- create the chart

2- select the chart area (you will see a bold, light blue frame around the entire chart area), then click the “Charts>Format”-tab (the purple tab in-between the green tabs), then in “Current Selection” click the “Format Selection”-button

3- in the window that opens select “Fill”, then the “Solid”-tab, and set the “Color:”-dial to “No Fill” and click “OK”

4- select the chart itself (inside the chart area – you will see a black lined square with light blue dots on the corners around the actual chart), then again, click “Charts>Format”-tab (the purple tab in-between the green tabs), and again, in “Current Selection” click the “Format Selection”-button

5- in the window that opens, again select “Fill”, then the “Solid”-tab, and set the “Color:”-dail to “No Fill” and click “OK”

6- then de-select the chart

7- in the upper Excel menu bar that’s fixed in the Finder, select the “Insert”-tab, and from the drop down menu that appears, select “Photo > Picture From File” and in the “Choose a Picture”-window that appears, select the image you need and click “OK”

8- the image will appear on top of your chart, now first resize it (by dragging the light blue corner-dots) and place it over your chart area

9- select the image (again, if it’s not already selected), click the “Format Picture”-tab and remove the background color(s) of the image if you need (using the “Remove Background”-option from “Adjust”)

10- then, also in the “Format Picture”-tab, select the “Reorder”-option from “Arrange”, and select “Send to Back” from the 4 options that appear in the pulldown menu ; your image will now be behind your chart

11- for fine-tuning, if needed, you can now resize or rearrange the image and the chart until the align exactly as you need them to

12- if you want the Excel-cell-grid behind your chart to disappear also, select the area of cells behind and around your chart and select WHITE (or any other color you need) from small triangle-shaped arrow just next to the “Fill Color”-button (the paint bucket icon)

That’s it !

Enjoy !

Donate Button (all)