Excel Tips and Tricks

Some Excel Tips and Tricks:

• Group cells together by giving them a name - easier to apply actions on all of them
• Link Cells together (changing data in one cell affects the other) by: Copy, use Paste + Options
• Split Worksheet by dragging the split box (top of the vertical scroll bar or right end of the horizontal scroll bar) to desired position
• Use $ for retaining a row / column / cell name in a formula. Eg: $A1 (retain column A) or A$1 (retain row 1) or $A$1 (retain cell A1)
• Use Freeze Panes option (under Windows in Menu Bar) when needed
• Use Auto Formatting and Conditional Formatting (under Format in Menu Bar)
• In Charts, right click on plotted points and select "Add Trend line" to see the slope
• Use Array aka CSE (Ctr+Shft+Enter) Formulae: Eg:Sum(A2:A8 * C2:C8) = A2*C2 + A3*C3 + ... + A8:C8

Shortcuts:

Ctr + ~	Formula Auditing
Alt + Enter	Insert newline
Ctr + ;	Current Date
Ctr + Space	Select Column
Shft + Space	Select Row
Ctr + Shft+ ;	Current Time
F7	Spellcheck selected text
Shft + F3	Excel Formula Window

---

Graph in MS Excel - Y axis title cut off

Problem: While plotting graphs in Excel, Y axis title is always cut off in the middle. Eg: "Expansion" becomes "Expansi"

Solution: This is a bug in Excel and is likely to be fixed in future. There are two ways to overcome this problem.

1. Add the title to a textbox and format the textbox as needed. (Selecting the chart and typing inside will automatically add a textbox to the chart)

2. In the Value for Y axis (Chart options) add the title and append few spaces followed by a period (or any other character). The spaces and the period (or the last character) will be clipped.

---