Grid Lines

elaway

New Member
Joined
Dec 21, 2009
Messages
21
I am new here and to Excel.
And I would like to thank each of you for this great forum and what you do.

I have created a simple spreadsheen which consists of (9) columns and (20) rows.
I have shaded (5) of the columns in different colors. When I was working on this I somehow was able to then create a black lined grid over the color shaded area by clicking in the corner and dragging what looked like a pen or drawing tool across the entire spread sheet.Unfortunately I have now forgotten how I did this.

Also in the cells I need to input numbers, but ........... If I put say 306, I can center it and it's fine. But if I use 036, it always deletes the zero. I can't seem to use any number that beging with zero without having the zero deleted if it's in the first position.

I will appreciate any help you care to offer.
 

albasheer

Board Regular
Joined
Dec 14, 2009
Messages
159
Are you using Excel 2003 or 2007?

In 2007 go to the Font group under "Home" on the ribbon and you will see just to the right of Bold, italic, and underlined options an icon showing a pen held to a sheet. Click the drop down arrow in the icon and you will see the "Draw Border" tool.
 
Last edited:

albasheer

Board Regular
Joined
Dec 14, 2009
Messages
159
To keep the zero from disappearing insert an apostrophe before the number.

Example: '0123

It forces the number to be treated as text.
 

elaway

New Member
Joined
Dec 21, 2009
Messages
21
Thank you so much albasheer.
Sorry I forgot to mention the version which is 2007.

I applied both your answers and they worked like a charm. Exactly what I needed.

elaway :)
 

Forum statistics

Threads
1,082,333
Messages
5,364,675
Members
400,810
Latest member
elbashka

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top