Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Intech" wrote:
How can I specify the number of rows in an Excel spreadsheet? You can't "specify", basically. Each sheet houses a fixed 65536 rows, 256 cols. But there are ways to make the sheet's appearance focused only on say, the range A1:P30, via either colouring "excess" rows to the right and cols below with gray fill, for instance, or, by hiding away "excess" rows / cols. And we could also "restrict scrolling" by freezing panes with say, Q31 selected (Freeze via Window Freeze Panes). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
Excel not taking number format consistently | Excel Discussion (Misc queries) | |||
What is the maximum number of rows in an Excel spreadsheet ? | Excel Discussion (Misc queries) | |||
Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions |