Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eclectic Creations & Collectibles - 08 Jan 2006 20:16 GMT
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.
Barb Reinhardt - 08 Jan 2006 20:21 GMT
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.

>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
[quoted text clipped - 8 lines]
> not
> happening.  Your help would be appreciated.
Eclectic Creations & Collectibles - 09 Jan 2006 06:42 GMT
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 can number each row by adding a column and putting in =row() in that
> column of data.
[quoted text clipped - 13 lines]
> > not
> > happening.  Your help would be appreciated.
Debra Dalgleish - 09 Jan 2006 02:24 GMT
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.

> 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
[quoted text clipped - 4 lines]
> I've really tried to find the answer to such a simple question, but it's not
> happening.  Your help would be appreciated.

Signature

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

Eclectic Creations & Collectibles - 09 Jan 2006 06:46 GMT
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

> To quickly select the entire list:
> Select a cell in the list
[quoted text clipped - 23 lines]
> > 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 - 09 Jan 2006 13:33 GMT
You're welcome! If you get stuck again, just post another question.

> 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
[quoted text clipped - 29 lines]
>>>I've really tried to find the answer to such a simple question, but it's not
>>>happening.  Your help would be appreciated.

Signature

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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.