How do I add grid lines to a LONG list with 3 columns?

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

Guest

I am trying to switch from my old PC that used works to this new
Hewlett-Packard that uses Excel. When I downloaded my file of this use list
of library books (Column 1 = Author's last name, Column 2 = authors 1st name,
Column 3 = Book title), it didn't include the grid lines to separate the
columns and the rows (of which there are over 1,000). How do I get it to do
so?....and, how do I get it to keep each row numbered?
I've really tried to find the answer to such a simple question, but it's not
happening. Your help would be appreciated.
 
You can number each row by adding a column and putting in =row() in that
column of data.

Select the affected cells and add borders to them.

"Eclectic Creations & Collectibles" <Eclectic Creations &
(e-mail address removed)> wrote in message
news:[email protected]...
 
To quickly select the entire list:
Select a cell in the list
On the keyboard, hold the Ctrl key, and on the number keypad,
press the * key

To add a border to the selected cells:
Click the arrow to the right of the Borders button on the
Excel formatting toolbar.
Click the All Borders button, the second button in the last row.

To add numbers to the rows:
In the first cell in column 2, type a 1
In the cell below, type a 2
Select both cells
Point to the fill handle -- the small black square at the bottom right
of the selection
When the pointer changes to a black plus sign, double-click
The numbers will fill down to the last row of data.
 
Thank you so much for taking the time to help me. Got the numbering of the
rows down! -- but I was hoping to avoid having to manually add borders to
each row.... there's so much to learn. I appreciate your help. Ayn
 
You really gave great, detailed information .... much appreciated ... haven't
tried doing it yet cause I'll need more time and it's way late here right
now. But, I'm looking forward to tomorrow and putting your suggestions into
action. I'll let you know. Again, thank you for taking the time to lend a
hand. Ayn Phillips
 
Back
Top