Tag Archives: word

CustomUI Editor Part II

Add your own icons to your own ribbon

In this post i will show you how easy it is to add your own icons to your own ribbon in Microsoft Office. For this example i will use a Word document but you can just as easy make this in Excel and PowerPoint. In earlier posts i wrote about the custom UI editor. This insanly great tool for creating your own ribbons in Microsoft Applications. So that will be the tool i am using in this post. You can download the custom ui editor tool here.

The example i am creating here is a simple Word document with a custom tab with custom icons.

First make a word document which you want to use for this example. I will call it: Custom Icons. The custom UI editor tool was last updated for 2010 but to show that you can easily use this for 2013 documents i created a 2013 Word document. So the document is created, saved in a location and we are good to go. You can click on the various images to see enlargements!

Open the CustomUI editor

The next step is to open the custom ui editor. Choose open en locate your document to which you want to add a custom ribbon. For my example i created an empty Word document with no fancy stuff attached. A plain word document. Next step is to choose a type of ribbon you want to add. For this example i’ll choose a custom tab.

CUE_I CUE_II

Now with that in place you will see that de custom ui editor has presented you with some sample XML in de code window. This is the code you have to modify later on. We will first add our own icons attached to the document. For that i will add some sample icons i have stored on my pc.

CUE_III CUE_V

these are the icons i have added to my ribbon:

CUE_IV

The first time i added some icons this way i was a little startled because i did not see anything happen. You have to click the plus sign to actually see that the icons are added to the document.

CUE_VI CUE_VII

Ok, we have the document, we have the icons all we need to do now is modify the existing xml which was created when we chose custom tab at the beginning. If you are like me and you don’t want to typ to much you will use copy / paste. There’s nothing wrong with that but remember that all the buttons should have unique id’s in order for the ribbon to be created. So copy paste and rewrite the id’s for every button. Als modify the imageMSO part. imageMSO is an internal reference to existing icons from Microsoft Office. Because we are using our own icons you have to reset this option to image=”iconname here” (where iconname here is the name of your custom icon!).

CUE_VIII

The last step we have to do is to check if our ribbon will actual show up in our document. For the sample i have set two icons to large and three of them to normal. This will give you the next output:

CUE_IX

Yep there it is, my very own tab in my ribbon with my very own icons! Wow how cool is that. All done with the custom ui editor!


Pitfalls
Is there anything else i should know before i start taking these steps or will it always work. The only thing you have to remember is adding icons this way the only restriction you have is the size of the icons. In the sample i created here i added icons which have a size of 48X48 pixels. You will just have to test what the maximum size is for adding it to your tab. My advise? stick to 48 x 48 and smaller. That size fits perfectly!


Happy customizing ūüôā

Advertisements

Modify The Style Of Your Table Of Contents

Creating a nice looking table of contents
Sure we have read numerous documents which contained TOC’s. Most of them are pre-generated by Word. A great feature and very easy to use. You create your document, apply heading styles to certain headers and choose “insert table of contents” from the ribbon. But what if that table of contents just doesn’t do it for me? How can i adjust the various options in a table of contents. In this post i will show you a way to modify the auto generated Table Of Contents.

A reference
A table of contents is nothing more than a reference. You can actually see this after you have created a table of contents. For this post i’ve created some dummy text and created a table of contents.

Now take a look at this table of contents after we have pressed ALT-F9.
Continue reading

Calculating In Word Tables

Every now and again¬†I stumble upon Word users who still use their calculator to sum the amounts they have typed in their tables. When I tell them that Word is capable of doing that for them they are actually surprised. So let’s take a close look at the table and calculation options in Word.

Regular table
Ok let’s take a look at a regular table you can create in Word. In the example below¬†I just created a table with¬†2 columns and 5 rows. Everyone knows these tables. In the last row in the second column we want to sum all the prices so there will be a neat totals row. To create a total we place the cursor on the sixth row in the second column. Now we¬†go to¬†the contextual ribbon “Layout” and click on the [Formula] button on the far right.

I am assuming you are using Word 2010 here. In 2003 and earlier you will find the formula option under the “tables” menu. You will see the next dialog pop up: (Click on the image to enlarge)

 

 

 

 

 

Now when you click OK you will see that there is a total of 113 in the sixth row. Neat right? If you want you can also set the number format.

Refresh the table after prices change
Ofcourse prices can change. If they do and you want to refresh your total row then place the cursor in the ‘old’ total (it should become grey so you know you are actually updating the field) and now you press F9. Your totals row should be updated now.

Calculating with text in my table cell?
Many people don’t know they can do the same even if there is text in the cell let’s say before the price. Take a look at the picture below. I’ve taken the same table and added some text in two lines. Now let’s see if the calculation still works.

 

 

As you can see Word still calculates the correct total. The great advantage here is that you can actually type some text before your numbers and the calculation will still be done by Word. How is that for a word processor!

And what if we added a text row between the prices. In the following picture you will see that¬†I added a row with Outlook Calendars which our out of stock. That’s what¬†I typed in the price column. Will Word still calculate the correct total? It will!

 

How about this one?
Take a look at the following table (picture below). How would you calculate the sum of these numbers? We are looking for a totals sum of all the numbers in the very last cell.

Mini Excel
When you do calculations in a Word table you can actually see the table as a mini Excel grid. If you have any experience with excel you know that columns have letters and rows have numbers. So the first column in your Word table is column A and the first row in your Word table is row 1. The second column is column B and the second row is row 2 and so on. So in fact for Word the table looks like this:


 

Looking at this we can say that In cell A1 we see number 12 and in A2 we see number 11. With that knowledge we are now able to do the math in the very last cell. So place the cursor in the very last cell of the Word table. Click the formula button again in the contextual tab in the ribbon. You will see the formula dialog pop up. Instead of the regular =SUM(ABOVE) we alter the statement to:

=SUM(A1:H3) and click OK. You will see that Word places a total of 113 in the very last cell.

What did we do?
We wrote the formula =Sum(A1:H3) in the dialogbox. This means that we wanted everything between the range of A1 to H3 to be summed. If you know any of he functions in Excel you might also want to try AVERAGE or MAX for that matter.

So now you know that you are actually using the excel grid can you create a totals row in the last cell summing only the red bold faced numbers as show below?

 

 

Happy Crunching ūüôā
 

Create Content That Gets Noticed

Documents, Presentations, and Workbooks by Stephanie Krieger
This is one of those books that really should be on your shelf. Of course we all create documents and think they look nice. Very often though we produce the final piece by using techniques we mastered ourselfs. But how about some structure in those techniques? Stephanie Krieger is one of those writers and users who knows exactly what we are talking about.¬† A dedicated Microsoft MVP so¬†you know you get value for money. You can get a glimps of the intro of the book here¬†and as you know by now there is always a sample chapter you can read on the MSPress blog. So if you are in doubt to buy this book or not… click here and let this chapter convince you.

Happy Reading

Maus