Unwanted cells at end of document rows and columns

  • Thread starter Thread starter Big Dog
  • Start date Start date
B

Big Dog

How do I eliminate unwanted rows and columns to right and bottom of my
document ?

Jeffrey S
 
Hi Jeffrey ! :)
You could hide columns to the right and rows at below
your data area. But you can't get rid of the unfilled rows and columns
altogether.


Vijay
 
Vijay,
That works fine for the columns. I can get to the end. But for the rows it
seems to be an infinity of rows.

Jeffrey S
 
Jeffrey ! :)
To hide the rows below your data area - 1.Select the
topmost row below your data. Hold down Ctrl & Shift and press the down arrow.
That selects the rows below your data area right down to the last row. Now
right click and hide.


Vijay
 
Thanks so much that works great !
--
Jeffrey S


Vijay Chary said:
Jeffrey ! :)
To hide the rows below your data area - 1.Select the
topmost row below your data. Hold down Ctrl & Shift and press the down arrow.
That selects the rows below your data area right down to the last row. Now
right click and hide.


Vijay
Click to expand...
 

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

Eliminating unwanted columns and eEntering data using Barcode Scan 2
How do I delete rows based on a category? 1
Formatting an excel worksheet to create a form 4
I cannot delete the extra rows or columns in Excel 2007 2
remove excess (unwanted) rows from the bottom of a speadsheet 3
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 unwanted Cells 3
How do you reset the position that pressing CTRL-END moves you to? 2

Back
Top