How can I enlarge the spacing between rows in a spreadsheet?

N

Norwood

The text in each of my spreadsheet rows appears too close to each other. How
can I automatically put space between each row in a large spreadsheet. Can
the horizontal gridlines be broadened? I don't want to add blank rows
between data rows because of formatting and formula issues.
 
J

JR Hester

Change the row hieght.
Select the rows,
Format> Rows> Hieght--set to a larger number
 
J

JohnExcel

I usually click the row(s), carefully move the mouse over the row-number of
one of the rows until the mouse pointer icon changes to a vertical-resize
icon, then double-click. That AutoFits the selected row(s). (To select
several scattered rows, hold down Ctrl key.)
 

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

how to delete some rows without data which comes in between rows with data 4
How do I remove the top half of a block interval? 1
How do I automatically compare 2 versions of a spreadsheet 1
Deleting/removing unused rows in a worksheet 3
how to insert serial numbers to rows? 3
How do I insert a row or rows between each row of text and copy the row above? 0
How do I free up the space occupied by empty rows? 2
Excel wrapped rows, want automatically leave some space bottom of 1

Top