💻 Software
How do you apply a function to all values in selected cells?
Fresh5 days ago
Mar 15, 202613191 viewsConfidence Score0%
0%
Problem
I was entering timesheet data (in minutes) into an Excel spreadsheet. Then the requirements changed - the data actually needs to be in hours. Is there a way to divide all the cells by 60 in place without using formulas? Ideally, I'd like to select all the cells and somehow say "Divide by 60." Note:…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do you apply a function to all values in selected cells?
Low Risk
It turns out you can do exactly what I wanted: Enter the number 60 into another cell, doesn't matter where. Copy that cell (ctrl-C). Select the cells you want to modify. Right-click, paste special. You get some options of what operation you want to …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix