Enter Mode
now browsing by tag
AcroForms
add controls to form
Arbitration
Autoexpand
BookMarks
defined tables
Dynamic Hyperlinks
enable macros
Excel
Excel 1013
excel 2007
excel 2010
excel 2013
Excel Defined Names
Excel Linear Interpolation
Excel ScoreBoard
excel to pdf
excel userform
excel vba form
expand userform
Export XML Data From Excel
fill combo
Header Row
hide excel sheets
Mail Merge
Map Excel to Word
Mass Metters
PDF Form
pdf to excel
Ping Pong
protect sheet
range to array
Table Components
tables
Table Tennis
TextBox
TextBox Change Event
TextBox Exit Event
Totals Row
UDF
VBA Interpolate
vba user form
workbook protection
XFA Forms
XML Data
Excel Cell Modes
How can the Cell Modes affect your work?
When you try to edit a Conditional Formatting formula, and you click the left or right arrows to move across formula’s text, Excel inserts unwanted cell references. Same thing happens when you try to create or edit a Defined Name formula, or a Chart series…
If you are not aware of the active Cell Mode, then working with formulas, defined names formulas or conditional formatting formulas, editing chart series can become very annoying.