How to increase each number in an entire column by 5% in Numbers?

Hi, I am trying to increase each number in an entire column by 5%. Please help thank you.



[Re-Titled by Moderator]


Posted on Jan 24, 2024 6:22 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 24, 2024 6:52 PM

Assuming you mean changing them in the same cells, not in another column via formulas, you can add this shortcut and use it:


https://www.icloud.com/shortcuts/ec8c361576624fe589c637d5c2dbc3f9


It allows you to do math operations on a selected range of cells. You will want to multiply by 1.05



1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to increase each number in an entire column by 5% in Numbers?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.