Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
Format cells with a formula (7 conditions). | Excel Discussion (Misc queries) | |||
Very basic question - how long can a list be? | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
Bold Grid Lines | Excel Discussion (Misc queries) |