All guides
How to Make a Table in Google Sheets Step by Step
Select your list and its headings in Google Sheets, then choose Format > Convert to table. Name it, set column types and add a total row.
How to Multiply in Google Sheets With Formulas
Type =B2*C2 and press Enter to multiply two cells in Google Sheets. Fill it down, fix one factor with $H$2, or use PRODUCT and SUMPRODUCT.
How to Sort by Date in Google Sheets Without Mixing Rows
Sort dates in Google Sheets oldest to newest with A to Z or newest first with Z to A, keep rows together, and fix text dates that sort out of order.
How to Total a Column in Google Sheets With SUM
Type =SUM(D2:D13) under your numbers and press Enter to total a column in Google Sheets, or select the cells and read Sum at the bottom right.
How to Add Columns in Google Sheets, One or Several at Once
Right-click a column letter in Google Sheets and choose Insert 1 column left or right. Add several at once, use the keyboard or go past the last letter.
How to Insert Multiple Rows in Google Sheets
Select as many row numbers as new rows you need, right-click and choose Insert rows above or below. Plus the shortcut, phone steps and 100 rows at the end.
How to Create a Drop Down List in Google Sheets
Select the cells, click Insert > Dropdown, type each choice and click Done. Pick Dropdown (from a range) to take the choices from cells instead.
How to Add Check Boxes in Google Sheets for a Checklist
Select the cells and choose Insert > Checkbox in Google Sheets. Then count the ticks, color finished rows, use your own words and add boxes on Android.
How to Wrap Text in Google Sheets and Show Every Line
Select the cells, then choose Format > Wrapping > Wrap in Google Sheets. See the toolbar button, the phone steps and how to show lines a row still hides.
How to Use Reddit and Find Your First Communities
To use Reddit, search a topic, open the Communities tab and join a group that fits. Then save posts, comment and post the way each community expects.
How to Quote on Reddit in Posts and Comments
To quote on Reddit, click Aa in the comment box, put the cursor in the line and click the 66 Quote Block button, or start the line with > in Markdown.
How to Freeze a Row in Google Sheets and Unfreeze It
To freeze a row in Google Sheets, click View > Freeze > 1 row. Use Up to row for more rows, No rows to unfreeze, and Repeat frozen rows to print.
How to Delete a Reddit Account on Web and Phone
Open Settings from your Reddit avatar, then Delete account under Advanced. Deletion leaves posts up and keeps Premium billing, so handle both first.
How to Remove Duplicates in Google Sheets
Select your table, open Data > Data cleanup > Remove duplicates, tick Data has header row if you have headings and pick columns. UNIQUE keeps the original.
How to Alphabetize and Sort in Google Sheets
Select the whole table, choose Data > Sort range > Advanced range sorting options, tick Data has header row, pick a column and A to Z, then select Sort.
How to Make a Graph in Google Sheets Step by Step
Select your data with its headers, click Insert > Chart, then pick a line, column or pie chart in Setup. Plus how to bring back a missing line.
How to Fix Steam Mobile Authenticator Not Working
Fix Steam mobile authenticator not working by using a fresh code, correcting your phone's clock, or switching sign-in methods.
How to Fix an 8BitDo Controller Not Connecting to PC
Fix an 8bitdo controller not connecting to pc by selecting its Windows mode, pairing through the right connection, and updating firmware.
How to Fix Discord Phone Verification Problems
Discord phone verification not working? Fix number errors, wait out timeouts, find missing SMS codes, and unlink an old account.
How to Fix Missing Apps on the Fire TV Home Screen
Fix a Fire TV home screen not showing apps by finding installed apps, restoring their placement, syncing content, and restarting your device.
How to Fix Discord Stuck on a Gray Screen
Fix Discord stuck on grey screen by reloading the app, fully quitting it, clearing its cache, and reinstalling if the screen stays blank.
How to Fix MacBook Date and Time Not Updating
Fix your MacBook time not updating by restoring internet access, enabling automatic date and time, and correcting time zone settings.
How to Reconnect a Ring Doorbell to a New WiFi Network
Learn how to reconnect Ring Doorbell to new WiFi through Device Health in the Ring app, then finish setup with your new network password.
How to Change the Local IP Address on a Mac
To change IP address settings on your Mac, use a manual address, renew the DHCP lease, or create a router reservation for a specific local address.
