how do i delete the extra empty rows and columns that i dont need.

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

Guest

I want to limit the size of the worksheet to include only the rows & columns
that I need.

Thanks in advance
 
You can't change the number of rows or columns. What do you want to do?
Prevent the user from scrolling past the used area? Prevent him from selecting
a cell outside of a certain range?
 
Ah. I see that Myrna is right about what you're asking. What you CAN do is
HIDE all the unnecessary rows and columns by selecting them, and then
Format_-->Row (or Column)-->Hide
*******************
~Anne Troy

www.piersontech.com
www.mrexcel.com
 
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

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
Deleting unneeded rows and columns 1
How to Delete Extra Cells and Columns 2
Excel Help to copy information from one row at a time to another sheet 1
Delete row with empty cell in column 3
Delete extra empty rows 2
rows and columns on worksheet 1
I cannot delete the extra rows or columns in Excel 2007 2

Back
Top