[May 1, 2010]
I just hung a new birdhouse on one of our trees today. It looks really cute and I am hoping that it will attract more songbirds to our property. There will be more bird houses and bird feeders going up around here. I love to watch the birds flitting in and out of their houses and bullying each other at the feeding trough. It provides great entertainment for me.
I live in a very rural area and to my dismay this morning I found that a small animal got into some sort of disagreement and definitely was not the winner of that argument by the looks of my front sidewalk. I am bowed by life's little tragedies even though I know and understand the circle of life and the food chain. I guess it cannot be a bad thing to exhibit compassion for living things right?
Please be patient if you have sent me an e-mail in the last several weeks or so and have not heard from me. Bbear in mind that I receive hundreds of e-mails every day so please be patient. I will respond as soon as I am able.
Please join me now in welcoming Joyce B., Joyce D., Michael, Alan, Dave, Christine, Sally, and Kenneth as the latest premium subscribers to Carol's Word Bytes Newsletter. Welcome to the family! If you know someone who struggles with an application in Microsoft Office, like Word or Excel, do them a favor and tell them about our newsletter. They will always thank you for it!
Don't forget to take a look at the free version too. It includes:
Let's get to the tips now!
Table of Contents
Change Cell Formatting from Date to Number - Have it your Way!
Quickly Copy Formatting in your Excel Worksheet - So easy!
Moving Between Workbooks in MS Excel - Use Shortcuts!
 |
|
Change Cell Formatting from Date to Number
When you want to change your cell formatting in MS Excel from Date to Number, follow the steps below:
- Click Ctrl + Shift + ~>.
Go ahead and try it out.
- Enter today's date in a cell by clicking Ctrl + ;.
- Then click Ctrl + Shift + ~> to change the format to General formatting.
Nice little shortcut isn't it?
Quickly Change Formatting in your Excel Worksheet
To copy the formatting, use the Format Painter.
- Click the Format Painter icon to copy and apply formatting.
To repeatedly copy formatting:
- Double-click the Format Painter icon to repeatedly apply formatting.
Moving Between Workbooks in MS Excel
Use keyboard shortcuts to move between your workbooks in MS Excel:
- The keyboard shortcut for moving to the next open workbook is either Ctrl + Tab or Ctrl + F6.
- To move to the previous open workbook, click Ctrl + Shift + Tab.
- Click Alt + W to open the Window menu and then the workbook index number.
Included in the Premium Newsletter:
- Emphasize Important Values in your MS Excel Chart
- Customize your Keyboard Shortcuts in MS Word
- Copy MS Excel Formatting from one Worksheet to Another
- Change the Default Contacts Folder in MS Outlook
- Custom ScreenTips in MS Word
- Add Subscripts and Superscripts to a Cell in MS Excel
Shouldn't you be a premium subscriber?? With a premium subscription, you get more than double the content and NO advertising! Plus, most instructions come with clear screenshots! With your premium subscription you also receive access to an archive of five years of newsletters and deep discounts on all books and tutorials I publish!! So what are you waiting for? Sign up today!
Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.