|
|
Links to >>> |
 |
:: Our Services |
:: Good Reading |
| Dear Executive, | |||
* Excel:
Appearance Counts - use Comments
and Line Breaks in cells * |
|||
|
Anyone who took programming classes in college always heard
the refrain, 'document your program'. It's nice
to be able to assist the user in Excel too, and we can
add that 'documentation' by using the Excel Comments
feature. In addition to Comments, I frequently
need to write small text messages in a cell,
but need to separate those sentences
to make them easier to read. I'll
cover that too and you'll have text messages in cells
that are much easier to read by adding manual Line
Breaks. COMMENTs The presence of a comment is identified by a red indicator triangle in the upper right corner of a cell. I prefer to leave the comment(s) off and just see the indicator in my spreadsheets. When you move the cursor over the indicator the comment opens, and when the cursor is off the indicator the comment closes. You can select your preference on how to display the indicator and comment by going to Tools/Option/View/Comments. To add a comment in a cell, Insert/Comment, and write your message. This is also useful when sharing, or debugging an Excel spreadsheet among a group of users. Each user can add their feedback as comments. The background color, font style, size and color can all be controlled by the user. I'll leave that for you to explore, if you feel the need to change the defaults. Cell Formatting (Line Break) To insert a Line Break , click where you want to break the line and press ALT+Enter. If you are already at the end of a paragraph and want to start a new paragraph, do that twice and you will be on a new line to start a new paragraph. They don't have to be separate paragraphs, maybe you just want to separate several short sentences to make them easier to read - this is the trick! |
|||
| Reader Feedback from the last TechTIP | |||
|
Corbitt Associates
provides sales, marketing and training
services, when you don't have resources available. Your
resources may not have the required skill and experience,
or they may be committed to another project. Here are just some examples of strategic and tactical activities, we have provided for others. Send an email to editor@corbittassociates.com to request more information, or if you require something not shown in the examples below. |
|||
| Sales | Marketing | Training | |
| • Forecasting | • Corporate Presentations | • PowerPoint |   |
| • Customer Engagement Models | • Product Briefs / Marketing Materials | • Excel | |
| • Dashboard /KPI / EIS | • Creating Price Models | • Word | |
| • Pareto: 80/20 Rule for Sales | • Corporate Intelligence (SWOT) | • Outlook | |
| • Commission Plans | • Organizational Balance | • ACT! and GoldMine | |
| • Territory Coverage | • Targeted Emails /eNewsletters | • Workshops - Full and half day | |
| • Due Diligence Review | • Literature Fulfillment | ||
| • Sales Force Automation (SFA) | • Demand Printing | ||
| • INCOTERMS Explained | • List Rental / Database Hygiene | ||
| • Understand VMI PLans | • Mail Automation Compatibility | ||
| • Negotiating: Beyond Price | • Managing Image Libraries | ||
| • SPC / Quality Topics for Sales |
| If you wish to opt-out from this distribution list, click Unsubscribe and you will be automatically removed |
| If you would like to contact us, please send email to: editor@corbittassociates.com |
Corbitt Associates 3590 Lester CT SW Lilburn, GA 30047-7504 |