Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • When Excel functions are not enough Excel User tips
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Progress bar in pure functions CHAR
  • Get 3rd Wednesday of month Basic Math
  • Shapes with dynamic output Excel User tips
  • Middle name + 1st name Basic Math
  • The Excel “&” bug Excel User tips
  • Fx to cut long column into two columns Formulas - combined functions

Convert cell into textbox

Posted on March 28, 2018 By 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.

So, 1st, you select entire sheet using this box

Then, color it, any color, this will be your background, I often use generic windows gray

Then, going to a certain cell, and format it as below

Notice here the arrows are referring to borders in black (top and left), and borders in white (Bottom and right).

 

Then, with some additional font size, and cell resizing, you got yourself a text box, tat users will got the impression, they are actually looking into an area for them to enter something without getting distracting with all other cells and areas

As an additional feature, I also sometimes hide other rows and columns to make sheet unscrollable (if that is a word)

Will end up with something like this sheet

 

 

Download spreadsheet
Excel Online version
Excel User tips, Graphics, Non-functions, Worksheet Tags:cell, textbox

Post navigation

Previous Post: FORMULATEXT to show formulas
Next Post: Text-to-Columns, dynamically using formulas

Related Posts

  • Spreadsheet Compare application Excel User tips
  • Formula Beautifier Excel User tips
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Highlight dates dynamically AND
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Lesson learned: Do not trust Google Sheets function Google Sheets

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • CHOOSE – tree of decisions CHOOSE
  • Pixel Excel Drawing Format Cells
  • Cells with additional spaces AND
  • Hello world! Uncategorized
  • Show developer tab Excel User tips
  • Blank (isempty) VS “” (null string) Excel User tips
  • Formula Beautifier Excel User tips
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme