ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to unlock the cell range limitation? (https://www.excelbanter.com/excel-discussion-misc-queries/246357-how-unlock-cell-range-limitation.html)

manng118

How to unlock the cell range limitation?
 
I have received an excel file which only I can see the cell range from A to U
col.
I would like to ask how to unlock the cell range for the selection after col
U??

Jacob Skaria

How to unlock the cell range limitation?
 
--Hit Ctrl+A to select all cells. From menuFormatColumnUnhide

--If FormatColumnUnhide option is disabled then the sheet is protected.
Unprotect the sheet from menu ToolsProtectionUnprotect.but cant help if you
dont have the password.

If this post helps click Yes
---------------
Jacob Skaria


"manng118" wrote:

I have received an excel file which only I can see the cell range from A to U
col.
I would like to ask how to unlock the cell range for the selection after col
U??



All times are GMT +1. The time now is 04:20 AM.

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