Categories
Office 2016

How To Quickly Navigate Through Multiple Excel Tables

If you work with large Excel workbooks that contain multiple tables, it can become very tedious moving from one to the other. This is a quick and easy way to do just that and I think you will love it.

Follow the steps below to learn how:

  1. Simply click the drop-down arrow next to the Name box.
  2. Click on an item in the list and you will immediately jump to it!

Told you that you’d love it!

Categories
Carol's Ramblings

Carol’s Ramblings

Can you believe it is November??? Well you better believe it.  How could you not?  I mean the television is showing Christmas and holiday advertisements and I heard Christmas Carols on the radio today!!!  Could we please just have Thanksgiving first??

We have gone from temperate weather to frosts and freezing ! Holy cow! I do detest being cold even though I enjoy the change of seasons.

I hope you enjoy the articles this month as much as I enjoyed writing them for you. Please remember those less fortunate than yourselves during these cold months.

And please remember to let those you care for know that you do.  You have no idea how this can change someone’s outlook. Smile at as many folks as you can too.  It will make then smile back at you and then you will both fee good!

Until next time, take care of you!

Carol-signature

Categories
Subscribers Excel 2016

Subscribers: How To Create Two Line Custom Formats

Excel is very flexible in how it will allow you to set up custom formats for displaying all manner of values. Most custom formats are straightforward and easy to figure out, once you have an understanding of how custom formats work.

Suppose you wanted to create a two-line custom format, though? For example, you might want to format a date so that the abbreviated day of the week and day of the month is on the first line, and the full name of the month is on the second line. Using such a format, your date would appear as shown below.

format-example

Most of this can be done by the custom format ddd d mmmm, but you have to figure out a way to add a line break between the d and the mmmm. Excel will not let you press Alt+Enter between them, which is what you normally do to add a line break.

The solution is to use your numeric keypad to enter the desired line break in the format.

Follow the steps below to learn how:

  1. Select the cells you would like to format.
  2. Display the Home tab of your Ribbon.
  3. Click the small icon at the bottom-right of the Number group to display the Number tab of the Format Cells dialog box.
  4. In the Category list, select Custom.

format-cells

  1. Delete whatever is in the Type box.
  2. Key in ddd d.
  3. Depress the Alt key while you key in0010 on your numeric keypad. This will enter the line feed character, and it looks like the portion of the format you keyed in in step 6 disappears. It is not really gone, but has moved up above what can be displayed in the Type box.
  4. Key in mmmm.
  5. Click the Alignment tab.

alignment

 

  1. Be certain  the Wrap Text box is selected.
  2. Click OK.

After setting up the format in this way, you will need to adjust the row height of the formatted cells so that the entire two lines of the date will display.

 

 

Categories
Subscribers Word 2016

How To Merge & Split Cells In A Table

Working with tables in your Word document can seem complicated at times depending on what you are trying to accomplish. If, for example, you are trying to create a form, merging cells is a common activity you might employ. Follows the steps below to learn how: Select the cells within your table and click Merge […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Subscribers Word 2016

Subscribers: How To Replace Without Automatically Finding

One of my subscribers uses Acrobat InDesign more than she uses Word, and some of the differences between the two are very frustrating to her. For instance, in InDesign, she can use Find and Replace to replace without automatically moving to the next occurrence of what she is finding. This allows her to visually look […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Subscribers Word 2016

Subscribers: How To Use Hidden Styles In Your Documents

I just read an article about a user who was revising a long list of styles in a template and came across the Hide Until Used feature in the Recommend tab of the Manage Styles dialog box. If she marks a style as hidden, it does not show up in the list of styles, so […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Word 2016

How To Protect Blocks Of Texts In Word Documents

Many of my subscribers lament the fact that WordPerfect used to have Block Protect wherein you would highlight a block of your text and protect it so that it would always appear on the same page.

Well guess what? You can do that in Word also! Is it that simple? Well I suppose you could say no, because Word actually has TWO different versions of Block Protect:

  • Keep Lines Together and
  • Keep With Next

Follow the steps below to learn how to find and use these:

Click the little launcher at the edge of the Paragraph group on your Ribbon. This will open the Paragraph dialog box.

paragraph-dialog-box

You can now select one or both of these options.  What is the difference you might ask? See below.

Keep With Next will keep two or more lines of a single paragraph together (i.e., it will keep a block of text that does not have a hard return or a line break within the block all on one page).

Keep Lines Together will keep lines from separate paragraphs together on a single page (i.e., a heading  and the first few lines of your paragraph). This is for a block of text that has one or more hard returns or line breaks or line breaks in the middle of it.

If you cannot decide which you need, you can always use both and it will still work for you. Just do not try to block protect very large blocks of text or you will run into problems.

Categories
Subscribers Office 2016

Subscribers: How To Insert Public Holidays in Outlook 2016

If you would like your Outlook calendar to include all the public holidays, you do not have to Google them and  insert each and every one of them individually into your calendar. Outlook can automatically add them to your calendar for you! And there are almost 100 different locations to select from. So if you […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Subscribers Word 2016

Subscribers: How to Fix Unwanted Foreign Language In Word

Have you ever had Word all of a sudden change your text to foreign lettering? For example, without warning when you key in the question mark you will get an "e" with an accent, and the "~" (tilde) produces a ".#" All of the keys seem to be remapped to the foreign language and you […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!