Skip to content
Live2Tech
  • iPhone
  • Windows
    • Windows 11
    • Windows 10
  • Office
    • Word
    • Excel
    • Powerpoint
    • Outlook
  • Google
    • Google Docs
    • Google Sheets
    • Google Slides
    • Gmail
    • Chrome
    • Google Drive
  • Mac & Apple
    • Mac
    • iPad
    • Apple Watch
  • All Tutorials

Kermit Matthews

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker's official documentation. More about Kermit.
Control Center settings with Access Within Apps highlighted

How to Open Control Center on iPhone

November 18, 2026April 21, 2017 by Kermit Matthews

Open Control Center on an iPhone 7 by swiping up from the bottom edge. Learn to use it inside apps and customize which controls appear. Continue Reading How to Open Control Center on iPhone

Categories iPhone Tags iphone 7
iPhone Settings General About screen with the Name row highlighted

How to Change the Bluetooth Name on an iPhone

November 18, 2026April 19, 2017 by Kermit Matthews

Go to Settings > General > About > Name and type a new name. It changes your Bluetooth, AirDrop, and hotspot name. How to rename accessories too. Continue Reading How to Change the Bluetooth Name on an iPhone

Categories iPhone Tags bluetooth, iphone 7
Word processor View tab with the Gridlines checkbox highlighted and a page showing gridlines

How to Show or Remove Gridlines in Word (Page and Table Gridlines)

November 17, 2026April 18, 2017 by Kermit Matthews

Remove gridlines in Word 2013 and later: hide page gridlines on the View tab, turn off table gridlines, and remove table borders that print. Continue Reading How to Show or Remove Gridlines in Word (Page and Table Gridlines)

Categories Word Tags word 2013
how to change iphone text messaging sounds

How to Change iPhone Text Messaging Sounds

November 13, 2026April 10, 2017 by Kermit Matthews

Learning how to change the iPhone text messaging sounds is one of the first pieces of information that many iPhone users will seek out when they… Continue Reading How to Change iPhone Text Messaging Sounds

Categories iPhone Tags iphone 7
how to turn off autocorrect on an iphone 7

How to Turn Off Autocorrect on iPhone

November 10, 2026March 29, 2017 by Kermit Matthews

You type a name or a bit of slang, press Space, and your iPhone swaps it for a word you never meant. If that keeps… Continue Reading How to Turn Off Autocorrect on iPhone

Categories iPhone Tags iphone 7
Spreadsheet Format Picture pane on the Size and Properties tab with Move and size with cells selected and a picture sitting inside a cell

How to Lock an Image to a Cell in Excel

November 12, 2026March 10, 2017 by Kermit Matthews

Lock a picture to a cell in Excel with Move and size with cells or Place in Cell, and protect the sheet so images can’t be moved or deleted. Continue Reading How to Lock an Image to a Cell in Excel

Categories Excel Tags excel 2010
iPhone Transfer or Reset iPhone screen with Erase All Content and Settings highlighted

How to Factory Reset an iPhone 7

November 15, 2026March 3, 2017 by Kermit Matthews

Factory reset an iPhone 7 in Settings > General > Transfer or Reset iPhone > Erase All Content and Settings. Plus how to reset without the passcode. Continue Reading How to Factory Reset an iPhone 7

Categories iPhone Tags iphone 7
Word processor with the Reviewing Pane open on the left listing each comment with the reviewer name and text, and the Reviewing Pane button on the Review tab highlighted

How to Set Excel Column Width in Inches

November 18, 2026February 24, 2017 by Kermit Matthews

Set Excel column width and row height in inches using Page Layout view, change ruler units, and learn how Excel character widths convert. Continue Reading How to Set Excel Column Width in Inches

Categories Excel Tags excel 2013
Word processor Layout tab with the Hyphenation menu open and None highlighted

How to Turn Hyphenation On or Off in Word

November 17, 2026February 23, 2017 by Kermit Matthews

Turn off hyphenation in Word 2013 and later with Layout > Hyphenation > None, turn it back on, stop it for one paragraph, and remove leftover hyphens. Continue Reading How to Turn Hyphenation On or Off in Word

Categories Word Tags word 2013
how to stop netflix from using cellular data on iphone

How to Stop Netflix From Using Cellular Data on iPhone

November 18, 2026February 21, 2017 by Kermit Matthews

