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!

Thanks Max, they were indeed hidden although I would swear I'd tried to
'unhide' earlier today but to no avail. It worked this time. Thanks for
your help.

"Max" wrote:

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!