Why if I insert a blank row in a sheet does the auto complete, for

  • Thread starter Thread starter Guest
  • Start date Start date
I have built a spreadsheet that uses the same names over and over but because
I have an empty row between each pair of entries, the text doesn't fill in
automatically when I start typing in a cell below a blank row.

Any ideas?
 
Yes, adding blank rows fouls up more than one thing in Excel. If the blank row
is there for cosmetic purposes -- to provide space, get rid of the blank rows,
then adjust the row height for the 1st entry of each pair.
 
Thanks for the help - it won't look as good without the blanks, but.....
 
If you adjust the row height it will look EXACTLY the same as with the blanks.
 
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

Insert blank rows 2
Row height setting problem 8
The next Grand Theft Auto title has been officially announced 0
Insert Row 2
Inserting a blank row after subtitle row 3
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
auto hide blank rows 1
auto complete not working 3

Back
Top