Categories
Excel 2007

Create a Bulleted List in a Single Cell or Text Box in Excel

As you know, you can enter multiple lines within a single cell by simply clicking Alt + Enter, which starts a new line for you.

Follow the steps below to learn how to create your bulleted list:

  1. Click in the cell or text box where you would like to add bullets.
  2. Holding down your Alt key, key in 0149, which will create a bullet for you.
  3. Key in your first line of text.
  4. Hold down your Alt key and click Enter to create a new line.

Just repeat the steps above for each bullet point you would like to add to your list.

Categories
Word 2007

Set Distance Between Text and Borders in Word 2007

Word allows us to create a border around our paragraphs if we choose to. If you like, you can apply borders to all four sides of your paragraphs. You can even go all out and have a different border for each side of your paragraph, although I don’t know why anyone would want to do that.  But the point is, if you want to, you can!

So after you apply your border formatting, you might decide you need a bit more room between the actual border lines and the text in your paragraph. It’s all about aesthetics and luckily you can change this very easily.

Follow the steps below to learn how:

  1. Select the paragraphs which you would like to change.  If it is just one paragraph, just make certain your cursor is within it.
  2. Click on the Home tab of your Ribbon.
  3. In the Paragraph group, click the drop-down at the right of the Borders tool to display a menu of selections, including different borders you can add.
  4. Select Borders and Shading to display the dialog box.
  5. Make certain you select the border you want to appear around your paragraph.
  6. Click the Options button to display the dialog box.
  7. Use the Top, Bottom, Left and Right controls to specify in points, the distance between the respective border and the paragraph text.
  8. Click OK twice.
Categories
Excel 2007

Quickly enter Data in your 2007 Excel Worksheet

A really cool shortcut you can use in Excel 2007 allows you to copy data from the cell above the current cell.

Follow the steps below to learn how:

  • Click Ctrl + “ (quotation mark)

Say you enter the number 456 in cell A6. If you then move to cell A7 and click CTRL + “, 456 appears in the cell.

If you then go to cell A8 and key in CAB and click CTRL + “ you will see CAB456 in your cell.

This can really come in handy when you are entering data with a lot of similarities.

Go ahead and give it a go and see how much time you can save!

Categories
Subscribers Excel 2010

Subscribers: Quickly Filter Data in Excel 2010

Excel has always been a great piece of software but 2010 Excel has more great features and one of them is the ability to use a right-click cell menu to filter a table based on the active cell's value, font color or fill color. If you color code data in your cells you can very […]

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

Subscribers: Create A New Slide Master in PowerPoint 2010

PowerPoint 2010 gives you the option of creating your own master slides. This means that you can add or change elements and formatting within your presentations. A slide master is a special slide that you put to work behind the scenes in PowerPoint that specifies how slides appear all the way through your presentation. Once […]

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: Word 2010 Formatting Errors – Resolved!

I cannot tell you how many times I have received a phone call from an irate client, cursing Word and the person who created it because they "have tried everything under the sun" to correct some formatting and it will not correct! Below are some of the ones that I get over and over: The […]

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: Change ToolTips for Macro Buttons in Word

Say you have multiple custom buttons on your Quick Access Toolbar (QAT) in Word, in a custom ribbon group. AND your buttons are assigned to macros?  Suppose you want to change the ToolTip associated with the macro button on your QAT?? Luckily, it is very easy to do this! Follow the steps below: Right-click the […]

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: Protecting your Excel 2010 Worksheet and More!

There are some occasions when you would like to prevent your colleagues from making changes to your cells or perhaps you do not want them to have the capability of seeing your formulas in the Formula bar. Fortunately, Excel will allow you to do this and more, but unfortunately, it is not always intuitive where […]

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: View Formulae in Table Cells

On some occasions, your Word table can contain formulas that are too long for the smaller cells in your table and that  prevents them from being displayed completely when you look at your field codes rather than the results of your field codes. Word does not have a feature like the ones available in Excel […]

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
Carol's Ramblings

We’re back!

Welcome back everyone!  So far I have had nothing but positive feedback about the new site and that makes me very happy.

It has been a long three months and lots and lots of hard work and burning of the midnight oil by David Hartsock putting all this together for us.  He did a fabulous job didn’t he?

The site is still under construction.  The store is not available as yet but it will be soon.  Please bear with us while we are refining everything and making it feel like home and more importantly, making it what you, the subscribers, want and need! Thank you all so much for your continued interest and your support; it really means the world to me.

I don’t know about you, but the last three months have been a whirlwind of activity for me and my family. I have two grandchildren due to make their debut next month – one on the 19th and one on the 24th and so I have been knitting like a madwoman in addition to everything else!  So far I have made two layette sets consisting of sweater, hat, booties and mitts for each baby.  I have also knitted at least eight washcloths and a teddy bear hat, a long tail hat and a whole bunch of other hats and several sets of booties.  I am currently working on an Heirloom blanket and another crib blanket.  Hopefully they will both be finished in time for the babies arrivals!

I have noticed of late that there are a lot more homeless people where I never saw any.  A sign of the times for sure.  I was purchasing lunch in a local cafe this week and one of those homeless people was behind me.  She was white haired and obviously old and clearly had some mental issues.  She was hissing and making faces at me.  So I finished my purchase and the owner of the place started to wait on this old woman.  She had placed bottles of juice, containers of yogurt and several other items on the counter.  The owner told the woman “nobody has left any money here for you.” The woman’s face fell.  I said I’ve got it and the owner asked if I was sure.  I replied “yes, she would do it for me.”  Well don’t you know that the woman who a few seconds ago had been hissing at me smiled a toothless smile me and said quite clearly “I would, I really would.  I have a kind heart.”  I smiled back and said “I know you do.”  All day I felt good knowing that the woman would have a breakfast and lunch that day.  I bet if the tables were turned she really would do that for me.

So, if you see someone down on their luck, try to help them as much as you can.  That’s what we’re all here for isn’t it?

I hope you really enjoy our new site and please be sure to tell all your friends about it as well!

Until next time…

Carol