restrict visible cells on a sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am using excel 2003 and i would like to only see up to column G and as far
down as row 135. i dont want to see anything else including row and column
headings. i know how to use hide to do this but i would like the method to be
intelleigent enough to know that if i attempt to add data past the last row
it should allow me to and unhide the next row. can this be done??
 
If you hide rows and columns, then how could you move your cursor into
a hidden cell to try to add data? You could insert row(s) or
column(s), and then you would be able to enter more data.

Hope this helps.

Pete
 

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 Help to copy information from one row at a time to another sheet 1
Cannot unhide the hidden rows in my spreadsheet 3
hide, unhide column or row after protect worksheet 4
Having Blank Cells, etc. ? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Unhide a row 1
Hide a visible rows 5
Pasting into a filtered sheet 3

Back
Top