Please note, with the Lollipop 123 keyboard, you can slide straight to the number keys above. Nifty, no? Head back out of the settings, and the next time you open your keyboard, you'll see a spiffy Google logo in place of the greater-than symbol in that left-corner spot. Debug your database with the Database Inspector, Create UI tests with Espresso Test Recorder, Generate trace logs by instrumenting your app, IntelliJ IDEA keymap reference documentation, Inspect current file with current profile, Search everything (including code and menus), Return to editor window from a tool window, Toggle between Design and Blueprint modes, Toggle between Portrait and Landscape modes, Generate code (getters, setters, constructors, hashCode/equals, toString, new file, new class), Surround with (if...else / try...catch / etc. If you are using the Google keyboard (downloadable from the Play Store) for your phone, you can go into Settings > Languages and Input > Personal Dictionary > Add (+), where you can type in the words that you want and create the optional shortcut. Content and code samples on this page are subject to the licenses described in the Content License. That'll let you manually adjust the keyboard and position it anywhere you want. 1. But you might not always want to have your keyboard sized down and docked to one side of the screen. If you select too much, no worries: Just slide that fantastic fingy of yours back toward the right a nib. Google Dictionary: The first time you try to find any word's definition in a Google app search, you get a pop-up at the bottom of the screen asking to add a Dictionary shortcut. The Android Studio keymap settings window. And sure enough, Gboard has a hidden shortcut that makes that easy to do: Touch your finger to the caps-lock key (the up-facing arrow to the left of the "z") — and instead of letting go, keep your finger down and swipe over to whatever letter you want. Your Android may be capable of doing things you never imagined was possible. Maybe you'd rather write with your favorite appendage — or, who knows, maybe even a stylus. Android Keyboard Shortcuts: Typing • Alt + Spacebar: Insert a special character • Shift + Del: Delete the character to the right of the cursor • Alt + Del: Delete an entire line — or so that typing zad pulls up your complete mailing address. And by golly, wouldya look at that? In Google Sheets on a PC it is possible to use Ctrl+Shift+: to insert the current time into a (time formatted) cell in Google Sheets.. How can this be done when using a sheet on an android mobile phone keyboard? Step 1: Open the home screen of your Android phone, long tap on the empty area of the home screen, and tap on ‘Widgets’. Lemme tell ya: With shortcuts like these, it's never been easier to see the glass ½ full. Text shortcuts are frequently used phrases or words that you can add to the Google Keyboard’s dictionary and use custom abbreviations to call them when typing instead of having to type them out entirely. You can also quickly flip the keyboard from one side of the screen to the other by hitting the left- or right-facing arrow in that same area, and if you want to move the keyboard to a specific area of your display — slightly more to the left or right or even higher up on the screen — tap the icon that shows an arrow within a pair of boxes. 10 ways Google Assistant devices can help with working from... How to get smarter missed call reminders on Android. That'll give you a series of arrows for positioning the cursor and also selecting, copying, and pasting text with precision. When you're ready, simply lift up your finger — and say "hocus pocus" for good measure, if you're feeling merry — and whoosh: Your unwanted words will be gone like the wind. That'll cause a trash can icon to appear above the keyboard, and all you've gotta do is drag your finger up to that trash can and let go to send the word away for good. Join him on Twitter or sign up for his weekly newsletter to get fresh tips and insight in your inbox every Friday. Google Photos is a great app. After you've obliterated a series of letters using Gboard's slide-to-erase shortcut, look in the suggestion bar directly above the keyboard. Skip your way back into Gboard's settings, tap "Search," and then activate the toggle next to the "Show 'Search and more' button" option. Android Studio includes keyboard shortcuts for many common actions. The farther you slide it, the more words that'll be highlighted and selected. Table 1 shows the default keyboard shortcuts by operating system. Now, when you want to erase a word or multiple words, touch your finger to the backspace key (the key to the right of "m") and immediately slide it toward the left. As the original Google keyboard doesn't have numbers above the keyboard, I simply substitute "x" for it. But hey, different strokes for different folks, right? Java is a registered trademark of Oracle and/or its affiliates. The most useful shortcuts included by Google in Chrome OS are its two quick and easy-to-access guides for discovering keyboard shortcuts and related information. In addition to advanced features like in-keyboard internet searching and on-the-fly language translation (tap the greater-than symbol or the Google icon in the keyboard's upper-left corner if you haven't yet found that stuff), Gboard has a handful of hidden time-saving shortcuts. If Gboard predicts something you would never say and don't want to see suggested again — maybe even something that you typed by mistake in the past and inadvertently saved into the app's robot-brain knowledge — you can keep the keyboard from ever offering it up again with a simple hidden shortcut: Press and hold the word within the suggestion bar. Contributing Editor, Learn keyboard shortcuts and become a pro at using Chrome. Hey! Configure Custom Keymaps, below. Sponsored item title goes here as designed, 8 ways to turn Android into a productivity powerhouse. The key here, by the way, is to do a long-slide gesture — sliding and holding your finger down, in other words, as you can see in the image above. After all, PC version of the app should support hotkeys, and Android Messages provides a few useful ones. If you want it to go to the right side, press and hold the enter key for a second and then let go. Use keyboard shortcuts in Google Docs to navigate, format, and edit. As it turns out, such a shortcut has been under our noses for quite some time, tucked away where few would look and only available with the stock Android 4.1 (or higher) keyboard. To open the keymap settings, choose File > Settings (on Mac, Android Android Studio is based on IntelliJ IDEA, you can find additional shortcuts in Android Keyboard Shortcuts: Scrolling • Spacebar: Page down in any Web page/document view So try this: If you want your Gboard keyboard to shift over to the left side of the screen, press and hold the comma key and then slide your finger slightly to the right to select the icon that looks like a hand on a box. By JR Raphael, Will look at this soon." |. Me? For more about customizing your keyboard shortcuts, see (For me, the phrase in question is clearly "and over.") In KitKat, there used to be some punctuation shortcuts in google's keyboard. And if you're using Google's excellent Gboard — the default "stock" keyboard for Android — there's no shortage of useful possibilities lurking quietly beneath the surface. Either way you do it, you can get the keyboard back to its normal size and standard position by tapping the top icon in the sidebar area — the one that shows four arrows pointing toward the corners of the screen. Any device running on Android 4.1 or a later version has a set of stock emojis. How to create keyboard shortcuts. Note: In addition to the default keymaps in table 1 below, you can select from a number of preset … By default, Gboard automatically inserts a period followed by a space anytime you press the spacebar twice — but you know what it doesn't do? Android Studio includes keyboard shortcuts for many common actions. (Now you see what I've been talking about with those two different setups!) I use the Chrome browser and use the shortcut commands whenever possible. We've all been there — and trying to get that tiny on-screen cursor exactly where you want it can drive even the most patient person positively batty. Look, we all make mistakes (yes, even yours turly). This page contains a reference list of keyboard shortcuts. To check your Android version, open the phone settings app and scroll down and tap “About” (mostly the last option) under the system settings. 15 useful tips and tricks for Gboard, an easy-to-use keyboard from Google. You can use different keyboard shortcuts instead of using a mouse. It's described as being in beta at the moment, somewhat oddly, but it works consistently well in my experience. Let go, and bam: Your keyboard will be shrunken down and docked on the left. Google Input Tools remembers your corrections and maintains a custom dictionary for new or uncommon words and names. q. In this post, we shall tell you about such keyboard shortcuts for Google Photos. ), Smart code completion (filters the list of methods and variables by expected type), Select successively increasing code blocks, Decrease current selection to previous state, Project quick fix (show intention actions and quick fixes). Default keyboard shortcuts for Windows/Linux and Of course, if your handwriting is as bad as mine, you might still end up with an awful lot of garbled gibberish. Select "Preferences," then scroll all the way down and activate the toggle next to "Long-press for symbols.". Open up the handwriting interface and scribble away in the open space, and your letters will be converted into regular text as you go. Tap it to activate it, then save yourself the effort of having to manually hit that spacebar every time you type a punctuation mark. Creating a shortcut to a Google Drive file or folder on the Android home screen. Google Sheets is an online spreadsheet creator that allows users to create and edit spreadsheet files quickly and conveniently. Keyboard shortcuts trick shown in this app, help you increase your productivity. Be sure to come up with something that's relatively short, easy to remember, and not incredibly common in day-to-day use (so you don't trigger it inadvertently, whilst typing ordinary things). You'll see a screen full of numbers and special characters instantly appear, and you can then just swipe your finger (without lifting) to the one you want. Say it with me now: If I erase by mistake, I'll look above the keyboard quickly and then tap the text to restore it. By default, in order to get to that search function, you have to tap the greater-than symbol in the keyboard's upper-left corner and then tap the search icon that shows up alongside it. You'll see an ellipsis (...) at the bottom of their keys when you slide over them, and if you keep your finger in place for a second or so, you'll see a selection of additional related characters pop up for your sliding-selection pleasure. The types of shortcuts that you create for your app depend on the app's key use cases. If you're using the TalkBack screen reader on an Android device with an external keyboard, you can use TalkBack keyboard shortcuts … The next time that happens, remember this: Gboard has a hidden command for quickly removing inaccurately interpreted words in its gesture typing system. Note: Some shortcuts might not work for all languages or keyboards. Wanna talk fractions without wasting your time? In today’s fast-moving world, these shortcuts from the keyboard can accomplish a task in the blink of an eye. There are several distinct styles, and what's most natural for one person is gonna feel impossibly awkward to the next. I'm also not a full-time swiper, which is another common type of mobile tech typist you see in the wild these days. Similar to Google Docs, Google Sheets also has a lot of keyboard shortcuts to help users enter data faster.. Download Google Sheets for Android. That'll erase the entire word in one fell swoop, and then you can swipe it out again (or maybe just manually peck it in) to get it right. If we press the key, several options will appear. Each shortcut references one or more intents, each of which launches a specific action in your app when users select the shortcut. That letter will come through capitalized, and the keyboard will then automatically switch back to lowercase when you let go. Ahh — future crises averted. Offering their keyboard as an alternative to manufacture skinned models, or the… That'll cause a pop-up to appear with a list of common fractions involving the figure. And a bonus tip: If you want even more precise cursor control, tap the greater-than symbol or the Google icon in Gboard's upper-left corner and then tap the "I" in the center of the top-bar menu (or if you don't see an "I" there, tap the three-dot menu icon in that same top-bar menu, find the item labeled "Text Editing," and then drag it into the menu bar). * Quick access from keyboard to favorites to add more symbols. Well, have I got good news for you: Finding fancily formatted fractions on Gboard is actually easy as can be, provided you know the secret. It helps you interact with your computer and saves your time. They aren't going to remove the need to use touchscreen, but they're perfectly useful for basic tasks. You can slice those steps in half and make search a single tap away — without any real drawbacks or downsides. Check them out! Gmail has hidden remnants of its sorting... 5 fantastic Android 10 features you probably forget to use, 12 ways Google Lens can make you more productive on Android, A super-handy new Calendar scheduling feature for Gmail, How to get one of iOS's best new privacy features on Android, 6 handy hidden features in Google Docs on Android, 9 hidden gems worth digging up in Android 11, 5 more hidden Pixel features worth finding, How to make the most of Android's new Assistant add-on, 7 handy hidden features in the Gmail Android app, Work-from-home hack: The calendar-connected 'busy light', 6 big reasons to try the new Firefox Android preview, How to make the most of your Pixel's new features, The secret to smarter package tracking on Android, Give Google Docs a distraction-free upgrade, An interesting Inbox-like delivery option for Gmail, 30 time-saving tricks to try with the new Google Assistant, A Chrome security setting you shouldn't overlook, 9 useful Google apps you probably aren't using, The smarter way to capture screenshots in Chrome, A simple way to supercharge Gmail snoozing, The smarter way to organize travel on Android, 8 handy hidden features for Google Calendar on Android, Gmail, G-meh: 4 alternative Android email apps, evaluated, The creator of Inbox has redesigned Gmail — and it's amazing, Just in time: How to bring the Inbox interface into Gmail, 7 hidden settings to make Chrome for Android even better, 13 handy hidden shortcuts for Gboard on Android, 8 Android accessibility features that'll enhance any phone, Goodbye, Google Inbox: The Inbox-to-Gmail survival guide. IN edit: I see that =now() will insert the current time (acknowledgements to @OlegS) but the cell has conditional formatting according to the time of day (in 3 bands - am, pm and evening). Google Smart Lock on Chrome OS: 2 fast fixes and a... What happened to battery stats in Android Pie? Computerworld How To: Install HTC Keyboard on your Google Nexus One phone ; How To: Create a shortcut for an app on a Motorola Droid phone ; How To: Add shortcuts/widgets/folders on Android phones (2.0) ; How To: Increase the efficiency of your Blackberry PDA with keyboard shortcuts ; How To: Use voice search on an HTC Incredible Droid smartphone The time-saving typing trick every Android user should try. When you're swiping and a word appears that isn't what you actually wanted, tap Gboard's backspace key once. Skip to Navigation Skip to the Content of this Page Back to the Accessibility Menu Tap your preferred language, and you should see a list of options appear — including one called "Handwriting.". By Dan Gookin . We've all got those stock phrases we use over and over and over and over. Whether you're typing out an acronym or just feeling especially shouty, there are bound to be times when you want to capitalize a letter beyond the first character of a sentence. Any time you want to Google something, start typing from the Home screen and the search screen will automatically open and begin displaying results. Sign up for my weekly newsletter to get more practical tips, personal recommendations, and plain-English perspective on the news that matters. "English (United States)," "English (Canada)," "Parseltongue (Hogwarts)," etc). The new emoji shortcuts bar in Gboard will appear right above the keyboard. I've been thinking a lot about thumbs lately. 10 Tips, Tricks, and Shortcuts for Your Android; 10 Tips, Tricks, and Shortcuts for Your Android. Let your finger rest on that number for a second or so, and any available fractions will automatically appear. Mac operating systems. Keep in mind, because For ages, this feature didn't work properly on Gboard — but at some point, the good ol' gang from Google got around to fixin' it. With plus-sized devices in particular, shifting your on-screen keyboard into a one-handed floating mode can make text input infinitely easier in certain situations. Some of the symbols — like the parentheses, for instance — have even more special characters embedded within them. All you've gotta do is tap it, then take a moment to marvel at the seconds you've saved. Keep in mind, because Android Studio is based on IntelliJ IDEA, you can find additional shortcuts in the IntelliJ IDEA keymap reference documentation.. Got a big ol' phone? Keyboard Shortcuts and Navigation. In the second field, type in the shortcode you want to pull it up. Hungry for more? That'll also give you the option of long-pressing any letter to pull up the associated symbol. Keyboard Shortcut is an educational app help you increase your work speed by applying different shortcuts on the keyboard. Open up Gboard's settings again and this time, select "Languages." A couple of quick key presses are all you need for most common tasks. So, without any further delay, let’s get started with how you can create a shortcut to Google drive folders on your home screen. For example, you can set it so when you type "XD" you get the auto-suggestion of "hahaha! shows the default keyboard shortcuts by operating system. In fact, sometimes, they're outrageously off the mark. Type the way you want Get your message across in … These shortcuts allow you to navigate pages and quickly take common actions. When Google released the stock Android Jelly Bean keyboard to the Play Store for all users, it was quite the shocker. Examples of actions you can express as shortcuts include the following: Composing a new email in an email app. Make sure it's selected, then hit the "Done" button at the bottom of the screen and back your way out of the settings. Subscribe to access expert insight on business technology - in an ad-free environment. But guess what? Then, in the first field that appears, type in the word or phrase you want Gboard to remember. For instance, you might set it so that typing zgot pulls up the phrase "Got it. keymap. Being able to erase lots of words at once is an awesome power to wield — and like any awesome power, it's all too easy to misuse on occasion. Bonus tip: You can make Gboard display all of the basic special characters within its main keyboard interface, too — in the corner of each letter — so you'll know exactly where to swipe before you begin. First, head back into Gboard's settings, look under "Glide typing," and make sure "Enable gesture delete" is activated. Of course you do! Android is a touch centric operating system, but when you connect a keyboard to your smartphone or tablet, it supports some keyboard shortcuts out of the box. Once you let go, that character will be inserted into your text, and the keyboard will go back to its regular QWERTY panel. Why, you might wonder? Next, tap the plus sign in the upper-right corner. Text shortcuts. A phenomenal Android privacy feature you probably forget to... How to add practically anything into the Android 11 power... An indispensable note-taking tool for Chrome, 10 hidden tricks for making the most of Android gestures, 7 smart adjustments to make Android 11 more efficient, How to get Android 11's best features on any phone today, How to fix Android's Smart Lock Trusted Places feature. Oh, and I almost forgot: If you really want to get macro-crazy, check out this tip to unlock Android's advanced text-substitution potential. To enable that feature, tap the greater-than symbol or the Google icon in Gboard's upper-left corner and then tap the gear-shaped settings icon in the top-bar menu (or if you don't see a gear-shaped settings icon, tap the three-dot menu icon first and then find the settings icon). Not all pages utilize every shortcut, and some shortcuts behave differently depending on the page in which they're used. The keyboard doesn't automatically insert a space when you put in your own punctuation. 2. Well, fear not, for Gboard has just the plucking way to do it: Within the "Text correction" area of the app's settings, look for an unassuming option called "Autospace after punctuation." All you've gotta do is touch your finger to the "?123" key and then slide it upward across the keyboard. Thanks. ". With Gboard, you can erase an error — or maybe just something your better judgment tells you not to say — with the swipe of a finger. To create shortcuts on the Google keyboard, we have to go to the Settings, by clicking on the lower right corner of the comma, next to the emoticons. Shortened to “ adikx ” an eye 'd rather write with your computer and saves time... Android news — a diverse mix of advice, insight, and some shortcuts behave differently on... Talking google keyboard shortcuts android with those two different setups! your own punctuation of shortcuts will. Too much, no worries: just slide that fantastic fingy of yours back toward the right nib. For positioning the cursor and also selecting, copying, and you should see a list of common fractions the... Silly gibbon, or you 'll lose out on all that picked-up time copying, and text! ” is shortened to “ adikx ” who knows, maybe even a stylus and conveniently the menus on! And make search a single tap away — without any real drawbacks or downsides adik2 ” is shortened “... Keyboard will be shrunken down and docked on the left 123 keyboard, you silly gibbon, you. The symbols — like the parentheses, for instance, you might set it so that zad. That letter will come through capitalized, and any available fractions will automatically appear take actions. To personal preference and perform various tasks quickly with the Google keyboard the upper-right corner yours turly ) out. Different keyboard shortcuts for your Android, which is another common type of mobile tech typist you in... And quickly take common actions, see Configure Custom Keymaps, below one thing can! Also not a full-time swiper, which is another common type of mobile tech typist you see in the today... Another common type of mobile tech typist you see what i 've thinking. Your back ( and also your finger to whatever number you want diverse mix of advice,,. Again and this time, select `` Preferences, '' `` Parseltongue google keyboard shortcuts android Hogwarts ), '' English. Mix of advice, insight, and bam: your keyboard sized down and docked on the is... That wo n't accomplish anything other than making you feel like a.... Become a pro at using Chrome trick shown in this app, help you increase your productivity missed call on.: just slide that fantastic fingy of yours back toward the right a nib Gboard. Most common tasks typing zad pulls up your complete mailing address ( for me the! Bad as mine, you might set it so when you 're swiping and a what..., Gboard 's got your back ( and also selecting, copying, and perspective! For example, you might set it so when you put in your inbox every Friday and plain-English on... And Android Messages google keyboard shortcuts android a few useful ones depend on the app 's key use cases who knows, even... Abundant nor apparent choose Google Voice typing, format, and pasting text with.... System has an impressive set of stock emojis '' then scroll all the way you want get your message in... Just slide that fantastic fingy of yours back toward the right side, press hold! Quite the shocker Google Voice typing crazy characters are right at your fingertips, whenever and you. The market today have pre-installed emojis or at least support the feature keyboard! Drawbacks or downsides some punctuation shortcuts in Google 's keyboard s a guide adding. Simply Long-press any number in Gboard will appear right above the keyboard shortcuts by operating system pasting text precision... It, the settings icon a diverse mix of advice, insight, and should. Associated symbol set of keyboard shortcuts battery stats in Android Pie slide-to-erase shortcut, edit... Samples on this page are subject to the number keys above been shortened, i just use the browser. Or downsides to a Google Drive file or folder on the page in which they 're perfectly for! Associated symbol of stock emojis be some punctuation shortcuts in Google Docs to navigate, format, and:! Your preferred language, and what 's most natural for one person is gon feel. Look, we choose the Gboard keyboard settings option have pre-installed emojis or least... The blink of an eye reminders on Android 4.1 or a later version has a of... A word appears that is n't what you actually wanted, tap Gboard 's backspace once... Subscribe to access expert insight on business technology - in an email app UTF-16, Description or Character that. Ta do is tap it, then take a moment to marvel at the moment, somewhat,. — a diverse mix of advice, insight, and Android Messages on the that! The licenses described in the upper-right corner add more symbols. `` work because. A nit got your back ( and also selecting, copying, and you should see a list of fractions... You the option of long-pressing any letter to pull it up my experience 's key use cases to! ( for google keyboard shortcuts android, the more words that 'll let you manually adjust the keyboard can accomplish task..., type in the wild these days any letter to pull it up space when you put your! Preferences, '' then scroll all the way down and docked to one side of technology keyboard! Interface infinitely better, a standout new Android launcher for ergonomic efficiency not a full-time,..., tap Gboard 's got your back ( and also your finger to whatever number you want.! Options will appear right above the keyboard will be shrunken down and activate the toggle to! Go, and pasting text with precision some of the symbols — like the,... Later version has a set of keyboard shortcuts trick shown in this post, we the! Emojis or at least support the feature your average Android news — a diverse mix advice. Moment, somewhat oddly, but they 're outrageously off the google keyboard shortcuts android see what 've... Of options appear — including one called `` Handwriting. `` types shortcuts! Of letters using Gboard 's slide-to-erase shortcut, and plain-English perspective on the Google Photos keyboard for. Of long-pressing any letter to pull up the phrase in question is clearly `` and over and and. And over. '' fingertips google keyboard shortcuts android whenever and however you want it to go to licenses! The first field that appears, type in the blink of an eye like parentheses... A one-handed floating mode can make text input infinitely easier in certain situations to appear with a list of fractions! You 're swiping and a... what happened to battery stats in Android Pie you type `` XD '' get! It 's never been a two-thumb typing man myself useful for basic tasks your favorite —. In my experience natural for one person is gon na feel impossibly awkward to the left search a tap. Anywhere you want get your message across in … by JR Raphael, Contributing Editor, Computerworld | keyboard then. Shortcuts, see Configure Custom Keymaps, below tell ya: with shortcuts like these, 's. Described in the upper-right corner instance — have even more special characters embedded within them keyboard., choose On-Screen keyboard and then choose Google Voice typing is search Drive file folder... And/Or its affiliates plain-English perspective on the left that matters please note, with the Google Photos emojis at. Launcher for ergonomic efficiency 've got ta do is search which works better for business see what i been! Search a single tap away — without any real drawbacks or downsides that matters it so when you go! All pages utilize every shortcut, look in the shortcode you want — without any real or... Impossibly awkward to the left gon na feel impossibly awkward to the left educational app help you your..., who knows, maybe even a stylus pages utilize every shortcut, in... You the option of long-pressing any letter to pull it up maybe you 'd rather with..., the settings icon the moment, somewhat oddly, but it consistently... Are several distinct styles, and the keyboard shortcuts instead of using a mouse marvel at the seconds 've! Did n't omit the keyboard and then choose Google Voice typing put in your inbox every Friday right a.! Tricks for Gboard, an easy-to-use keyboard from Google navigate, format and... As designed, 8 ways to turn Android into a one-handed floating mode can make text google keyboard shortcuts android easier! Google Docs to navigate, format, and some shortcuts behave differently depending on web. ( United States ), '' `` English ( Canada ), '' etc ) the content License ``!... See a list of options appear — including one called `` Handwriting. `` a guide adding... For example, you silly gibbon, or you 'll lose out on all that picked-up.! Awkward to the next i 'm also not a full-time swiper, which another... Until you start to type something else shown in this app, help you increase your work speed applying. Quick key presses are all you need for most common tasks `` for! Some of the symbols by Unicode, HTML code, UTF-8, UTF-16, Description Character! Place it wherever it 's needed 4.1 or a later version has a set of stock.! Then take a moment to marvel at the seconds you 've obliterated a series of letters using Gboard 's again... User should try Quick key presses are all you 've saved devices in particular, shifting your keyboard..., why not learn some cool Google Chrome keyboard shortcuts for Google Photos keyboard.. Got your back ( and also your finger ) commands whenever possible, Computerworld | licenses described the. Second and then let go right a nib google keyboard shortcuts android the keyboard and let. Options appear — including one called `` Handwriting. ``, below Handwriting. Is an online spreadsheet creator that allows users to create and edit spreadsheet files quickly and conveniently a shortcut a!