Netflix gives you two levels of control on an iPhone. To stop it from using cellular data at all, open Settings > Cellular and turn… Continue Reading How to Stop Netflix From Using Cellular Data on iPhone

Categories iPhone Tags iphone 7
iPhone App Store prompt offering to download the last compatible version of an app on an older iOS version with the Download button highlighted

How to Get Netflix on an Older iPhone

November 15, 2026February 20, 2017 by Kermit Matthews

Set up Netflix on an iPhone 7: install the last compatible app version from Purchased, sign in, adjust downloads and data, and what to do if it won’t install. Continue Reading How to Get Netflix on an Older iPhone

Categories iPhone Tags iphone 7
how to change the default font in outlook 2013

How to Change the Default Font in Outlook 2013

November 15, 2026February 14, 2017 by Kermit Matthews

The default settings in Outlook 2013 are typically fine for most users, but you might eventually decide to change some options, such as how often… Continue Reading How to Change the Default Font in Outlook 2013

Categories Outlook Tags outlook 2013
how to change the slide size in powerpoint 2013

How to Change the Slide Size in PowerPoint

November 17, 2026February 13, 2017 by Kermit Matthews

If your slides sit inside black bars on a TV or projector, or the edges get cut off when you print, the slide size does… Continue Reading How to Change the Slide Size in PowerPoint

Categories Powerpoint Tags powerpoint 2013
Messages settings with the online messaging switch turned off

How to Turn Off iMessage on iPhone

November 17, 2026February 9, 2017 by Kermit Matthews

Turn off iMessage on iPhone 7 in Settings > Messages, keep Send as SMS on, and deregister your number if you switch to Android. Continue Reading How to Turn Off iMessage on iPhone

Categories iPhone Tags iphone 7
Spreadsheet with the SQRT formula in the formula bar and a column of numbers with their square roots, plus a power formula alternative

How to Find the Square Root in Excel

November 10, 2026February 7, 2017 by Kermit Matthews

Find square roots in Excel with =SQRT(A2) or =A2^(1/2), calculate cube and nth roots, handle negative numbers and show the square root symbol. Continue Reading How to Find the Square Root in Excel

Categories Excel Tags excel 2013, Formulas
Email app new message window with a zipped folder attached and the Attach File menu open showing Browse This PC and cloud file options

How to Send a Folder in Outlook (Zip or Share a Link)

November 17, 2026January 25, 2017 by Kermit Matthews

Send a folder in Outlook by zipping it and attaching the ZIP, or share it with a OneDrive link to avoid attachment size limits. Covers Windows, Mac and web. Continue Reading How to Send a Folder in Outlook (Zip or Share a Link)

Categories Outlook Tags outlook 2013
how to delete imovie on an iphone 7

How to Delete iMovie From Your iPhone

November 14, 2026January 23, 2017 by Kermit Matthews

Deleting iMovie also deletes the projects stored inside it, so export or share any project you want to keep before you remove the app. After… Continue Reading How to Delete iMovie From Your iPhone

Categories iPhone Tags iphone 7
how to see how many songs are saved to your iphone

How to See How Many Songs Are on Your iPhone

November 9, 2026January 20, 2017 by Kermit Matthews

The Songs list in the Music app doesn’t show an obvious total, so the quickest place to look is Settings: tap General, then About, and… Continue Reading How to See How Many Songs Are on Your iPhone

Categories iPhone Tags iphone 7
Spreadsheet app with the plus New sheet button next to the sheet tabs and the Insert Sheet command on the Home tab

How to Insert a New Worksheet in Excel (4 Ways)

November 10, 2026January 18, 2017 by Kermit Matthews

Insert a new worksheet in Excel with the + button, Shift + F11, Home > Insert > Insert Sheet, or a right-click, and add several sheets at once. Continue Reading How to Insert a New Worksheet in Excel (4 Ways)

Categories Excel Tags excel 2010
Image editor Layers panel with two layers selected and the right-click menu showing Merge Layers highlighted

How to Merge Layers in Photoshop CS5 (and Newer)

November 17, 2026January 17, 2017 by Kermit Matthews

Merge layers in Photoshop CS5 with Merge Layers, Merge Down, Merge Visible, or Flatten Image, plus Stamp Visible and Smart Objects to keep originals. Continue Reading How to Merge Layers in Photoshop CS5 (and Newer)

