Excel Tips For MS Office 2010 - 2
PrintListen to this Article
1. If you type an exceptionally long text entry into a cell, the Formula bar may not show all the text. To display more of the text in the Formula bar, click the bottom of the Formula bar and drag down to increase the height. Also useful is the Ctrl+Shift+U keyboard shortcut. Pressing this key combination toggles the height of the formula bar to show either one row, or the previous size.
2. Automatically moving the cell pointer after entering data
By default, Excel automatically moves the cell pointer to the next cell down when you press the Enter key after entering data into a cell. To change this setting, choose File ➪ Options and click the Advanced tab. The check box that controls this behavior is labeled After Pressing Enter, Move Selection. If you enable this option, you can choose the direction in which the cell pointer moves (down, left, up, or right). Your choice is completely a matter of personal preference. I prefer to keep this option turned off. When entering data, I use the navigation keys rather than the Enter key.
3. Selecting a range of input cells before entering data
Here’s a tip that most Excel users don’t know about: When a range of cells is selected, Excel automatically moves the cell pointer to the next cell in the range when you press Enter. If the selection consists of multiple rows, Excel moves down the column; when it reaches the end of the selection in the column, it moves to the first selected cell in the next column. To skip a cell, just press Enter without entering anything. To go backward, press Shift+Enter. If you prefer to enter the data by rows rather than by columns, press Tab rather than Enter. Excel continues to cycle through the selected range until you select a cell outside of the range.
4. Using AutoCorrect for shorthand data entry
You can use the AutoCorrect feature to create shortcuts for commonly used words or phrases. For example, if you work for a company named Consolidated Data Processing Corporation, you can create an AutoCorrect entry for an abbreviation, such as cdp. Then, whenever you type cdp, Excel automatically changes it to Consolidated Data Processing Corporation. Excel includes quite a few built-in AutoCorrect terms (mostly common is spellings), and you can add your own. To set up your custom AutoCorrect entries, access the Excel Options dialog box (choose File ➪ Options) and click the Proofing tab. Then click the AutoCorrect Options button to display the AutoCorrect dialog box. In the dialog box, click the AutoCorrect tab, check the option labeled Replace Text as You Type, and then enter your custom entries. You can set up as many custom entries as you like. Just be careful not to use an abbreviation that might appear normally in your text.
Jainam Shah (ACA, D.I.S.A.(ICAI), B.com, Inter CS)
E-mail: ca.jainam@gmail.com
Category : General | Comments : 0 | Hits : 369
As a registered valuer entrepreneurs often ask’s us, what is the value of my Business ? There is no right answer to this question as valuation is a very subjective thing. I will value a flat near my office higher as compared to someone whose office is far from that flat or a person will value an apple more when he is hungry compared to a time when he is not hungry. So the question what is the value of my business remains unanswered. It will always be difficult to ascertain the value of...
APEDA (Agricultural and Processed Food Products Export Development Authority) registration in India is an essential requirement for businesses engaged in the export of agricultural and processed food products. APEDA plays a crucial role in promoting the export of these products and ensuring their quality and compliance with international standards. This article will walk you through the step-by-step process of APEDA registration and the documents required for the same Step 1. Unde...
FSSAI (Food Safety and Standards Authority of India) registration is mandatory for any business involved in the food industry in India. The registration process involves several steps and requires specific documents to be submitted. Here is a detailed analysis of how to do FSSAI registration in India step-wise, along with the necessary documents: Step 1: Determine the Type of Registration FSSAI offers different types of registrations based on the scale and nature of the food business. ...
A lacuna in your employment history within your curriculum vitae can have potential drawbacks on your job hunt and career opportunities. Addressing a career gap in your CV can be challenging, but there are several unique ways you can handle it. Here are some approaches you can consider: Address the gap directly: Be honest and upfront in explaining the reason for your career gap. Don't try to hide it or sugarcoat it – address it head-on. Be positive and confident: W Regardless of the re...
Introduction India is widely recognized as one of the prominent players in the global economy. Despite being a developing nation, India's economy has a significant impact on world trade. The majority of the most developed countries worldwide are eager to establish or strengthen their ties with India. Investors prefer India as a desirable location over other major countries due to its vast market base and the evolving purchasing habits of its middle-class citizens. As mentioned earlier, I...
Comments