Current:Home > MarketsTech tips to turn yourself into a Google Workspace and Microsoft Office pro-InfoLens
Tech tips to turn yourself into a Google Workspace and Microsoft Office pro
View Date:2024-12-23 10:40:53
Google Workspace and Microsoft Office are built for productivity, and they work even better when you really know what you’re doing.
Below are a handful of the best tricks I've picked up from years of using this software. Maybe they can unlock some extra time in your day.
Copy and paste formatting: You picked the perfect font, size and spacing. Now copy that all over your document (or spreadsheet or presentation). Select the text and click the paint roller icon in the toolbar. Click and drag over the text you want to transform. Voila!Roll it back: Three people and 12 versions later, you’re totally lost editing a Google Doc. Retrace your steps by opening File > Version history > See version history. Choose a time on the right, and you’ll see who did what (and when!). On the flip side, unless you save the doc as a new one with a different filename, everyone gets to see your edits.
Tell it like it is: Dictate text instead of typing to save time or give your wrists a break. You don’t need to buy anything new; it’s all built in. In a Google Docs document, open Tools > choose Voice typing. In Word, go to Home > Dictate. FYI, you can use commands like "period" and "comma" for punctuation and "new paragraph" and "new line" for formatting.
Cut out the distractions: Here’s a Word trick to focus on your text and nothing else. Open the View tab on the menu, then click Focus. Presto, everything except the document vanishes and you're in a full-screen view. Move the cursor to the top of the screen or hit Esc when you're ready to be distracted again.
Freeze frame: In Excel, it helps to keep your column and row headings stuck in place while you scroll around big spreadsheets. Select the cell where the actual data starts, and then click the View menu > Freeze Panes.
Sharing is caring: This one’s perfect for when you want to share a Google Doc as a template but you don’t want other people messing around in your file. Click Share, then change the link settings to Anyone with the link and choose Editor. Before you hit “Send,” replace the text in the URL that says “edit” with “template/preview.” It’ll force recipients to make their own copies and edits, leaving your original under your full control. So smart!
What's that word again? In Word and Docs, right-click on a word and choose Define to find out what it means. You can even get guidance on pronunciation. Just do this before your big presentation, OK?
A shortcut you’ll use all the time
This one is so good it deserves a little more space. There’s an easy way to open a new Google Doc file, Google’s version of a Word document. The same goes for opening a new Google Sheet (Google’s version of Excel).
You can even use it to open Google Calendar with a new blank calendar entry for you to fill in, which is faster than going through your calendar itself or Google Drive.
First, make sure you’re signed in to your Google account. Then open the Chrome browser and type in the name of a Google application followed by “.new” in the browser’s URL bar.
Here’s a handy list for reference. You can use any of the following shortcuts for each application:
◾ Google Docs: document.new, docs.new, doc.new
◾ Google Sheets: spreadsheet.new, sheets.new, sheet.new
◾ Google Slides: presentation.new, slides.new, slide.new
◾ Google Forms: forms.new, form.new
◾ Google Keep: keep.new, notes.new, note.new
◾ Google Calendar: meeting.new, cal.new
◾ Google Meeting: meet.new
The views and opinions expressed in this column are the author's and do not necessarily reflect those of USA TODAY. Learn about all the latest technology on the Kim Komando Show, the nation's largest weekend radio talk show. Kim takes calls and dispenses advice on today's digital lifestyle, from smartphones and tablets to online privacy and data hacks. For her daily tips, free newsletters and more, visit her website.
veryGood! (1758)
Related
- Residents urged to shelter in place after apparent explosion at Louisville business
- GirlsDoPorn owner goes from FBI's Most Wanted List to San Diego court appearance
- Will Smith, Dodgers agree on 10-year, $140 million contract extension
- Beyoncé 'Cowboy Carter' tracklist hints at Dolly Parton, Willie Nelson collaborations
- RHOBH's Erika Jayne Reveals Which Team She's on Amid Kyle Richards, Dorit Kemsley Feud
- Baltimore bridge collapse reignites calls for fixes to America's aging bridges
- The Daily Money: No more sneaking into the Costco food court?
- 34 Container Store Items That Will Organize Your Kitchen
- Olympic Skier Lindsey Vonn Coming Out of Retirement at 40
- Brittany Snow Reveals “Saddest Part” of Ex Tyler Stanaland's Selling The OC Drama
Ranking
- Forget the bathroom. When renovating a home, a good roof is a no-brainer, experts say.
- USWNT's Midge Purce will miss Olympics, NWSL season with torn ACL: 'I'm heartbroken'
- Sweet 16 bold predictions forecast the next drama in men's March Madness
- GirlsDoPorn owner goes from FBI's Most Wanted List to San Diego court appearance
- Pistons' Tim Hardaway Jr. leaves in wheelchair after banging head on court
- The Daily Money: No more sneaking into the Costco food court?
- Millions in India are celebrating Holi. Here's what the Hindu festival of colors is all about.
- Families of 5 men killed by Minnesota police reach settlement with state crime bureau
Recommendation
-
Prominent conservative lawyer Ted Olson, who argued Bush recount and same-sex marriage cases, dies
-
School board postpones vote on new busing plan after audit on route change disaster
-
Orioles, Ravens, sports world offer support after Francis Scott Key Bridge collapse
-
Ruby Franke’s Estranged Husband Kevin Details How She Became Involved in Extreme Religious Cult
-
What Just Happened to the Idea of Progress?
-
A solution to the retirement crisis? Americans should work for more years, BlackRock CEO says
-
Ski town struggles to fill 6-figure job because candidates can't afford housing
-
Truck driver indicted on murder charges in crash that killed Massachusetts officer, utility worker