Categories Photoshop
Symbol dialog with a check mark character selected in a symbol font

How to Insert a Check Mark in Word

November 10, 2026January 4, 2017 by Kermit Matthews

Insert a check mark in Word with Insert > Symbol (Wingdings 252), by typing 2713 then Alt + X, or add a clickable check box from the Developer tab. Continue Reading How to Insert a Check Mark in Word

Categories Word Tags word 2013
how to install the bitmoji keyboard on an iPhone

How to Get the Bitmoji Keyboard on iPhone

November 16, 2026December 30, 2016 by Kermit Matthews

To use Bitmoji on an iPhone you need three things: the Bitmoji app with an avatar you’ve created, the Bitmoji keyboard added in Settings, and… Continue Reading How to Get the Bitmoji Keyboard on iPhone

Categories iPhone Tags iphone 7
iPhone alarm Sound screen with the Pick a song option highlighted and a selected song checked

How to Set a Song as Your Alarm on iPhone (Any Model)

November 18, 2026December 29, 2016 by Kermit Matthews

Set a song as your iPhone alarm sound in the Clock app, see which songs work, change the Sleep schedule wake-up sound, and fix alarms that play the wrong tone. Continue Reading How to Set a Song as Your Alarm on iPhone (Any Model)

Categories iPhone Tags iphone 7
how to set a pandora alarm on an iPhone

How to Use the Pandora App as an Alarm Clock on Your iPhone

November 10, 2026December 27, 2016 by Kermit Matthews

The alarm clock on your iPhone is incredibly useful, and may have already replaced any separate alarm clock that you had previously used. You can… Continue Reading How to Use the Pandora App as an Alarm Clock on Your iPhone

Categories iPhone Tags iphone 7
how to stop deleting meeting requests from your inbox in outlook 2013

How to Stop Outlook from Deleting Meeting Requests

November 9, 2026December 22, 2016 by Kermit Matthews

You accepted a meeting invitation, went back to check the agenda in the email, and it was no longer in your Inbox. Outlook did not… Continue Reading How to Stop Outlook from Deleting Meeting Requests

Categories Outlook Tags outlook 2013
Excel Format Cells dialog on the Number tab with the Text category highlighted

How to Stop Excel from Changing Numbers to Dates

November 14, 2026December 21, 2016 by Kermit Matthews

Stop Excel from changing numbers to dates by formatting cells as Text, typing an apostrophe, entering fractions correctly, or importing CSVs as text. Continue Reading How to Stop Excel from Changing Numbers to Dates

Categories Excel Tags excel 2013
Phone General About screen with the Serial Number row highlighted beneath model name, model number and software version

How to Find the Serial Number on an iPhone 7 (5 Ways)

November 18, 2026December 16, 2016 by Kermit Matthews

Find your iPhone 7 serial number in Settings > General > About, in Finder or iTunes, your Apple Account, or on the box, plus what to do if it won’t turn on. Continue Reading How to Find the Serial Number on an iPhone 7 (5 Ways)

Categories iPhone Tags iphone 7
why do columns have number labels instead of letters in Excel 2013

Why Does Excel Show Column Numbers Instead of Letters?

November 15, 2026December 14, 2016 by Kermit Matthews

You open a spreadsheet and the column headings read 1, 2, 3 instead of A, B, C, and a simple formula in the formula bar… Continue Reading Why Does Excel Show Column Numbers Instead of Letters?

Categories Excel Tags excel 2013
how to stop outlook notifications from appearing at the right side of the screen

How to Turn Off Desktop Alerts in Outlook

November 18, 2026December 13, 2016 by Kermit Matthews

You are halfway through a sentence and a new-mail pop-up slides into the corner of the screen. In classic Outlook for Windows you stop it… Continue Reading How to Turn Off Desktop Alerts in Outlook

Categories Outlook Tags outlook 2013
Font dialog with the Set As Default button highlighted

How to Change the Font for an Entire Document in Word

November 18, 2026December 12, 2016 by Kermit Matthews

Change the font of a whole Word document with Ctrl+A, theme fonts or the Normal style, check headers and text boxes, and set a default only if you want one. Continue Reading How to Change the Font for an Entire Document in Word

Categories Word
how to change the sent from name in outlook 2013

How to Change Your Name on Emails Sent From Outlook

November 16, 2026December 7, 2016 by Kermit Matthews

