Insert rows without deleting empties?

Question

Excel 2007:   If create a small worksheet (4 columns by 35 rows), there is no way to insert new rows.  In order to insert a row, I have to go to the last entry and delete a bunch of empty rows.  Every time I want to add rows, I have to go through the same thing.

This is stupid.  How do I avoid it?

b)  Is here any way to avoid having the first row designated as column headings?

c) How can I select only the actual worksheet -- eg. only rows/cells with information.  When I print, I get a hundred pages of blank.  How do I avoid that?  Is there some easy way to select what I actually have there -- preferrably through the UI (as opposed to some keyboard sequence).

Answer 1

I bet you have some kind of data in the very last row(s) of the worksheet.

To remove theese data follow the steps below;

Select the full row under your data, ie row 40 then

CTRL+SHIFT and tap End to select all rows below

Right click any selected row and click Delete > Entire Row

You can hide row/column headings:

Click the office button > Excel settings > Advanced > In Display options for this worksheet, uncheck 'Show row and columnheadings'.

To print a part of the worksheet, select the range to print, goto Print > Select 'Print selection'

/Per

Answer 2

a) Sounds like you have some content in the rows below the data.

Select the entire row below the data (click on its row number) and Ctrl+Shift+Down arrow to select to the bottom of the worksheet

Home > Clear > Clear All

b) If the top row contains the same type of data as the following rows and is formatted the same then Excel is less likely to guess that it is a header row.

Some operations require a header row (e.g. filtering).

c) Probably cured by (a), but otherwise Ctrl+* to select the region containing data

Page Layout > Print Area > Set Print Area

---

Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk