Have you ever had an Excel workbook with multiple sheets, and you can’t see all the sheets because you either have too many sheets or the sheet names are too long?
Unfortunately, you get to the point where you can no longer see all the tabs in one view. You can use the built-in tabs navigation buttons, but there is another way as well.
Right-click the tabs navigation buttons and a floating list of all the worksheets in the workbook will appear. This is especially useful when sheet names are too long, or there are a lot of sheets.
Two keyboard shortcuts that can move you between worksheets are:
• CTRL+PageUp take you to the previous sheet in your workbook.
• CTRL+PageDown move to the next sheet.
April 27, 2010
Microsoft Word 2003 & 2007 – Paste Unformatted Text
When you copy and paste text from a Web page or another document, the text brings it’s formatting into your document. To get around that behavior, copy the text and place the insertion point marker where you want to insert the copy. Then, choose Paste Special, and select the Unformatted Text option. Now the text will be inputted into your document with none of the formatting from the original source.
April 23, 2010
Could You Be Putting Your Money at Risk Online?
Excellent article from MORE magazine, April 2010 about the dangers and non-dangers on doing business online.
April 22, 2010
Featured Entrepreneur on the American Family Business Accelerator Web Site
Check it out! We're on the front page. http://amfambusinessaccelerator.com/ The article is recognizing Your Computer Lady for last year's Step It Up! Award.
This year's Business Accelerator program kicks off in Phoenix on May 6th. I'll be there! I encourage all of my small business clients and friends to participate. It's great information. While most of the sessions are online and even recorded so you can listen on your schedule, this year they are adding some small group meetings. I'll be leading a group that will meet at the Small Business Development Center. It's an opportunity to share ideas, get feedback and meet other small business people. Watch the Business Accelerator site for more details or contact me!
This year's Business Accelerator program kicks off in Phoenix on May 6th. I'll be there! I encourage all of my small business clients and friends to participate. It's great information. While most of the sessions are online and even recorded so you can listen on your schedule, this year they are adding some small group meetings. I'll be leading a group that will meet at the Small Business Development Center. It's an opportunity to share ideas, get feedback and meet other small business people. Watch the Business Accelerator site for more details or contact me!
PowerPoint Presentations– What Font Size & Style Should I Use?
Avoid Fancy Fonts! Choose a font that is simple and easy to read such as Arial, Times New Roman or Verdana. Avoid script type fonts as they are hard to read on screen. Use, at most, two different fonts – perhaps one for headings and another for content. Keep all fonts large enough (at least 24 pt and preferably 30 pt) so that people at the back of the room will be able to easily read what is on the screen. If the room you are presenting in is very large you might need to increase the font size.
Remember to consider where you presentation will take place. Light color fonts on a dark background are often easier to read in a very dark room. Dark color fonts on light backgrounds, on the other hand, work better in rooms with some light.
When creating your slides, choose font colors, styles and a font size that will make it easy for your audience to read what is on the screen, no matter where they are seated.
Remember to consider where you presentation will take place. Light color fonts on a dark background are often easier to read in a very dark room. Dark color fonts on light backgrounds, on the other hand, work better in rooms with some light.
When creating your slides, choose font colors, styles and a font size that will make it easy for your audience to read what is on the screen, no matter where they are seated.
April 20, 2010
Microsoft Excel 2003 & 2007 – All CAPS to Proper Format
Have you ever received an Excel file and all the text is in CAPS? You can change the text so that it is in “Proper Format” with this simple tip.
For example: How would you change YOUR COMPUTER LADY to read Your Computer Lady?
If you have YOUR COMPUTER LADY in cell A1, then in any cell within the worksheet type =PROPER (A1). It will automatically change YOUR COMPUTER LADY to Your Computer Lady in the cell that you typed the “Proper” formula.
Try it! It works great.
For example: How would you change YOUR COMPUTER LADY to read Your Computer Lady?
If you have YOUR COMPUTER LADY in cell A1, then in any cell within the worksheet type =PROPER (A1). It will automatically change YOUR COMPUTER LADY to Your Computer Lady in the cell that you typed the “Proper” formula.
Try it! It works great.
April 14, 2010
Microsoft Word 2003 & 2007 - Quickly Generate Text
If you are trying out a new Word template and need to quickly stick a few paragraphs of test text in it, Word will generate text for you with this simple formula.
Type =rand(8,10) and press enter and Microsoft Word will automatically generate text that can be used to test page formatting, fonts, etc.
The numbers can be changed to fit what you need. In our example, the 8 represents 8 paragraphs. The 10 represents 10 sentences within a paragraph. You can adjust the numbers any way you want to get the results that you need.
Type =rand(8,10) and press enter and Microsoft Word will automatically generate text that can be used to test page formatting, fonts, etc.
The numbers can be changed to fit what you need. In our example, the 8 represents 8 paragraphs. The 10 represents 10 sentences within a paragraph. You can adjust the numbers any way you want to get the results that you need.
Subscribe to:
Posts (Atom)