If your emails arrive showing an old name, a nickname or only your address, the fix depends on the kind of account you send from.… Continue Reading How to Change Your Name on Emails Sent From Outlook

Categories Outlook Tags outlook 2013
Browser Settings System page with the Use graphics acceleration when available switch and the Relaunch button highlighted

How to Turn Off Hardware Acceleration in Chrome, Edge, Firefox, Discord, and More

November 18, 2026December 2, 2016 by Kermit Matthews

Turn off hardware acceleration in Chrome, Edge, Firefox, Discord, Spotify, Slack, Steam, and Office to fix flickering, black screens, and crashes. Continue Reading How to Turn Off Hardware Acceleration in Chrome, Edge, Firefox, Discord, and More

Categories Chrome, Windows 11
how to hide safari on an iphone 7

How to Hide Safari on iPhone

November 17, 2026November 29, 2016 by Kermit Matthews

If you are hiding Safari from a child, Screen Time’s parental controls let a parent block an app on the child’s iPhone until the parent… Continue Reading How to Hide Safari on iPhone

Categories iPhone
detailed icloud storage usage information

How to Check Remaining iCloud Storage on iPhone

November 9, 2026November 28, 2016 by Kermit Matthews

On a current iPhone, open Settings, tap your name, then tap iCloud. The bar graph at the top shows how much of your iCloud storage… Continue Reading How to Check Remaining iCloud Storage on iPhone

Categories iPhone Tags iphone 7
how to enable kiosk mode in powerpoint 2013

How to Use Kiosk Mode in PowerPoint

November 10, 2026November 21, 2016 by Kermit Matthews

A slide show playing in a trade-show booth, a hotel lobby or a museum corner has nobody standing beside it to press the arrow key.… Continue Reading How to Use Kiosk Mode in PowerPoint

Categories Powerpoint Tags powerpoint 2013
how to delete all songs from an iPhone at once

How to Delete Music From Your iPhone

November 13, 2026November 18, 2016 by Kermit Matthews

An offline music library can easily fill several gigabytes of iPhone storage. The fastest full clean-up is Settings > Apps > Music > Downloaded Music,… Continue Reading How to Delete Music From Your iPhone

Categories iPhone Tags ios 10
iPhone Date and Time settings with Set Automatically turned on and the Time Zone highlighted

Will My iPhone Change for Daylight Saving Time?

November 18, 2026November 7, 2016 by Kermit Matthews

An iPhone adjusts for daylight saving time when its automatic Date & Time switches are on. See which switches to check and what to do if the clock didn’t move. Continue Reading Will My iPhone Change for Daylight Saving Time?

Categories iPhone Tags ios 10
Phone messages conversation dragged to the left to reveal the time each message was sent on the right edge

How to See What Time a Text Message Was Sent on iPhone

November 18, 2026November 3, 2016 by Kermit Matthews

See the exact time each text was sent on iPhone by swiping left in Messages, plus how to find dates, delivered and read times. Continue Reading How to See What Time a Text Message Was Sent on iPhone

Categories iPhone Tags iphone 7
how to add filler or placeholder text in word 2013

How to Add Filler Text in Word

November 8, 2026November 2, 2016 by Kermit Matthews

When you are building a template, a brochure layout or a page mock-up, you often need the page to look full before the real words… Continue Reading How to Add Filler Text in Word

Categories Word Tags word 2013
how to turn off vibrating feedback on iphone 7

How to Turn Off Haptic Feedback on iPhone

November 18, 2026October 24, 2016 by Kermit Matthews

If every switch you flip, every key you type and every long press makes your iPhone tap back at you, start with one setting: open… Continue Reading How to Turn Off Haptic Feedback on iPhone

Categories iPhone Tags iphone 7
how to remove the unknown senders tab in messages on an iphone 7

How to Remove the Unknown Senders Tab on the iPhone 7

November 10, 2026October 19, 2016 by Kermit Matthews

Your iPhone’s Messages app might have two tabs at the top of it, and all of your texts may be split between these two tabs.… Continue Reading How to Remove the Unknown Senders Tab on the iPhone 7

Categories iPhone Tags iphone 7
how to show a dollar symbol to the left of a number in excel 2013

How to Show a Dollar Sign Next to Numbers in Excel

November 18, 2026October 7, 2016 by Kermit Matthews

