Tag: cell

Cell formats 0.0\% and 0.0%;(0.0%)

April 7, 2019 ANmar

We needed a way to force Excel to show the % next to a number without dividing it by 100 You know, when you format a cell in Excel, to show %, it automatically divide that number by 100 But we do not want that to happen this time. So here is the trick, in…

Format Cells, Non-functions, Worksheet

Edit directly in cell

December 5, 2018 ANmar

One of the settings that I always change when I first get a new Excel installation is …

Remove “Edit directly in cell”

Here is where you find that option

Read More “Edit directly in cell” »

Excel User tips, Non-functions

Convert cell into textbox

March 28, 2018 ANmar

Often times, I found myself the need to design a sheet where I want users to input something, and I need them to focus on that particular single input (or more)

So, i learned a trick, it is formatting the entire sheet to certain color and give that cell special format to make it look like a textbox.

Read More “Convert cell into textbox” »

Excel User tips, Graphics, Non-functions, Worksheet