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

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.

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

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 &
wrote in message
...
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.

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

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.

Eclectic Creations & Collectibles wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

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

"Barb Reinhardt" wrote:

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 &
wrote in message
...
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.

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

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

"Debra Dalgleish" wrote:

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.

Eclectic Creations & Collectibles wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

You're welcome! If you get stuck again, just post another question.

Eclectic Creations & Collectibles wrote:
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

"Debra Dalgleish" wrote:


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.

Eclectic Creations & Collectibles wrote:

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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html