Often you might have these little bugs that bother you in life but since I write about Excel, I’ll try to fix your bugs in that context 😀
Let’s take a look at 5 of the most common problems
It might have had happened that while confirming a formula (by pressing enter) the result doesn’t show up, instead the formula itself is displayed in the cell
The Fix – The problem is that the cell has a text format so excel thinks your formula is a piece of text. To fix this, simply convert the cell in a Number or General format and then confirm the formula once again. I am pretty sure it’ll work
This one happens mostly by accident when your spreadsheet is showing all formulas but not their results
This is not because of cell formatting but it is because you might have switched over to the formula view by pressing Ctrl ~ (tilde).
The Fix – Just press Ctrl ~ (tilde) again and you’ll come back in the normal mode
At times the cell will be filled up hashes.
This could be because
The Fix –
Although these are harmless but they untidy my sheet
The Fix – Go to Excel Options –> Advanced –> Scroll down to Display Options for This Worksheet –> Un-check Page Breaks
This mostly happens when you receive a printable file from someone. The view might look a like Page Break (left) or Layout (right) and you are unsure how to get back to normal excel screen
The Fix – At the right bottom corner of your excel screen there are 3 buttons to toggle between 3 views (2 views from above and normal view)
I could think of just 5 problems, but I am sure there are plenty of them. If you have any more please drop in a comment and I’ll try to give you a fix