how do i set to only see chosen rows and columns in excel

  • Thread starter Thread starter Rasput1m
  • Start date Start date
R

Rasput1m

instead of the sheet running on forever in columns and rows - which can be
more than inconvenient especially in a big spreadsheet - i have recently seen
a worksheet where all i could <<see>> and / or <<select>> was a predetermined
set of rows and columns e.g $A$1:$G$17562

how do i do this?
 
You can't delete those unused rows and columns, but you can hide them.

Click on the identifier at the top of column H to highlight it, then
hold the <shift> key down and press <end> once forllowed by <right
arrow>, then release <shift>. You can now click on Format | Columns |
Hide then OK so that you will only be able to "see" columns A to G.
You can do a similar thing to hide unused rows.

Hope this helps.

Pete
 
mujik! thats the puppy!

simple when you know how..;-)

tks muchly
 
You can also set the ScrollArea by code so's users cannot wander outside the
range you choose.

If interested see here for code and instructions.

http://tinyurl.com/4jg5vl



Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
sumif only seeing one row 3
Excel sheet with numbers as column & row headers - How? 3
copying some rows and columns 21
I cannot delete the extra rows or columns in Excel 2007 2
Expand and Shrink Rows and columns to hide information. 1
Make Excel see columns as rows and rows as columns 3
Keyboard shortcut to select a column? 7

Back
Top