Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • CamelCase to Camel Case CHAR
  • Text-to-Columns, dynamically using formulas IFERROR
  • SimpleANBox Basic Math
  • CountIf limitation COUNTIF
  • Min Max vehicle Formulas - combined functions
  • IF with AND and IF with OR AND
  • Excel sessions – 2013 VS 2010 Excel User tips
  • New function IFERROR, finally IFERROR

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

  • Stale values (Scratched functions) Excel User tips
  • Highlight dates dynamically AND
  • Excel ad from early 90s Non-functions
  • Skills Grid Conditional Formatting
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • When Excel functions are not enough Excel User tips

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
  • Min Max vehicle Formulas - combined functions
  • BMI Calculator Basic Math
  • iframe in Excel (XLiFrame) ADDRESS
  • Recover the unrecoverable Excel User tips
  • FORMULATEXT to show formulas FORMULATEXT
  • Schedule column Basic Math
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Excel @ before function names in formulas Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme