Google Sheets dropdown: reject invalid entries or show a warning
Choose whether a status column should block an unlisted value or merely warn, then test the rule on a small empty range.
Read the guide← All guides
Photos & storage
Keep photos and documents usable. Work through backups, file formats, sharing and the space on your devices.
59 guides · Page 1 / 4
Compress pictures in PowerPoint without losing your original deck
Work on a separate copy, choose the scope of picture compression and inspect the saved slides before keeping the smaller presentation.
Read the guideExcel Paste Values: keep a result without copying its formula
Paste a fixed result into a separate copy, check the formula bar and preserve number formats when dates or percentages matter.
Read the guideWord marks correct words as wrong: check the selected text’s language
Set proofing language for a passage without translating it or disabling checks throughout the document. Verify the result on a short copied sample.
Read the guideExcel shows the formula instead of its result
Separate Show Formulas from a cell stored as text. Test one copied cell before changing formatting across a workbook.
Read the guideWhy a copied item remains in Windows clipboard history
Check pinned items separately when clearing Windows 11 clipboard history, and distinguish local history from cross-device sync.
Read the guideReplace text in Word without changing the wrong passages
Review matches in context, narrow the search, and keep a copy before using Replace All in a Word document.
Read the guideA word is visible in your PDF, but search cannot find it
Check the search scope and text layer before interpreting zero matches as missing information.
Read the guidePaste into Word without bringing the wrong formatting
Try the paste options on a small sample, then check headings, lists and links before replacing a larger passage.
Read the guideWhy one MP4 video plays and another does not
Check the file transfer, video and audio codecs, and the receiving app before exporting a compatible copy.
Read the guideFit a photo into a square without stretching faces
Choose a crop or margins, preserve the original proportions and check what the final layout removes.
Read the guideHow wide can you print a 3000-pixel photo?
Use pixel width and PPI to calculate print size, then check resampling and the final print preview.
Read the guideKeep the movement when you export a Live Photo
Choose a still image, a shareable video or the original pair, and check what the recipient can actually play.
Read the guideExport an edited photo or its original from Photos on Mac
Choose the version you need without undoing your work. Check the exported crop, file type and destination before sending.
Read the guideA Mac alias opens your file. It is not a spare copy.
Find the original behind a Finder alias before copying a project, sending files or relying on a backup.
Read the guideExtract the ZIP before editing: know where your changes are saved
Open documents from a named working folder, reopen them after saving and check the copy you are about to send.
Read the guideExcel dates shifted by years after copying: check both workbooks
A 1,462-day shift can point to different date systems. Compare workbook settings and known dates before changing the data.
Read the guideA Word heading is stranded at the bottom of the page
Keep a heading with the paragraph after it. Understand the difference between paragraph linking, keeping lines together and forcing a new page.
Read the guide