Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set number of columns/rows?
I have been given a commercial spreadsheet, with coulmns A to M and rows 1
to 30. How did the author set a limit to number of rows/columns? Paddy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set number of columns/rows?
hi,
not sure but one way he could have done it is to hide all rows and columns that he didn't want to use. regards FSt1 "Paddy" wrote: I have been given a commercial spreadsheet, with coulmns A to M and rows 1 to 30. How did the author set a limit to number of rows/columns? Paddy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set number of columns/rows?
If you can't scroll past column M or below row 30 the author has limited the
scroll area using VBA code. If this is a commercial product the code is probably very hidden and you won't be able to "mess" with it. If you can scroll but the other columns and rows are just a big solid gray area then the author hid the columns and rows. They may have done this with code also and may have also prevented the ability to unhide the columns/rows. If you can scroll you can try to unhide the columns/rows like this: (provided they haven't also disabled some of the menu commands) Hit function key F5 (which may have been disabled?) If the GOTO dialog opens type in N1:IV1 Hit OK Then goto the menu FormatColumnUnhide Repeat the same process for rows Biff "Paddy" wrote in message ... I have been given a commercial spreadsheet, with coulmns A to M and rows 1 to 30. How did the author set a limit to number of rows/columns? Paddy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set number of columns/rows?
"T. Valko" wrote: If you can't scroll past column M or below row 30 the author has limited the scroll area using VBA code. If this is a commercial product the code is probably very hidden and you won't be able to "mess" with it. I think that is it. Can't scroll past those cells. I had looked at settings, Help & Googled, all to no avail. I thought maybe hidden, as you and FSt1 suggested it might be, but no. I just thought it a neat trick. Thanks Paddy |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set number of columns/rows?
You're welcome!
Biff "Paddy" wrote in message ... "T. Valko" wrote: If you can't scroll past column M or below row 30 the author has limited the scroll area using VBA code. If this is a commercial product the code is probably very hidden and you won't be able to "mess" with it. I think that is it. Can't scroll past those cells. I had looked at settings, Help & Googled, all to no avail. I thought maybe hidden, as you and FSt1 suggested it might be, but no. I just thought it a neat trick. Thanks Paddy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximun number of rows and columns | Excel Discussion (Misc queries) | |||
find number in multiple columns and rows | Excel Worksheet Functions | |||
number of columns/rows | Excel Discussion (Misc queries) | |||
set number of rows equal in mutiple columns | Excel Discussion (Misc queries) | |||
How do I limit number of rows and columns on a spreadsheet | New Users to Excel |