Share via

Why can't I select columns to increase or decrease decimal places in excel

Anonymous
2025-01-04T07:16:17+00:00

D4 cell contains the number 123.11.When I select the entire column D and click 'Decrease Decimal',nothing happens.However.if I only slect cell D4,then I can decrease the decimal places.Why is that?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2025-01-04T15:47:24+00:00

    Note that I wasn't being authoritative when I said this might make the sheet resource-hungry; however MS themselves state "Formatting cells on your worksheet can make the right information easy to see at a glance, but formatting cells that aren't being used (especially entire rows and columns) can cause your workbook's file size to grow quickly."

    You don't have to believe everything the seller promises. .-)

    IMHO, if this really were a problem, we would be getting threads here almost every day reporting massive performance losses.

    But of course there are individual cases where some users manage to do it. And if they don't have professionals like us to ask, then they need an add-in that solves the problem ... maybe.

    Andreas.

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more