When people ask how to show a dollar sign in Excel, they usually mean one of two looks. Either the $ sits right against the… Continue Reading How to Show a Dollar Sign Next to Numbers in Excel

Categories Excel Tags excel 2013
how to disable autofill on an iphone 7

How to Turn Off AutoFill on iPhone

November 18, 2026October 5, 2016 by Kermit Matthews

Safari keeps filling in your old address, a card you meant to delete, or a password on a phone the whole family uses. AutoFill has… Continue Reading How to Turn Off AutoFill on iPhone

Categories iPhone Tags iphone 7
how to change an email password in ios 10

Why Isn’t There an Option to Change My Email Password on My iPhone 7?

April 22, 2023September 27, 2016 by Kermit Matthews

***Traffic here always increases when there is a sign-in issue with a major service provider. Unfortunately, in most cases, there isn’t much you can do… Continue Reading Why Isn’t There an Option to Change My Email Password on My iPhone 7?

Categories iPhone Tags Email, ios 10, iphone 7
Phone Calls on Other Devices settings with the main toggle on and a list of devices that can take calls

How to Turn On Calls on Other Devices on iPhone

November 18, 2026September 6, 2016 by Kermit Matthews

Turn on Calls on Other Devices on iPhone to answer calls on your iPad or Mac, check the requirements, and fix a switch that won’t turn on. Continue Reading How to Turn On Calls on Other Devices on iPhone

Categories iPhone Tags ios 9, Phone
iPhone Control Center with the moon icon in the status bar and the Do Not Disturb Focus button turned on

Why Is There a Moon on My iPhone? (And How to Turn It Off)

November 13, 2026August 26, 2016 by Kermit Matthews

The moon on your iPhone means Do Not Disturb is on. Learn what each moon icon means, how to turn it off in Control Center, and why it keeps coming back. Continue Reading Why Is There a Moon on My iPhone? (And How to Turn It Off)

Categories iPhone
how to add or remove text messages from spotlight search

How to Remove Text Messages from iPhone Spotlight Search

November 10, 2026August 2, 2016 by Kermit Matthews

If you use the Spotlight Search feature on your iPhone, then you are probably aware of how much easier it can make it to find… Continue Reading How to Remove Text Messages from iPhone Spotlight Search

Categories iPhone Tags iphone 5
how to delete background layer in photoshop cs5

How to Delete the Background Layer in Photoshop CS5

November 17, 2026July 21, 2016 by Kermit Matthews

Working with layers is one of the most important elements of Adobe Photoshop CS5. You can do a lot to a layer, such as resizing… Continue Reading How to Delete the Background Layer in Photoshop CS5

Categories Photoshop
switch to numerical formatting - step 4

How to Apply Number Formatting to a Cell in Excel 2013

November 14, 2026July 14, 2016 by Kermit Matthews

Excel 2013 can do a very good job of automatically detecting the type of information that you have entered into a cell. Unfortunately it does not… Continue Reading How to Apply Number Formatting to a Cell in Excel 2013

Categories Excel Tags excel 2013
Windows 11 create account dialog with the Add a user without a Microsoft account option highlighted

How to Hide the Location Icon for iPhone System Services

November 10, 2026July 7, 2016 by Kermit Matthews

Hide the iPhone status bar location arrow for system services in Location Services > System Services > Status Bar Icon. Continue Reading How to Hide the Location Icon for iPhone System Services

Categories iPhone
Older posts
Newer posts
← Previous Page1 … Page53 Page54 Page55 Page56 Next →

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Live2Tech

Plain-English, step-by-step guides for the devices and apps you use every day.

Apple

  • iPhone
  • iPad
  • Mac
  • Apple Watch

Windows

  • Windows 11
  • Windows 10

Microsoft Office

  • Word
  • Excel
  • Powerpoint
  • Outlook

Google

  • Google Docs
  • Google Sheets
  • Google Slides
  • Gmail
  • Chrome
  • Google Drive
  • About Us
  • Contact
  • Disclaimer
  • Privacy Policy
© Live2Tech.com 2026
  • iPhone
  • Windows
    • Windows 11
    • Windows 10
  • Office
    • Word
    • Excel
    • Powerpoint
    • Outlook
  • Google
    • Google Docs
    • Google Sheets
    • Google Slides
    • Gmail
    • Chrome
    • Google Drive
  • Mac & Apple
    • Mac
    • iPad
    • Apple Watch
  • All Tutorials