ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Locking Columns in excel (https://www.excelbanter.com/excel-worksheet-functions/228849-locking-columns-excel.html)

gueyo

Locking Columns in excel
 
Can colums be locked so that they do not expand in width?
--
gueyo

Venetia

Locking Columns in excel
 
Hi!! I hope this helps.

The only way to "lock" a cell is to protect the sheet. Format your cells the
width that you want them and then click on the "Format" button on your "Home"
ribbon. It should be under "Cells". Then click on "Protect Sheet". This will
require a password.

Once you protect your spreadsheet, it cannot be changed, but you can still
edit your information.


I hope this helps!!


Good Luck!


Venetia

"gueyo" wrote:

Can colums be locked so that they do not expand in width?
--
gueyo


gueyo

Locking Columns in excel
 
Thank you, very much
--
gueyo


"Venetia" wrote:

Hi!! I hope this helps.

The only way to "lock" a cell is to protect the sheet. Format your cells the
width that you want them and then click on the "Format" button on your "Home"
ribbon. It should be under "Cells". Then click on "Protect Sheet". This will
require a password.

Once you protect your spreadsheet, it cannot be changed, but you can still
edit your information.


I hope this helps!!


Good Luck!


Venetia

"gueyo" wrote:

Can colums be locked so that they do not expand in width?
--
gueyo



All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com