Range of a spreadsheet

**SpringLily** · 10-19-2010, 06:05 AM

Hi, there
I have a spreadsheet as the attached. The row and column number are both limited to a certain number and the area beyond the maximum row and column cannot be selected, and the worksheet is not protected. How to make the sheet behave like this? Can anyone help please? Thanks.

**grizzly6969** · 10-19-2010, 06:26 AM

not sure exactly what,s wrong

**SpringLily** · 10-19-2010, 06:28 AM

It is designed that way.

**royUK** · 10-19-2010, 06:30 AM

Hide the columns

Select the first column to hide
Select the columns to the right by using Ctrl+Shift+Right arrow
Format -> Columns -> Hide

Similar will hide rows

Select the first row to hide
Select the rows to the bottom by using Ctrl+Shift+Down arrow
Format -> Rows -> Hide

**squiggler47** · 10-19-2010, 06:31 AM

Just Highlight the column headers you dont want and right click, select hide same with the rows!

And Voila, you have the same effect!

**BlastRanger** · 10-19-2010, 06:38 AM

That's cause by all the column after the J is Hidden.

You can unhide it by select column J to the column that are hidden

See picture in my attachment to see more how to select

**SpringLily** · 10-19-2010, 06:42 AM

Thanks All. I know how to hide and unhide now. Lily. :-)

**royUK** · 10-19-2010, 06:43 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save