View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Eclectic Creations & Collectibles
 
Posts: n/a
Default 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