Skip to content
View in the app

A better way to browse. Learn more.
MSFN

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Anyways to "lock" the cells from changing size in Excel?

AD1985
in Microsoft Office

Featured Replies

Hi,

I have an excel file that is set to wrap text.A problem with this setting is it seems to lengthen the cell if the text is wide enough that it is close to requiring another row (but doesn't need it) This messes up the format that I want.

Is there any way to lock the cells so they can not auto-resize?

Thanks


  • Author

Well I tried what the link suggested, but that "locking" was different from what I was asking about. It was showing how to stop the cells from being resized (or otherwise modified) by people. I'm trying to prevent the cells from being resized by excel. So that doesn't help. I tried typing and the cells still resized themselves.

Is it possible to stop Excel from auto resizing?

  • Author
Excel 2003 is not auto resizing cell width on my machine. :\

it seems we have the opposite problem, lol

Create an account or sign in to comment
Go to topic listing

Recently Browsing 0

  • No registered users viewing this page.

Account

Navigation

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.