{"id":1297,"date":"2018-03-28T02:41:27","date_gmt":"2018-03-27T20:41:27","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1297"},"modified":"2018-03-28T02:41:27","modified_gmt":"2018-03-27T20:41:27","slug":"convert-cell-into-textbox","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1297","title":{"rendered":"Convert cell into textbox"},"content":{"rendered":"

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)<\/p>\n

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.<\/p>\n

<\/p>\n

So, 1st, you select entire sheet using this box<\/p>\n

\"\"<\/a><\/p>\n

Then, color it, any color, this will be your background, I often use generic windows gray<\/p>\n

\"\"<\/a><\/p>\n

Then, going to a certain cell, and format it as below<\/p>\n

\"\"<\/a> \"\"<\/a><\/p>\n

Notice here the arrows are referring to borders in black (top and left), and borders in white (Bottom and right).<\/p>\n

 <\/p>\n

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<\/p>\n

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

Will end up with something like this sheet<\/p>\n

 <\/p>\n

\"\"<\/a> \"\"<\/a> \"\"<\/a> \"\"<\/a><\/p>\n

 <\/p>\n

\n
<\/i> Download spreadsheet<\/a><\/div>\n
<\/i> Excel Online version<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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…<\/p>\n

Read More “Convert cell into textbox”<\/span> »<\/a><\/p>\n","protected":false},"author":1,"featured_media":1304,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,28,5,12],"tags":[103,196],"class_list":["post-1297","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-user-tips","category-graphics","category-non-functions","category-worksheet","tag-cell","tag-textbox"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1297"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1297\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1304"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}