Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Skills Grid Conditional Formatting
  • Sorting with functions only CHOOSE
  • Count Unique COUNTIF
  • Searching table in 2 dimensions. Formulas - combined functions
  • Fixed length ID Formulas - combined functions
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • MID + SEARCH to convert cell to rows MID
  • Change Calculator – calculate change in multiple bills/coins 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

  • Paste Special Percentage Excel User tips
  • Excel @ before function names in formulas Excel User tips
  • Shapes with dynamic output Excel User tips
  • Excel Limits Excel User tips
  • The Excel “&” bug Excel User tips
  • 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
  • MATCH fumction, just a simple search Lookup and References
  • When Excel functions are not enough Excel User tips
  • Recover the unrecoverable Excel User tips
  • State Abbr with Index+Match+Validation Data Validation
  • Week number to Sunday date – Weeknum reverse DATE
  • Always get 1st name (or last) Formulas - combined functions
  • FORMULATEXT to show formulas FORMULATEXT
  • BMI Calculator Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme