View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default HOW TO HIDE ALL EXTRA ROW AND COLUMNS

dvalderrama wrote:
i want to hise the rest of the worksheet for example i have a gride that is
like 20 cells by 20 cell, how can i just have that one boxe showing instead
of the whole worksheet like column bb or row 223. i just want to keep it in
range that i need


First, select the columns you want to hide. You can do this by clicking on the
first column letter that you want hidden and then holding down the Shift and
Ctrl keys and hitting the right-arrow key. Then select Format / Column / Hide.

The second step should be pretty obvious...
 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.