Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you can't see beyond col header AO / row header 194, this indicates
they're probably hidden. Try selecting the entire sheet, click Format Column Unhide (similarly Row Unhide). If the unhide options are grayed out, then the sheet is protected. Click Tools Protection Unprotect sheet (you may need to supply the password). If you can see beyond col header AO / row header 194 (there's nothing hidden) but you can't select/scroll beyond, then there's probably a sub restricting scrolling in the sheet within A1:AO194. It may be best that you check with the person who applied the sheet protection or restricted the scroll area. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Philip Drury" wrote: Am working in an excel workbook, sheet 2 is a data input area where each month we add a column for that month's data, however, we have reached column AO and it states that we are at the end of the worksheet, it also ends at row 194 too. Does anyone know how to release the columns and rows, I know we should be able to go to column IV! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Restricted | Excel Discussion (Misc queries) | |||
Restricted Usage | Excel Discussion (Misc queries) | |||
I cannot see my worksheet I think I restricted it somehow | Excel Worksheet Functions | |||
Linking an entire worksheet from a restricted drive? | Excel Worksheet Functions | |||
Linking an entire worksheet from a restricted drive? | Excel Worksheet Functions |