Categories
Subscribers Word 2010

Subscribers: How to Increase Address Lines in Envelopes in Word 2010

If your job requires you to use very long addresses in the Word envelopes that you create, you most certainly have noticed that word limits the number of lines you can use in an address. Now you will not necessarily see this limit while you are creating your envelopes or labels from the Tools menu, […]

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
OneNote 2013

OneNote – Sync Automatically or Manually???

Sometimes you may be required to work offline and sometimes you just like to work offline! So in either situation, here is how you can sync and un-sync your work manually rather than leaving syncing set to Automatic in OneNote 2013.

Follow the steps below to learn how:

In Sync Status, select Work Offline | Sync only when I click Sync All.

Verify that your status is Not Connected.

You can now make any edits or changes and not have your work sync before you would like.

Once you have finished working offline, if you have not manually un-synced your Notebook, you will automatically re-connect and sync your work automatically, including sharing your Notebook to a SharePoint site.

To manually return to syncing, simply select Sync Status | Sync All or Sync Now.

 

Categories
Excel 2010

How to Get Help with Worksheet Functions in Excel!

There are times when you need a function in Excel and you know what it has to do with and perhaps part of the name, but just cannot remember the full function name!  I know as I age it happens to me more frequently than I care to admit!

If you, like I, have the same problem, follow the steps below to get some help with your Worksheet Functions:

  1. If the function has a lengthy name, key in what you remember and click the Tab key to AutoComplete the name for you.
  2. Once you have the function name, plus the first open parentheses, key in the part of the name you can recall and click CTRL + A to display a dialog box to help you complete the functions with explanations of each argument.

Function Arguments

  1. For more information on the function, click on the Help on this function link on the left-hand bottom corner of the Function Arguments dialog.
Categories
Carol's Ramblings

Fall is Here…

Well, Summer is just about finished – over – kaput!  It was great while it lasted though, wasn’t it?

We took a small vacation with my daughter and her husband and children and went to the beach.  The first couple of days were great! We took the children to the boardwalk and my oldest grandson got to go on the rides and eat on the boardwalk.  He also got to go to the beach and frolic in the ocean with his daddy.  He went to the pool with his dad and played in the children’s fountain.  He had a great time.  His little brother is too young to do any of that.

Everything was fine until the third day and then my grandson woke up from his nap burning up with a fever and he was delirious and so his parents took him and his little brother home and we went home the next day.  I am grateful though that they were able to enjoy those three days though.  Turns out my grandson had the Hand, Foot, Mouth virus and a couple of days later his brother had it and then so did I!  No fun I can assure you but I would rather be with the boys than without them!

So I am hoping that you have all had a nice vacation to recharge your batteries and get geared up for the Fall and coming Winter months.  I would love to hear about your vacations!

I finished knitting a scarf for  my daughter and made a little pair of Santa mittens for my youngest grandson.  I need to get busy and work on a pair for my oldest grandson and a pair for both of my granddaughters. Have to keep it fair.  In my “spare” time I am crocheting a blanket for my oldest grandson’s bed.

I still manage to work full time and publish this newsletter so I think I am ok.  Below are pictures of the little mittens I knitted.

Santa Mittens

Take care of you until the next time and remember to be kind to and help your fellow human beings!

 

Carol

 

Categories
Excel 2010

Adjust the Width of your Columns in Excel

Sometimes you inherit an Excel worksheet from one of your colleagues and discover that you cannot see all of the data that has moved outside the cell and is hidden.

  • In this instance, you can very quickly adjust the width of your column (columns) using your mouse.
  • Simply select the column and move your cursor to the edge of the column until the plus sign appears.
  • Drag to the right until you have reached the width you need.
  • If you would like to expand multiple columns, select a column, then drag to the right until all columns you need to adjust have been selected.
  • Now, go to the edge of the farthest column, until the arrow with the cross appears and expand to the right

These are great time savers!

Categories
Excel 2010

Quickly Delete A Column in Excel

If you work with very large Excel Workbooks, you know that you can spend quite a bit of time deleting columns of data.

You can delete a column (or row) by right-clicking on a cell in your column and selecting the delete option. This can, however, become wearisome when you have lots and lots of columns to delete in your worksheet.

I suggest using a keyboard shortcut instead.  We all know that I love to save time and keystrokes!

  • Simply select your column and click CTRL + – (minus sign).
  • You can quickly add a columns by clicking CTRL + Shift + = (equal sign).

There are usually more than one way to accomplish something in Excel and this is no exception.

You can also right-click and delete multiple rows (i.e., ten rows). Simply select the rows, right-click and select Delete. If you still have rows to delete, just use your F4 function key to do the rest!

Categories
Excel 2010

Hide and Unhide Columns and Rows in Excel

You may or may not know that you can hide and unhide rows and columns in Excel.  There are many reasons why you would want to use this feature, such as when you have huge worksheets, you sometimes have to scroll back and forth to access the data you need. It is certainly easier to have the data you need right in front of you!

Follow the steps below to learn how to Hide and Unhide rows and columns:

  1. To hide a single column, select any cell in that column and click CTRL + 0 (zero).
  2. To hide a single row, select any cell in the row and click CTRL + 9.
  3. Alternatively, to unhide a row that you have previously hidden, select the range and click CTRL + Shift + 9.
  4. To unhide a previously hidden column, select the range and click CTRL + Shift  + 0 (zero).

When you have hidden columns, you will notice a light coloring between your columns which indicates that a column has been hidden between them.

Categories
Subscribers Word 2010

Subscribers: Backup Copies in Word?

Word does not, by default, make backup copies of your documents for you. Instead your old document is deleted after the new file is written to your hard drive. Some word processing software does provide backup copies by default. Alas Word is not one of them. There is, however, a way to make Word provide […]

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 2010

Subscribers: Save Document Using the Same File Name in Word

I have a reader who has written to me inquiring about the documents he takes home to work on.  It seems like the documents he brings home on his flash drive always open in Read Only. I asked him if he had the same version of Word at home as he does at work and […]

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 Excel 2010

Subscribers: Move Part of Your Footer Down a Line in Excel

You have your Excel Worksheet all set up, complete with custom footer which you will have appear at the bottom of every page in your workbook and in that custom footer you have the file path and name of your worksheet (left justified) and also page numbering (centered). Ok, great right? But wait - sometimes […]

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!