Relative, Absolute, and Mixed Cell References in Google Sheets
Understand A2, $A$2, $A2, and A$2, then copy formulas while keeping shared inputs fixed and row-specific values relative.
Browse more Find practical software and app guides, setup instructions, troubleshooting steps and productivity tips for popular desktop and online applications.
Understand A2, $A$2, $A2, and A$2, then copy formulas while keeping shared inputs fixed and row-specific values relative.
Learn how to create complex formulas with clear steps, practical tips, and troubleshooting guidance for a reliable result.
Add, subtract, multiply, and divide in Google Sheets with cell references, then edit formulas and check that the results use the right cells.
Manage sheet tabs within a Google Sheets file: add and rename worksheets, reorder them, copy a sheet, and check what to keep before deleting one.
Create a spreadsheet, understand cell addresses and ranges, and use copying, moving, paste options, and autofill to organize your data.
Create a blank table or convert text into one, then add or delete rows, apply styles, and control borders in Word 2016.
Troubleshoot a stuck or failed Clipchamp export by checking source files, storage, browser performance and hardware acceleration in a safe order.
Disable the shake-triggered feedback prompt in Google Maps on Android, iPhone or iPad, and keep the option to send feedback manually.
Stop video previews from playing automatically in Google Maps, or limit autoplay to Wi-Fi, using the Android and iPhone app settings.
Scout photo locations with satellite imagery, Street View, terrain, saved lists and crowd estimates, then check access and conditions before your shoot.
Restore a Canva design from Trash within its recovery window, check the correct account and team, and find out what to do if the design is missing.
Prepare a Canva presentation for offline use on the device you will present from, check unsupported embeds and download a backup before losing internet access.
Use Canva's Background Generator to replace a photo background, write a useful scene prompt and check the result before downloading.
Understand what Auto Tab Discard does, when it can improve responsiveness, and how to exclude important tabs before they reload.
Hide a pinned Game Assist overlay, close it for the current session or uninstall the widget from Windows 11 without removing Microsoft Edge.
Import Chrome bookmarks and history into Safari, check passwords and extensions, set your default browser and configure optional iCloud syncing.
See what LibreWolf changes from Firefox, how its privacy defaults affect websites, and what to check before using it as your main browser.
Set Windows policies for specific Chrome AI features, verify that Chrome accepts them and undo only the values you changed.
Use Chrome's password manager, screenshot commands, page translation and Reading List, then check whether you still need extensions for those tasks.
Look up older versions of a missing webpage, choose an archive date and check the Wayback Machine extension's automatic lookup and saving settings.