If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
Is Powerpoint still a single instance app? | Howard Kaikow | Powerpoint | 99 | June 16th, 2005 04:09 PM |
Automatically up date time in a cell | Mark | General Discussion | 5 | May 12th, 2005 12:26 AM |
clock | Wildman | Worksheet Functions | 2 | April 26th, 2005 10:31 AM |
Blank address book lines in list when sending e-mails | Sue | General Discussion | 0 | September 7th, 2004 05:19 AM |