Common Excel Confusions

Some common Excel confusions can be easily remedied.

Common Confusions in Excel

When working on financial models within Excel, it is quite common to come across some of the following confusions. It may seem like Excel is bugging, but in reality, there are some easy fixes to common excel confusions.

Commands in toolbar menu are “greyed out”

When this occurs, chances are several tabs or sheets have been unknowingly grouped. To verify this, the user can look at the top of the Excel toolbar and see if the text [GROUP] is beside the sheet name. If so, simply deselect the group by selecting another sheet that is not part of the group. This should clear up the grouping and allow access to the toolbar.

Spreadsheet suddenly displays formulas

When this occurs, the sheet will also become wonky, and cells and rows may enlarge to accommodate the appearance of the formulas. Often, this means that formula mode has been activate. To return to normal mode, press Ctrl + `.

Numbers appear when certain letters are pressed

If numbers appear when the letters J, K, L, U, I, O or M are being pressed, the user may have inadvertently activated numlock. To deactivate, press Shift + NumLock, which is located in the upper right hand corner of most keyboards.

Check out our free Excel crash course to avoid these easy mistakes.

Cursor stays fixed while the page scrolls when using the arrow keys

If the arrow keys do not move cells within Excel, and instead move the entire view as if scrolling, scroll lock has most likely been activated. To deactivate, simply press the scroll lock key, which is located near the num lock key in the upper right hand corner of most keyboards.

Pressing the arrow keys selects cells even though shift is not held down

If this occurs, there may be one of two things happening. The first is that sticky keys has been activated, thereby acknowledging a shift press where there is none. The second involves the shift key inadvertently sending a press code, even though it is not being pressed. This may happen from time to time with cheaper keyboards or faulty hardware. To fix either issue, simply press the shift key once to register a press followed by a release.

The confusion panacea

The escape friend is one of the Excel user’s bestfriends. When in doubt, press the escape key several times to exit out of any options or modes that may have been entered into.

Learn more about Excel best practices to ensure a smooth modelling experience.

More formatting:

There are other areas of formatting that a financial analyst can use to improve a model. Peruse the articles below to learn more about other aspects of financial modelling within Excel.