Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Return 12 values in one number AND
  • Get 3rd Wednesday of month Basic Math
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Standard math to calculate Aspect Ratio Basic Math
  • IF with AND and IF with OR AND
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Searching table in 2 dimensions. 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

  • Sheet() and Sheets() Lookup and References
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Formula Beautifier Excel User tips
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Pixel Excel Drawing Format Cells
  • Skills Grid Conditional Formatting

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
  • Rotate table using 1 formula ADDRESS
  • Sorting with functions only CHOOSE
  • Fixed length ID Formulas - combined functions
  • CTRL+Y a mini macro Excel User tips
  • Filter. Google Sheets function Google Sheets
  • OFFSET+MATCH Formulas - combined functions
  • Multiple-Validations (connected to each other) Data Validation
  • DayName Date and Time

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme